Testing - Quarry

SQL

USE enwikinews_p;
SELECT * FROM page
LEFT JOIN page_restrictions ON page_id = pr_page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND pr_id IS NULL
LIMIT 10;
/*
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...
