Fork of
Dobre Artykuły z martwymi linkami
by Msz2001
This query is marked as a draft
This query has been published
by Szoltys.
SQL
x
SET @cat = 'Rumuńscy_skoczkowie_narciarscy';
SET @missing_links = 'Niezweryfikowane_martwe_linki';
SELECT article.page_title AS "xxx" 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.