4 : WHERE corpnews_subcatlinks.corpnews_scatid = corpnews_subcategories.corpnews_scatid
5 : AND corpnews_subcategories.corpnews_catid = corpnews_categories.corpnews_catid
6 : AND corpnews_subcatlinks.corpnews_scatlinkid = <cfqueryparam value="#URL.corpnews_scatlinkid#" cfsqltype="CF_SQL_INTEGER">
7 : AND corpnews_subcatlinks.corpnews_scatlinkshow = 'Yes'
8 : ORDER BY corpnews_scatlinkposition ASC, corpnews_scatlinkid DESC
|