[PhilB]

Виноват, верно так:

Код:

SELECT them.msg, COUNT(komm.id_them) AS komm_count FROM them
INNER JOIN komm ON komm.id_them = them.id 
GROUP BY komm.id_them  
ORDER BY komm_count ;