SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, SortOrder FROM mgContent WHERE ContentCategory_ID = 27955 AND Client_ID = 238 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0)) ORDER BY SortOrder