SELECT t1.id AS id_articulo, data, YEAR(data) AS any, id_minisite, titular_en AS titular, text_en AS text,
(
SELECT COUNT(id)
FROM articles_comentaris
WHERE id_article = id_articulo
AND actiu = '1'
) AS num
FROM articles t1
INNER JOIN articles_tags t2 ON t1.id = t2.id_article
WHERE t1.actiu = '1'
AND t1.titular_en IS NOT NULL
AND t2.id_tag = '642talà de l'any'
ORDER BY data DESC, id_articulo DESC 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 'any'
ORDER BY data DESC, id_articulo DESC' at line 12
