USE plwiki_p;

​

SELECT page_namespace, count(*)

FROM revision_actor_temp 

LEFT JOIN page on revactor_page = page_id

WHERE

-- actor_id

revactor_actor = 13738

AND

-- first_admin_dt

revactor_timestamp < 20060308161755

GROUP BY page_namespace