Untitled query #33338

SQL

USE hewiki_p;
SELECT CONCAT('# {{s|Template:',page_title,'}}') as page_title, rev_user_text, rev_timestamp
FROM page, templatelinks, revision
WHERE page_id = tl_from
AND rev_page = page_id
AND rev_parent_id = 0
AND tl_namespace = 10 
AND page_title NOT LIKE '%/%'
/*AND page_title NOT LIKE '%_władców_%'
AND page_title NOT LIKE '%_team_%'
AND page_title NOT LIKE 'User%'*/
AND page_is_redirect = 0
AND page_namespace = 10 
AND NOT EXISTS
(SELECT *
FROM templatelinks t1
WHERE page_title = t1.tl_title
AND t1.tl_namespace = 10)
/*AND EXISTS
(SELECT *
FROM templatelinks AS t2
WHERE page_id = tl_from
AND page_namespace = tl_from_namespace
AND tl_namespace = 10
AND tl_title LIKE 'Navbox')*/
GROUP BY page_title
ORDER BY page_title ASC;
SQL

Checking query status...
