SELECT tblItems.id, Count(tblCommenti.IDitem) AS ConteggioDiid
FROM tblItems LEFT JOIN tblCommenti ON tblItems.id = tblCommenti.IDitem
GROUP BY tblItems.id
ORDER BY Count(tblItems.id);