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;