Main pl.wiki query 2

SQL

#RESULTSET_15
SELECT tl_namespace, CONCAT('{{s|',tl_title,'}}') as tl_title, COUNT(*) AS count_tl_title, CONCAT('[https://pl.wikipedia.org/w/index.php?title=Specjalna%3ALinkujące&hidelinks=1&target=Szablon:',tl_title,'&namespace=0 Linkujące]') AS tl_title_url
FROM page, templatelinks
WHERE tl_from_namespace = 0
AND tl_namespace = !10
AND page_id = tl_from
AND tl_title NOT LIKE 'Toc'
AND tl_title NOT LIKE 'Tc'
AND tl_title NOT LIKE 'Lista_planetoid%'
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE p1.page_namespace = tl_namespace
AND p1.page_title = tl_title)
GROUP BY tl_title
ORDER BY count_tl_title DESC, tl_title ASC;
#RESULTSET_16
SELECT  CONCAT('# [[Dyskusja:',page_title,']]') AS page_title, page_len
FROM page, templatelinks
WHERE tl_from_namespace = 1
AND tl_namespace = 10
AND page_id = tl_from
AND tl_title LIKE 'Bez_infoboksu'
AND page_len < 40
AND page_title IN (
	SELECT page_title
	FROM page, templatelinks
	WHERE tl_from_namespace = 0
	AND tl_namespace = 10
	AND page_id = tl_from
	AND tl_title LIKE '%infobox%'
)
ORDER BY page_len;
#RESULTSET_17
SELECT DISTINCT CONCAT("# [[Wikipedia:" , page_title , ']]') as page_title
FROM page
JOIN templatelinks ON page_id = tl_from
WHERE page_title LIKE 'Poczekalnia/%2021:%'
AND page_namespace = 4
AND NOT EXISTS(
	SELECT * FROM templatelinks t1 WHERE page_title = t1.tl_title AND t1.tl_from_namespace = 4
);
SQL

Checking query status...
