Untitled query #29014

SQL

USE etwiki_p;
SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS pagetitle, iwl_title AS Xwiki, page_namespace
#SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]'), iwl_title AS fiwiki, page_namespace

#SELECT CONCAT('https://et.wikipedia.org/w/index.php?title={{ns:', page_namespace,'}}:',page_title,' &action=edit') AS et, iwl_title AS fiwiki, page_namespace
#SELECT page_title, CONCAT('''[[{{ns:', page_namespace, '}}:', page_title, ']]')
#SELECT page_title, CONCAT(iwl_prefix, ":", iwl_title) AS fiwiki, page_namespace
FROM iwlinks
INNER JOIN page
WHERE iwl_from = page_id
AND iwl_title <> ""
AND iwl_prefix = "sv"
AND page_title NOT LIKE "%Tappinen/Liivakast%"
AND page_title NOT LIKE "%Estopedist1%"
AND page_title NOT LIKE "%Oluliste_artiklite_eeskujud%"
AND page_title NOT LIKE "%Morel/Teenetemärgid%"
AND page_title NOT LIKE "%Eesti_Vabaduse_Risti%"
AND page_title NOT LIKE "%äyttäjä:%"
AND page_title NOT LIKE "%User:%"
AND page_title NOT LIKE "%user:%"
AND page_title NOT LIKE "%Tõlketalgutest_osavõtjad%"
#AND page_title NOT LIKE "%%"
#AND iwlinks.iwl_title NOT LIKE "User_talk%"
#AND iwlinks.iwl_title NOT LIKE "User:%"
GROUP BY Xwiki
ORDER BY page_namespace ASC
LIMIT 500;
SQL

Checking query status...
