Select Top 15 tblPages.fldPageUID, fldPageOrder, fldTitle, fldPageIntro, fldStatusID, fldPagePic, fldElements, fldChaIDs, fldCatIDs, fldTrackCode, fldPageAuthorID, fldEvents, fldEventsSubTitle, fldRedir, fldUrl, fldPublished, fldStartDate, fldCreatedTime from tblPages inner join tblChannelItems on tblPages.fldPageUID = tblChannelItems.fldPageUID where (fldStartDate<=getdate() and fldEndDate>=getdate()) and fldStatusID=1 and (fldChaIDs LIKE '%*1591*%') and fldChannelID=1591 group by tblPages.fldPageUID, fldPageOrder, fldTitle, fldPageIntro, fldStatusID, fldPagePic, fldElements, fldChaIDs, fldCatIDs, fldTrackCode, fldPageAuthorID, fldEvents, fldEventsSubTitle, fldRedir, fldUrl, fldPublished, fldStartDate, fldCreatedTime order by fldPageOrder Desc, fldCreatedTime Desc