Get all users with a few userboxes in English Wikipedia

This query is marked as a draft This query has been published by EpochFail.

This query handles subpages like "User:EpochFail/Userboxes" --> "EpochFail" through the use of the SUBSTRING_INDEX() function.  Note also that "_" in titles are replaced with " " because usernames have spaces and titles have underscores.  ¯\_(ツ)_/¯

SQL

SELECT SUBSTRING_INDEX(user_page.page_title, "/", 1)
FROM page AS user_page
INNER JOIN templatelinks ON
	user_page.page_id = tl_from
WHERE
	user_page.page_namespace = 2 AND
    ((tl_namespace = 2 AND
      tl_title IN ("Ky.an.san/Userboxes/Tucson", "Mjpresson/Userboxes/Loomis2")) OR
     (tl_namespace = 10 AND
      tl_title IN ("User_Pasadena_CA", "User San Francisco")))

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...