Untitled query #58544

SQL

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

/*
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...
