Sub query ORDER BY su 2 tabelle

[Skillsfactory]

ok ho messo order prima di group by... prova così...

SELECT a.id, a.titolo, COUNT(l.id_articolo) AS NumeroLike
FROM articolo AS a
LEFT JOIN _like AS l ON (l.id_articolo = a.id)
WHERE $liket
GROUP BY a.id
ORDER BY NumeroLike DESC
LIMIT 0,5