Query test 9 - Quarry

SQL

SELECT DISTINCT CONCAT('# [[', REPLACE(page_title,'_',' ') , ']]')
FROM page 
WHERE page_namespace = 0
AND page_is_redirect = 0
/*AND page_title REGEXP '%campionato_(mondiale|africano|asiatico|nordamericano|sudamericano|oceaniano|europeo)_di_calcio_femminile%'*/
AND (page_title LIKE '%campionato%di_calcio_femminile%'
     OR page_title LIKE '%Campionato%di_calcio_femminile%')
ORDER BY page_title;

SELECT DISTINCT CONCAT('# [[', REPLACE(page_title,'_',' ') , ']]')
FROM page 
WHERE page_namespace = 0
AND page_is_redirect = 10
/*AND page_title REGEXP '%campionato_(mondiale|africano|asiatico|nordamericano|sudamericano|oceaniano|europeo)_di_calcio_femminile%'*/
AND (page_title LIKE '%campionato%di_calcio_femminile%'
     OR page_title LIKE '%Campionato%di_calcio_femminile%')
ORDER BY page_title;

/*SELECT DISTINCT CONCAT("# [[Template:",page_title,"]]")
FROM page 
WHERE page_namespace = 10
AND page_is_redirect = 0
AND page_title LIKE '%pallanuoto_mondiali%'
ORDER BY page_title;*/

/*SELECT DISTINCT page_title
FROM page
WHERE page_namespace = 0
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 = 10
 AND lt_title LIKE '%pallanuoto_mondiali%'
))
ORDER BY page_title;*/
SQL

Checking query status...
