USE enwiki_p;

SELECT page_title AS project, 

(SELECT rev_id #COUNT(*) 

 FROM revision 

 WHERE page_id = rev_page 

 AND rev_timestamp > (NOW() - INTERVAL 1 MONTH)) 

 AS countall,

(SELECT rev_id # COUNT(*) 

 FROM revision 

 LEFT JOIN actor ON rev_actor = actor_id 

 LEFT JOIN user_groups ON actor_user = ug_user 

 WHERE page_id = rev_page 

 #AND ug_user NOT IN (SELECT DISTINCT user_groups.ug_user FROM user_groups WHERE ug_group = 'bot') 

 AND rev_timestamp > (NOW() - INTERVAL 1 MONTH)) AS countnobot

 FROM page

WHERE page_title = 'WikiProject_Visual_arts'

AND page_namespace = 5 

AND page_is_redirect = 0;