LECOM Degrees

(SELECT Client_ID, Account_ID, Content_ID, Headline, SubHead, URLLink, AvailableDate, DateLine, ContentCategory_ID, 0 + SortOrder as SO FROM mgContent WHERE ContentCategory_ID = 24067 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 = 24262 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 = 28869 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 = 24265 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 = 24271 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 = 24268 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 = 26934 AND Client_ID = 76 AND isComment <> 1 AND (isModerated = 0 OR (isModerated = 1 AND ApprovedByUser <> 0)))  ORDER BY SO ASC