Every WikiProject on English Wikipedia (excluding task forces)

In which James Hare attempts to craft a formal definition of the WikiProject, not including task forces that are subpages of other pages.

SQL

select distinct page.page_title from page
join categorylinks on page.page_id = categorylinks.cl_from
left join redirect on page.page_id = redirect.rd_from
where page_namespace = 4  # Wikipedia namespace
and page_title not like "%/%"  # No subpages
and rd_title is null  # No redirects
and
(cl_to in
 (select page.page_title from page
  where page_namespace = 14  # Categories
  and page_title like "%\_WikiProjects"
  and page_title not like "%\_for\_WikiProjects"
  and page_title not like "%\_of\_WikiProjects") # Pages sorted in a WikiProject "meta categories"
 or page_title like "WikiProject\_%" # Pages named "WikiProject (something)" even if they are not in one of the categories
);

SQL

Checking query status...