Testing - Quarry

SQL

SELECT user_name, ug_group FROM user
JOIN user_groups ON ug_user = user_id
WHERE user_name in ('Aboudaqn', 'Airbornemihir', 'AlanM1', 'BarrelProof', 'Concus Cretus', 'DadaNeem', 'DannyS712', 'Dissident93', 'Donald Trung', 'ElKevbo', 'Eurodog', 'Fgnievinski', 'GentlemanGhost', 'Glades12', 'Grinner', 'Hemant Dabral', 'INS Pirat', 'Iztwoz', 'JackintheBox', 'Jay D. Easy', 'JGabbard', 'Joeykai', 'Julia', 'KingSkyLord', 'Kvng', 'Laterthanyouthink', 'Lk95', 'Looper5920', 'Mattximus', 'McPhail', 'MJL', 'Modest Genius', 'N2e', 'Nicholas0', 'Paintspot', 'Peter James', 'Randy Kryn', 'RekishiEJ', 'Sangdeboeuf', 'Shortride', 'Spatms', 'Srleffler', 'SUM1', 'Swimmer33', 'Taivorist', 'Tajotep', 'The Mirror Cracked', 'Þjarkur', 'Toploftical', 'UnitedStatesian', 'Usedtobecool', 'Voidvector', 'Wikiuser100', 'Wiki Wikardo', 'Wugapodes', 'ZxxZxxZ')

/*
USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON page_id = pr_page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT LIKE 'Market_Data%'
AND page_title NOT LIKE 'News_briefs%'
AND page_title NOT LIKE '%/Brief'
AND pr_id IS NULL
LIMIT 100;
/*
SELECT *
FROM templatelinks
WHERE tl_namespace = 6
AND NOT EXISTS (
  SELECT 1
  FROM imagelinks
  WHERE il_from = tl_from
  AND il_to = tl_title
  LIMIT 1
)
LIMIT 10;

SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN pagetriage_page_tags ON ptrpt_page_id = ptrp_page_id
JOIN pagetriage_tags ON ptrt_tag_id = ptrpt_tag_id
WHERE page_id = 60231771
/*
SELECT page_title, r.* FROM page
JOIN redirect AS r ON page_id = rd_from
WHERE page_is_redirect = 1
AND page_namespace = 0
AND page_title LIKE '%disambiguation'
AND rd_namespace = 0
/*
USE wikidatawiki_p;
SELECT pg.page_title AS `Redirect from`, r.rd_title AS `Redirect to` #pg.*, r.*
FROM page pg
JOIN redirect r ON r.rd_from = pg.page_id
WHERE page_is_redirect = 1
AND pg.page_namespace = 0
AND EXISTS (
	SELECT 1
	FROM page pg2
	WHERE pg2.page_title = pg.page_title
	AND pg2.page_namespace = 1
	AND pg2.page_is_redirect = 0
	LIMIT 1
)
AND NOT EXISTS (
	SELECT 1
	FROM page pg3
	WHERE pg3.page_title = r.rd_title
	AND pg3.page_namespace = 1
	LIMIT 1
)
LIMIT 100;
/*
SELECT pp.pp_value #pg.page_id, pl.*, pp.*
FROM pagelinks pl
JOIN page AS pg
ON page_title = pl_title AND page_namespace = pl_namespace
JOIN page_props AS pp
ON pp_page = page_id AND pp_propname = 'wikibase_item'
WHERE pl_from = 39377526
AND EXISTS (
	SELECT 1
	FROM categorylinks
	WHERE cl_from = pg.page_id
	AND cl_to = 'Living_people'
)
*/
SQL

Checking query status...
