use jawiki_p;

SELECT COUNT(*) AS edits,                                                                                   

       COUNT(DISTINCT rc_user) AS users,                                                                    

       COUNT(DISTINCT rc_cur_id) AS titles                                                                  

FROM recentchanges                                                                                          

WHERE rc_namespace = 0                                                                             

AND rc_type = 0

AND rc_user= 0

AND rc_timestamp > DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 7 DAY), '%Y%m%d%H%i%s');