Portugal (1367) Açores (4) Aveiro (48) Beja (7) Braga (49) Bragança (4) Castelo Branco (3)Coimbra (54) Évora (2) Faro (112) Guarda (2) Leiria (94) Lisboa (593) Madeira (4) Portalegre (3) Porto (206) Santarém (104) Setúbal (67) Viana do Castelo (3) Vila Real (3) Viseu (5)
  • Portugal
  • Coimbra
    • 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 a.cityid = 10 GROUP BY a.subcatid' at line 7SELECT scat.subcatid, scat.catid, COUNT(*) as adcnt FROM xzclf_ads a INNER JOIN xzclf_subcats scat ON scat.subcatid = a.subcatid AND (a.enabled = '1' AND a.verified = '1') INNER JOIN xzclf_cats cat ON cat.catid = scat.catid INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid WHERE scat.enabled = '1' AND scat.catid = AND a.cityid = 10 GROUP BY a.subcatid