use tewiki_p;

SELECT actor_name, count(log_actor) as own_page_deletions

FROM logging,archive,actor

WHERE log_type = 'delete'

    AND log_action = 'delete'

    and ar_title=log_title 

    and ar_namespace=log_namespace 

    and ar_parent_id=0

    and ar_actor=log_actor

--    and log_namespace=0

    and actor_id=log_actor

--    AND log_actor = 139

 group by log_actor

having own_page_deletions >9

 ORDER BY own_page_deletions DESC