Talks pages in Category:Medicine articles by importance where the subject-space page is a redirect. Data as of 23:05, 15 August 2009 (UTC).
Sample query (for reference).
SELECT
pg1.page_title
FROM page AS pg1
JOIN categorylinks
ON cl_from = pg1.page_id
WHERE pg1.page_namespace = 1
AND cl_to = 'Top-importance_medicine_articles'
AND EXISTS (SELECT
1
FROM page AS pg2
WHERE pg2.page_title = pg1.page_title
AND pg2.page_namespace = 0
AND pg2.page_is_redirect = 1);
Talks pages in Category:Medicine articles by importance where the subject-space page is a redirect. Data as of 23:05, 15 August 2009 (UTC).
Sample query (for reference).
SELECT
pg1.page_title
FROM page AS pg1
JOIN categorylinks
ON cl_from = pg1.page_id
WHERE pg1.page_namespace = 1
AND cl_to = 'Top-importance_medicine_articles'
AND EXISTS (SELECT
1
FROM page AS pg2
WHERE pg2.page_title = pg1.page_title
AND pg2.page_namespace = 0
AND pg2.page_is_redirect = 1);