Link rossi - Quarry

SQL

/*USE itwiki_p;
SELECT DISTINCT CONCAT("# [[", page_title, "]]")
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('O'))
AND page_id IN (SELECT cl_from
    FROM categorylinks
    WHERE cl_to LIKE 'Pugili%')
AND page_id IN
(SELECT cl_from
FROM categorylinks
WHERE cl_to = 'Pagine_orfane_-_novembre_2012');*/

USE itwiki_p;
SELECT CONCAT('# [[', p1.page_title, ']] - [[Discussione:', p1.page_title, ']]')
FROM page AS p1 JOIN templatelinks ON p1.page_id = tl_from, page AS p2
WHERE p1.page_namespace = 1
AND p1.page_is_redirect = 0
AND tl_title = 'Tradotto_da'
AND p1.page_title = p2.page_title
AND p2.page_namespace = 0
AND p2.page_is_redirect = 0
AND p2.page_id NOT IN
(SELECT ll_from
FROM langlinks)
AND p2.page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
AND p2.page_title NOT IN
(SELECT pl_title
FROM pagelinks
WHERE pl_from = 5395952) /* Wikipedia:Elenchi generati offline/Voci tradotte senza interlink/Whitelist */
ORDER BY p2.page_title
LIMIT 10;
SQL

Checking query status...
