Error in count items query! SELECT count(*) as itemNum FROM leonardo_flights,leonardo_waypoints WHERE (1=1) AND DATE_FORMAT(DATE,'%Y') = 2002 AND ( excludeFrom & 1 ) = 0 AND userID>0 AND takeoffID='9148' AND leonardo_flights.BEST_FLIGHT_TYPE='FREE_FLIGHT' AND (private=0 OR private=4 ) AND ( DATE_FORMAT(DATE,'%Y%m') = '201411' ) AND leonardo_pilots.Birthdate = '1978-06-01' AND leonardo_pilots.Birthdate <> '' AND leonardo_flights.cat & 2 AND leonardo_flights.category = 2 AND leonardo_pilots.Sex='M' AND LINEAR_DISTANCE >= 50000 AND leonardo_flights.takeoffID=leonardo_waypoints.ID AND leonardo_waypoints.countryCode='FR'