How many metrics received per item

SELECT p.host, h.clock, h.itemid, i.key_, count(*) AS cnt FROM history h, items i, hosts p WHERE h.itemid = i.itemid AND i.hostid = p.hostid GROUP BY h.itemid ORDER BY cnt DESC;