LECOM Pathways

(SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 0 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24112 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 10000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24280 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 20000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24283 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 30000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24286 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 40000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24289 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 50000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 27817 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 60000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24292 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 70000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 28866 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 80000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24295 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 90000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24478 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 100000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 26931 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0))) UNION (SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 110000 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24352 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0)))  ORDER BY SO ASC