Anunturi
-
SELECT a.*, COUNT(*) AS piccount, u.fisier, j.nume as nume_judet
FROM anunturi a
LEFT OUTER JOIN poze_anunt u ON a.anunt_id = u.anuntID
JOIN judet j on a.judet_id = j.judet_id and j.judet_id=
GROUP BY a.anunt_id
ORDER BY a.anunt_id DESC
LIMIT 50 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY a.anunt_id
ORDER BY a.anunt_id DESC
LIMIT 50' at line 5