Query test 10 - Quarry

SQL

/*SELECT DISTINCT CONCAT('# [[Template:', REPLACE(page_title,'_',' ') , ']]')
FROM page
WHERE page_namespace = 10
AND page_is_redirect = 0
AND page_id IN (
  SELECT DISTINCT pl_from
  FROM pagelinks
  WHERE pl_namespace = 0
  AND pl_from_namespace = 10
  AND (pl_title LIKE '%campionato%femminile_Under-%di_calcio%'
     OR pl_title LIKE '%Campionato%femminile_Under-%di_calcio%')
)
ORDER BY page_title;*/

SELECT DISTINCT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title != 'WK_League'
AND page_id IN (
  SELECT DISTINCT pl_from
  FROM pagelinks
  WHERE pl_namespace = 0
  AND pl_from_namespace = 0
  AND (pl_title LIKE '%campionato%femminile_Under-%di_calcio%'
     OR pl_title LIKE '%Campionato%femminile_Under-%di_calcio%')
)
/*AND page_id NOT IN (SELECT DISTINCT tl_from
FROM templatelinks
WHERE tl_target_id IN
(SELECT DISTINCT lt_id
 FROM linktarget
 WHERE lt_namespace = 10
 AND lt_title IN (
SELECT DISTINCT page_title
FROM page
WHERE page_id IN (
  SELECT DISTINCT pl_from
  FROM pagelinks
  WHERE pl_namespace = 0
  AND pl_from_namespace = 10
  AND (pl_title LIKE '%campionato%di_calcio_femminile%'
     OR pl_title LIKE '%Campionato%di_calcio_femminile%')
))))*/

LIMIT 100;
SQL

Checking query status...
