Nonstandard user categories

SQL

select * from page where page_namespace=14 and page_title like "Wikipedian%love%"
and not exists (select 1 from categorylinks where cl_from=page_id and (
  cl_to like "Wikipedians_by_interest_in_a_%_television_series" -- Exclude TV series cats where this is the (IMO poor) convention
  or cl_to in ("Wikipedia_soft_redirected_categories", -- Exclude redirects
               -- "Wikipedians_interested_in_anime_and_manga",
               -- "Wikipedians_by_interest_in_a_television_game_show",
               "Categories_for_deletion",
               -- "Wikipedians_who_like_Star_Trek"
              )))
SQL

Checking query status...
