ضربات المرشحات في اخر اسبوع حسب حسب كل يوم

SQL

SELECT
    DATE(afl_timestamp) AS day,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 6 THEN 1 ELSE 0 END) AS day7,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 5 THEN 1 ELSE 0 END) AS day6,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 4 THEN 1 ELSE 0 END) AS day5,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 3 THEN 1 ELSE 0 END) AS day4,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 2 THEN 1 ELSE 0 END) AS day3,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) - 1 THEN 1 ELSE 0 END) AS day2,
    SUM(CASE WHEN DAY(afl_timestamp) = DAY(NOW()) THEN 1 ELSE 0 END) AS day1,
    afl_filter_id,
    abuse_filter.af_public_comments AS nameof_filter
FROM
    abuse_filter_log 
INNER JOIN
    abuse_filter ON abuse_filter.af_id = abuse_filter_log.afl_filter_id
WHERE
    afl_timestamp >= NOW() - INTERVAL 1 WEEK
    AND abuse_filter.af_enabled = 1
    -- AND abuse_filter.af_hidden = 0
    AND abuse_filter.af_deleted = 0
    -- AND abuse_filter.af_hit_count > 0
GROUP BY
    day, afl_filter_id
ORDER BY
    afl_filter_id, day;
SQL

Checking query status...
