SELECT Product.productid, count(Product.itemid) as total
FROM `Product`
WHERE DATE(Product.datecreated) >= ADDDATE(NOW(), INTERVAL -1 DAY)
GROUP BY Product.productid
ORDER BY total DESC
LIMIT 0,10