Testing - Quarry

SQL

SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN pagetriage_page_tags ON ptrpt_page_id = ptrp_page_id
WHERE page_id = 62933448
;

/*
SELECT
	page_id AS 'pageid',
	page_title AS 'title',
	ptrpt_value AS 'target',
	actor_name AS 'creator'
FROM
	page
	JOIN pagetriage_page ON page_id = ptrp_page_id
	JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id
	JOIN revision ON page_latest = rev_id
	JOIN actor ON rev_actor = actor_id
WHERE
	ptrp_reviewed = 0
	AND ptrpt_tag_id = 9
	AND page_namespace = 0
	AND page_is_redirect = 1
;
/*
USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
AND page_title LIKE '%..___'
LIMIT 1000
OFFSET 100;

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...
