SELECT `tbl-district-news-Entry`.`EntryRowID`, `EntryStatus`, `EntrySaved`, `EntryFeatured`, `EntryTitle`, `EntryDate`, `EntryEndDate`, `EntrySortOrder`, `EntryTags`, `EntryAbstract`, `EntryPreview`, `EntryPageH1Tag`, `EntryPermaLink`, `EntryPageTitle`, `EntryPageKeywords`, `EntryPageDescription`, `EntryCreatedDTTM`, `EntryDirectory` FROM `tbl-district-news-Entry` INNER JOIN `tbl-district-news-EntryPage` ON `tbl-district-news-EntryPage`.`EntryRowID` = `tbl-district-news-Entry`.`EntryRowID` WHERE `EntryStatus` = 'published' AND `tbl-district-news-EntryPage`.`PageRowID` = '75' AND `EntryDate` <= '2021-11-27' AND `EntryEndDate` >= '2021-11-27' OR `EntryStatus` = 'published' AND `tbl-district-news-EntryPage`.`PageRowID` = '75' AND `EntryDate` <= '2021-11-27' AND `EntryEndDate` = '0000-00-00' UNION SELECT * FROM `tbl-middletown-high-school-news-Entry` WHERE `EntryStatus` = 'published' AND `EntryDate` <= '2021-11-27' AND `EntryEndDate` >= '2021-11-27' OR `EntryStatus` = 'published' AND `EntryDate` <= '2021-11-27' AND `EntryEndDate` = '0000-00-00' ORDER BY `EntryFeatured` DESC, `EntrySortOrder`, `EntryDate` DESC LIMIT 0,2

1 = currentCategoryID

= currentSubcategoryID