SELECT DISTINCT strTitle,tblNews.itemid,dtDocument,strSummary,blnDisplayDate
FROM tblNews INNER JOIN vwSMOCitem ON tblNews.itemid = vwSMOCItem.itemid
WHERE sectionname = '#sectionname#' AND description = 'News'
AND dtViewable <=#Now()#
AND dtArchive >= #Now()#
AND dtExpiry >=#now()# AND approved = 1
AND parentid in (select categoryid from tblCategory where
description='#request.charter#')
ORDER BY dtDocument DESC,strTItle
SELECT DISTINCT strTitle,tblNews.itemid,dtDocument,strSummary,blnDisplayDate
FROM tblNews INNER JOIN vwSMOCitem ON tblNews.itemid = vwSMOCItem.itemid
WHERE sectionname = '#sectionname#' AND description = 'News'
AND dtViewable <=#Now()#
AND dtArchive >= #Now()#
AND dtExpiry >=#now()# AND approved = 1
AND parentid in (select categoryid from tblCategory where
description='National')
ORDER BY dtDocument DESC,strTItle
| |
|
 |
|
|
