Welcome back to school, Middies! Here is your one-stop shop for all device pick-up times and open house dates/times. Remember: The HIGH SCHOOL will also have picture day during device pick-up.
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` <= '2022-08-13' AND `EntryEndDate` >= '2022-08-13' OR `EntryStatus` = 'published' AND `tbl-district-news-EntryPage`.`PageRowID` = '75' AND `EntryDate` <= '2022-08-13' AND `EntryEndDate` = '0000-00-00'
UNION
SELECT *
FROM `tbl-middletown-high-school-news-Entry`
WHERE `EntryStatus` = 'published' AND `EntryDate` <= '2022-08-13' AND `EntryEndDate` >= '2022-08-13' OR `EntryStatus` = 'published' AND `EntryDate` <= '2022-08-13' AND `EntryEndDate` = '0000-00-00'
ORDER BY `EntryFeatured` DESC, `EntrySortOrder`, `EntryDate` DESC
LIMIT 0,2