Invalid query: Table 'nationalaquarium.cats' doesn't exist
Whole query: SELECT c.*, COUNT(e.eventID) AS listingCount FROM cats AS c LEFT JOIN events AS e ON c.catID = e.catID AND e.live = 1 AND ( ( e.startDate >= CURDATE() ) OR ( e.startDate <= CURDATE() AND e.endDate >= CURDATE() ) ) GROUP BY c.catID ORDER BY c.name