Query test 10 - Quarry

SQL

SELECT page_title
FROM page
WHERE page_namespace = 10
AND page_is_redirect = 0
AND page_id IN (SELECT tl_from
FROM templatelinks
WHERE tl_target_id IN
(SELECT lt_id
 FROM linktarget
 WHERE lt_namespace = 0
AND (lt_title LIKE '%campionato%di_calcio_femminile%'
     OR lt_title LIKE '%Campionato%di_calcio_femminile%')
)
               )
                
LIMIT 1;

/*SELECT DISTINCT page_title
FROM page
WHERE page_id IN (
  SELECT DISTINCT pl_from
  FROM pagelinks
  WHERE pl_namespace = 0
  AND pl_from_namespace = 0
  AND (pl_title LIKE '%campionato%di_calcio_femminile%'
     OR pl_title LIKE '%Campionato%di_calcio_femminile%')
)

LIMIT 10;*/
SQL

Checking query status...
