Submitted drafts that have no citations

Fork of Reviewed articles that have no citations (ignore disambigs) by MPGuy2824

This query is marked as a draft This query has been published by MPGuy2824.

SQL

select concat("https://en.wikipedia.org/wiki/Draft:", page_title) as title, ptpt2.ptrpt_value,ptrp_reviewed_updated
    from pagetriage_page
      join page on page_id = ptrp_page_id
      join pagetriage_page_tags ptpt1 on ptrp_page_id=ptpt1.ptrpt_page_id
      join pagetriage_page_tags ptpt2 on ptrp_page_id=ptpt2.ptrpt_page_id
    where page_namespace=118
      and ptpt1.ptrpt_tag_id=17
      and ptpt1.ptrpt_value='0'
      and ptpt2.ptrpt_tag_id=20
      and ptpt2.ptrpt_value='2'
      and ptrp_reviewed_updated < date_add(now(), interval -1 day)
   order by ptrp_reviewed_updated desc;

SQL

Checking query status...