SELECT pagename, name, subtitle, directoryname, pic, pic_caption, datefrom, dateto, programmepages.programmeid, includefile, descriptor, programmes.status AS programmestatus, includeform, leftcolumnpic, leftcolumnpic_caption, progheader, which_form_items, form_filename, print_friendly_text FROM programmepages LEFT OUTER JOIN programmes ON (programmes.programmeid = programmepages.programmeid) WHERE pageid = '#request.pageid#' LIMIT 1 SELECT pagename, filename, target, includeform, form_filename FROM programmepages WHERE programmeid = '#getpage.programmeid#' AND in_menu = 'Y' SELECT name, subtitle, directoryname, pic, pic_caption, datefrom, dateto FROM programmes WHERE status = 'Y' AND programmeid <> '#request.progid#' ORDER BY ranking

Other Programmes
<cfif leftcolumnpic_caption is not #leftcolumnpic_caption#">