SQL
x
SET @cat = 'Artykuły_na_Medal';
SET @missing_links = 'Niezweryfikowane_martwe_linki';
SELECT article.page_title AS "Artykuły na Medal z martwymi linkami" FROM page article
JOIN page talk ON article.page_namespace + 1 = talk.page_namespace AND article.page_title = talk.page_title
JOIN categorylinks c1 ON c1.cl_from = article.page_id AND c1.cl_to = @cat
JOIN categorylinks c2 ON c2.cl_from = talk.page_id AND c2.cl_to = @missing_links
ORDER BY article.page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.