You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND sinoptico='A' AND stop_id=stops.id) nA, (SELECT COUNT(*) FROM sinoptic' at line 7