Subversion Repositories VORC

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
222 - 1 
## View: v_class_coaches_current
2 
#
3 
# +-------------+-------------+------+-----+---------+-------+
4 
# | Field       | Type        | Null | Key | Default | Extra |
5 
# +-------------+-------------+------+-----+---------+-------+
6 
# | RCid        | varchar(45) | YES  |     | NULL    |       |
7 
# | derby_name  | varchar(45) | YES  |     | NULL    |       |
8 
# | class_count | varchar(29) | YES  |     | NULL    |       |
9 
# | classes     | mediumtext  | YES  |     | NULL    |       |
10 
# +-------------+-------------+------+-----+---------+-------+
11 
 
12 
CREATE OR REPLACE VIEW `v_class_coaches_current` AS select distinct `v_shift`.`RCid` AS `RCid`,`v_shift`.`derby_name` AS `derby_name`,concat_ws(' ',cast(count(0) as char charset utf8mb4),if(count(0) > 1,'Classes','Class')) AS `class_count`,group_concat(distinct `v_shift`.`note` separator ' | ') AS `classes` from `v_shift` where `v_shift`.`dept` = 'COA' and `v_shift`.`role` = 'Coach' and `v_shift`.`derby_name` <> '' and year(`v_shift`.`date`) = year(current_timestamp()) group by `v_shift`.`RCid`