Fork of Submitted drafts that have no citations by MPGuy2824
This query is marked as a draft This query has been published by Netha Hussain.

SQL

​x
 
SELECT
    page.page_title AS title,
    COUNT(*) AS citation_needed_count
FROM
    page
JOIN
    categorylinks ON categorylinks.cl_from = page.page_id
JOIN
    templatelinks ON templatelinks.tl_from = page.page_id
WHERE
    categorylinks.cl_to = 'Women\'s_health' AND
    templatelinks.tl_title = 'Citation_needed' AND
    templatelinks.tl_namespace = 10 AND
    page.page_namespace = 0
GROUP BY
    page.page_id
HAVING
    citation_needed_count > 0
ORDER BY
    citation_needed_count DESC;
​
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...