8 : SELECT *
9 : FROM corpnews_subcategories
10 : WHERE corpnews_subcategories.corpnews_catid = <cfqueryparam value="#URL.corpnews_catid#" cfsqltype="CF_SQL_INTEGER">
11 : AND corpnews_subcategories.corpnews_scatshow <> 'No'
12 : ORDER BY corpnews_scatposition ASC, corpnews_scatid Asc
|