Untitled query #75408

SQL

#show tables;
/*
abuse_filter
abuse_filter_action
abuse_filter_history
abuse_filter_log
*/
/*
select af_id,af_public_comments from abuse_filter
where af_enabled = 1 and af_hidden = 0 and af_deleted = 0 and af_hit_count > 0
;
*/


select count(afl_filter_id), afl_filter_id,abuse_filter.af_public_comments from abuse_filter_log 
inner join abuse_filter on abuse_filter.af_id = abuse_filter_log.afl_filter_id
WHERE afl_timestamp >= NOW() - INTERVAL 30 DAY
# abuse_filter is enabled not hidden and not deleted and has hit 
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 afl_filter_id;


select * from abuse_filter_log
WHERE afl_timestamp >= NOW() - INTERVAL 30 DAY
limit 10;
SQL

Checking query status...
