Hiselect trips.*, count(distinct manifest.manifest_id) as anglers from boats, trips
left join manifest on manifest.trip_id=trips.trip_id WHERE
trips.boat_id=boats.boat_id AND
trips.trip_id = '43912' AND
trips.landing_id = '54' AND
trips.trip_date > CURDATE()-1 AND
trips.online = 'yes' AND
trips.cancelled = 'NO' AND
trips.type != 'charter'
GROUP BY trips.trip_id
Error - Invalid Page
