Untitled query #58544

SQL

SELECT p1.page_title, rd_title, p2_title FROM page p1 JOIN redirect ON page_id=rd_from JOIN pagelinks ON pl_title=page_title JOIN page p2 ON pl_from=p2.page_id  WHERE
rd_title = 'Myanmar'
AND p1.page_is_redirect = 1

/*
SELECT page_title, rd_title FROM page JOIN redirect ON page_id=rd_from WHERE 
page_title LIKE 'Årets_%'
AND page_namespace = 0
*/

/*
SELECT REPLACE(CONCAT('[[',page_title,']]'),'_',' ') AS artikel FROM page WHERE
page_namespace = 0 
AND page_is_redirect = 0
AND REGEXP_REPLACE(page_title,'[a-z][A-Z]','') != page_title
AND NOT page_title LIKE '%Mc%'
AND NOT page_title LIKE '%Mac%'
AND NOT page_title LIKE '%De%'
AND NOT page_title LIKE '%Da%'
AND NOT page_title LIKE '%Le%'
AND NOT page_title LIKE '%La%'
AND NOT page_title LIKE '%GmbH%'
AND REGEXP_REPLACE(page_title,'[0-9]','') = page_title
EXCEPT
SELECT REPLACE(CONCAT('[[',page_title,']]'),'_',' ') AS artikel FROM page INNER JOIN categorylinks ON page_id = cl_from WHERE
cl_to IN ('Män','Kvinnor')
ORDER BY artikel
*/
SQL

Checking query status...
