Untitled query #29014

SQL

USE etwiki_p;
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'), iwl_title AS fiwiki, page_namespace

#SELECT page_title, CONCAT('''[[{{ns:', page_namespace, '}}:', page_title, ']]')


#https://et.wikipedia.org/w/index.php?title=Veikko_Maripuu&action=edit
#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 = "fi"
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 fiwiki
ORDER BY page_namespace ASC
LIMIT 100;
SQL

Checking query status...
