尝试创建一个mysql查询,在其中计算筛选器数据库的名称。成功,从某个时期取名字是主要目标。
$query = query("
SELECT count(CASE WHEN filter='å¬è¶ããã(ç¾å¨å°æ¤ç´¢)' THEN 1 END) as filter,
count(CASE WHEN filter='éè±æã§é¸ã¶' THEN 1 END) as filter2,
count(CASE WHEN filter='æ¥å½ããã§é¸ã¶' THEN 1 END) as filter3,
count(CASE WHEN filter='æ ªå¹
ã§é¸ã¶' THEN 1 END) as filter4,
count(CASE WHEN filter='èä¸ã§é¸ã¶' THEN 1 END) as filter5,
count(CASE WHEN filter='æ©è½ãã¿ã¤ãã§é¸ã¶' THEN 1 END) as filter6,
count(CASE WHEN filter='ãã®ãã¼ãããã' THEN 1 END) as filter7 FROM
filter_clicked WHERE filter_date < DATEADD(day, -30, GETDATE())");
