Sub query ORDER BY su 2 tabelle

[Skillsfactory]

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
ORDER BY NumeroLike DESC
GROUP BY a.id
LIMIT 0,5