SELECT Listings.StationID, Listings.ListingID, Listings.ListDateTime, Listings.LeagueID, Listings.NewShow,
Shows.ShowName, Shows.ShowName2, Shows.ShowName3, Shows.ShowTitle, Shows.ShowTypeID, Shows.ShowID, Shows.BreakoutIncludeLevel
FROM Listings INNER JOIN Shows ON Listings.ShowID = Shows.ShowID
WHERE (Listings.StationID = 91 OR Listings.StationID = 6 OR Listings.StationID = 41 OR Listings.StationID = 88 OR Listings.StationID = 34 OR Listings.StationID = 42 OR Listings.StationID = 39 OR Listings.StationID = 18 OR Listings.StationID = 10 OR Listings.StationID = 43 OR Listings.StationID = 14 OR Listings.StationID = 416 OR Listings.StationID = 613 OR Listings.StationID = 2071 OR Listings.StationID = 522 OR Listings.StationID = 293 OR Listings.StationID = 36 OR Listings.StationID = 45 OR Listings.StationID = 92 OR Listings.StationID = 89 OR Listings.StationID = 419 OR Listings.StationID = 17 OR Listings.StationID = 15 OR Listings.StationID = 74 OR Listings.StationID = 64 OR Listings.StationID = 279 OR Listings.StationID = 73 OR Listings.StationID = 1204 OR Listings.StationID = 4311 OR Listings.StationID = 3 OR Listings.StationID = 70 OR Listings.StationID = 169 OR Listings.StationID = 82 OR Listings.StationID = 295 OR Listings.StationID = 167 OR Listings.StationID = 120 OR Listings.StationID = 62 OR Listings.StationID = 59 OR Listings.StationID = 321 OR Listings.StationID = 16 OR Listings.StationID = 359 OR Listings.StationID = 159 OR Listings.StationID = 162 OR Listings.StationID = 192 OR Listings.StationID = 4179 OR Listings.StationID = 153 OR Listings.StationID = 53 OR Listings.StationID = 193 OR Listings.StationID = 336 OR Listings.StationID = 161 OR Listings.StationID = 3561 OR Listings.StationID = 164 OR Listings.StationID = 300 OR Listings.StationID = 1031 OR Listings.StationID = 198 OR Listings.StationID = 163 OR Listings.StationID = 8 OR Listings.StationID = 23 OR Listings.StationID = 294 OR Listings.StationID = 60 OR Listings.StationID = 160 OR Listings.StationID = 127 OR Listings.StationID = 309 )
AND (Listings.ListDateTime < '2007-11-14 21:00:00') AND (Listings.ListDateTime > '2007-11-14 15:00:00')
ORDER BY Listings.ListDateTime DESC
)
UNION
(
SELECT Listings.StationID, Listings.ListingID, Listings.ListDateTime, Listings.LeagueID, Listings.NewShow,
Shows.ShowName, Shows.ShowName2, Shows.ShowName3, Shows.ShowTitle, Shows.ShowTypeID, Shows.ShowID, Shows.BreakoutIncludeLevel
FROM Listings INNER JOIN Shows ON Listings.ShowID = Shows.ShowID
WHERE (Listings.StationID = 91 OR Listings.StationID = 6 OR Listings.StationID = 41 OR Listings.StationID = 88 OR Listings.StationID = 34 OR Listings.StationID = 42 OR Listings.StationID = 39 OR Listings.StationID = 18 OR Listings.StationID = 10 OR Listings.StationID = 43 OR Listings.StationID = 14 OR Listings.StationID = 416 OR Listings.StationID = 613 OR Listings.StationID = 2071 OR Listings.StationID = 522 OR Listings.StationID = 293 OR Listings.StationID = 36 OR Listings.StationID = 45 OR Listings.StationID = 92 OR Listings.StationID = 89 OR Listings.StationID = 419 OR Listings.StationID = 17 OR Listings.StationID = 15 OR Listings.StationID = 74 OR Listings.StationID = 64 OR Listings.StationID = 279 OR Listings.StationID = 73 OR Listings.StationID = 1204 OR Listings.StationID = 4311 OR Listings.StationID = 3 OR Listings.StationID = 70 OR Listings.StationID = 169 OR Listings.StationID = 82 OR Listings.StationID = 295 OR Listings.StationID = 167 OR Listings.StationID = 120 OR Listings.StationID = 62 OR Listings.StationID = 59 OR Listings.StationID = 321 OR Listings.StationID = 16 OR Listings.StationID = 359 OR Listings.StationID = 159 OR Listings.StationID = 162 OR Listings.StationID = 192 OR Listings.StationID = 4179 OR Listings.StationID = 153 OR Listings.StationID = 53 OR Listings.StationID = 193 OR Listings.StationID = 336 OR Listings.StationID = 161 OR Listings.StationID = 3561 OR Listings.StationID = 164 OR Listings.StationID = 300 OR Listings.StationID = 1031 OR Listings.StationID = 198 OR Listings.StationID = 163 OR Listings.StationID = 8 OR Listings.StationID = 23 OR Listings.StationID = 294 OR Listings.StationID = 60 OR Listings.StationID = 160 OR Listings.StationID = 127 OR Listings.StationID = 309 )
AND (Listings.ListDateTime >= '2007-11-14 21:00:00') AND (Listings.ListDateTime <= '2007-11-15 00:58:59')
)