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('[[', page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
/*AND page_id NOT IN
(SELECT pl_from
FROM pagelinks
WHERE pl_namespace = 0
AND pl_title IN
(SELECT page_title FROM page
WHERE page_namespace = 0)
AND pl_title NOT IN
(SELECT page_title
FROM categorylinks, pagelinks, page
WHERE cl_to = pl_title
AND cl_from = page_id
AND pl_namespace = 14
AND pl_from = 4195411))
AND page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
AND page_id NOT IN
(SELECT pr_page
 FROM page_restrictions)
AND page_id NOT IN (SELECT cl_from
    FROM categorylinks
    WHERE cl_to = 'Voci_senza_uscita')
ORDER BY page_title*/
LIMIT 1;
SQL

Checking query status...
