Categories containing 1 article on plwiki

SQL

SELECT CONCAT('# [[:Kategoria:',cat_title,']]') AS cat_title
FROM category
JOIN page
ON page_title = cat_title
WHERE cat_pages = 1
AND cat_subcats = 0
AND cat_title NOT LIKE '%artykuł%'
AND cat_title NOT LIKE '%Artykuł%'
AND cat_title NOT LIKE '%szablon%'
AND cat_title NOT LIKE '%Szablon%'
AND cat_title NOT LIKE '%Dyskusje%'
AND cat_title NOT LIKE '%User%'
AND cat_title NOT LIKE '%Głosowania%'
AND cat_title NOT LIKE '%Portal%'
AND cat_title NOT LIKE '%infobo%'
AND cat_title NOT LIKE '%Tablica%'
AND cat_title NOT LIKE '%Wikipedy%'
GROUP BY cat_title
ORDER BY cat_title

SQL

Checking query status...