Subversion Repositories VORC

## View: v_class_coaches

#

# +------------+-------------+------+-----+---------+-------+

# | Field      | Type        | Null | Key | Default | Extra |

# +------------+-------------+------+-----+---------+-------+

# | date       | date        | YES  |     | NULL    |       |

# | start_time | time        | YES  |     | NULL    |       |

# | location   | varchar(45) | YES  |     | NULL    |       |

# | coaches    | text        | YES  |     | NULL    |       |

# | cRCids     | text        | YES  |     | NULL    |       |

# +------------+-------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_class_coaches` AS select `v_shift`.`date` AS `date`,`v_shift`.`start_time` AS `start_time`,`v_shift`.`location` AS `location`,group_concat(`v_shift`.`derby_name` separator ' & ') AS `coaches`,group_concat(`v_shift`.`RCid` separator ' & ') AS `cRCids` from `v_shift` where ((`v_shift`.`dept` = 'COA') and (`v_shift`.`role` = 'Coach') and (isnull(`v_shift`.`derby_name`) = 0) and (`v_shift`.`derby_name` <> '')) group by `v_shift`.`location`,`v_shift`.`start_time`,`v_shift`.`date`