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
[Magento SQL] 查询指定SKU一段时间范围内的浏览量
最新推荐文章于 2019-04-11 11:47:15 发布