Unreviewed AFC-accepted articles

SQL

select p.page_title as Article, date_format(ptrp_created, '%Y-%m-%d') as 'Creation date'
from pagetriage_page
join page as p ON p.page_id = ptrp_page_id and p.page_namespace=0
join page as t on t.page_title=p.page_title and t.page_namespace=1
join categorylinks on cl_from = t.page_id
where cl_to = 'Accepted_AfC_submissions'
    and p.page_is_redirect='0'
    and ptrp_reviewed=0
order by ptrp_created desc

AخA
 
select p.page_title as Article, date_format(ptrp_created, '%Y-%m-%d') as 'Creation date'from pagetriage_pagejoin page as p ON p.page_id = ptrp_page_id and p.page_namespace=0join page as t on t.page_title=p.page_title and t.page_namespace=1join categorylinks on cl_from = t.page_idwhere cl_to = 'Accepted_AfC_submissions'    and p.page_is_redirect='0'    and ptrp_reviewed=0order by ptrp_created desc

SQL

Checking query status...