Error on this query:SELECT * FROM (SELECT COUNT(year) as counter, year FROM ads WHERE makeID = 1838 AND modelID = AND sold = 0 AND active = 1 AND expireDate > DATE(NOW()) GROUP BY year ORDER BY year ASC) AS t3 WHERE counter > 0
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 sold = 0 AND active = 1 AND expireDate > DATE(NOW()) GROUP BY year ORDER BY ' at line 2

Classic Rolls-royce For Sale