[Magento SQL] 查询指定SKU一段时间范围内的浏览量

SELECT t1.added_at,t2.sku,COUNT(t1.product_id) as total_views FROM report_viewed_product_index AS t1
LEFT JOIN catalog_product_entity  AS t2 ON t2.entity_id=t1.product_id
WHERE t2.sku IN('Co-AP2013WH','Co-OP2829WH','Co-HW51665','Co-HW51511','Co-OP2808TN')
AND t1.added_at > ("2016-07-14 7:00:00") AND t1.added_at <= ("2016-07-15 7:00:00")
GROUP BY t1.product_id