Untitled query #66333

SQL

select count(rc_id) as edits, rc_namespace as ns, rc_title as title
from recentchanges_userindex
where (rc_namespace = 118 or rc_namespace = 2 or rc_namespace = 0)
  and (rc_title like "%彰化%") and (rc_title like "%國小%" or rc_title like "%國民小學%" or rc_title like "%國中%" or rc_title like "%國民中學%")
  and (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -30 DAY) )
group by title order by edits desc;

select count(rc_id) as edits, rc_namespace as ns
from recentchanges_userindex
where (rc_namespace = 118 or rc_namespace = 2 or rc_namespace = 0)
  and (rc_title like "%彰化%") and (rc_title like "%國小%" or rc_title like "%國民小學%" or rc_title like "%國中%" or rc_title like "%國民中學%")
  and (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -30 DAY) )
group by ns order by edits desc;
SQL

Checking query status...
