我想数一下在购买前7天发生的登陆页面浏览量。我使用了这个查询并给出了一个错误
“无法从mysql.proc加载。该表可能已损坏”
SELECT count(l.customer_id) FROM customer_profiles.purchase p
left join landingpage_view lp on lp.customer_id = p.customer_id
where lp.datetime between date_sub(p.datetime(), INTERVAL 7 Day) and p.datetime()
and lp.customer_id =