Untitled query #77926

SQL

select
	concat("https://en.wikipedia.org/wiki/", page_title) as title,
    ptpt1.ptrpt_value as excerpt,
    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=9
	  and ptpt1.ptrpt_value like "The Province of"
      and ptpt2.ptrpt_tag_id=20
      and ptpt2.ptrpt_value='2'
   order by ptrp_reviewed_updated desc;
SQL

Checking query status...
