Categories created by bots

SQL

select page_title,actor_name from page 
join revision_userindex on rev_page=page_id 
join actor_revision on actor_id=rev_actor where page_namespace=14 and rev_parent_id=0 
and LOWER(actor_name) not like "%bot%"
-- and actor_name not in ("EarwigBot V","EarwigBot","Cydebot","JJMC89 bot III","BHGbot",
--                        "Hazard-Bot","AnomieBOT","Femto Bot","MelonBot","Gdrbot","Sambot");
and (
  exists (select 1 from user_groups where ug_group="bot" and ug_user=actor_user)
  or exists (select 1 from user_former_groups where ufg_group="bot" and ufg_user=actor_user)
)
SQL

Checking query status...
