load cues

SELECT DISTINCT `CHOREOLAST` FROM `cues` ORDER BY `CHOREOLAST` ASC

load cues

SELECT * FROM `rhytm` where `RID` != 0 ORDER BY `RNAME` asc


load cues

SELECT c1.`CSONG`, concat(c1.`CHOREOFIRST`, ' ' ,c1.`CHOREOLAST`) AS `choreographer`, c1.`PHASE`, c1.`PLUS`, r1.`RNAME`, r2.`RNAME`, c1.`CUED_SH`, c1.`CUED_LG`, c1.`CHOREOLAST` FROM `cues` as c1, `rhytm` as r1 , `rhytm` as r2 WHERE (c1.`RHYTMA` = r1.`RID` and c1.`RHYTMB` = r2.`RID`) ORDER BY c1.`CSONG`