Calendar

Annual Convention Workshop Proposals

SELECT dbo.items.itemskey, dbo.items.programtitle AS title, dbo.itemtype.itemgroup, dbo.itemstimes.itemtimetext2, dbo.items.itemorder AS sortOrder, dbo.items.itemtypekey AS type, dbo.items.synopsis, dbo.items.itemlocation, dbo.items.shortpresenter, dbo.items.isnotonglance, dbo.items.feerequired, dbo.items.seperateregreq, dbo.items.speakerphoto, dbo.items.htmlpage AS link, dbo.itemstimes.itemstartdate AS startDate, dbo.itemstimes.itemstimeskey, dbo.itemstimes.itemstarttime AS startTime, dbo.itemstimes.itemdatetext AS day, dbo.itemstimes.itemtimetext AS time, dbo.itemstimes.repeated, dbo.itemstimes.continued FROM (dbo.items INNER JOIN dbo.itemtype ON dbo.items.itemtypekey = dbo.itemtype.itemtypekey) LEFT JOIN dbo.itemstimes ON dbo.items.itemskey = dbo.itemstimes.itemskey WHERE dbo.items.curryear ='' AND (dbo.items.isnotonglance = 0) ORDER BY dbo.itemstimes.itemstartdate, dbo.itemstimes.itemstarttime, dbo.items.itemorder;
tt0