WP:AFCSORT - Quarry

SQL

SELECT page_title, page_latest, cl_sortkey_prefix, page_len, actor_name, rev_timestamp, user_editcount,
       NOT ISNULL(coi_t.tl_title) AS has_coi,
       NOT ISNULL(upe_t.tl_title) AS has_upe
FROM categorylinks
JOIN page ON page_id = cl_from
JOIN revision ON page_id = rev_page AND rev_parent_id = 0
JOIN actor_revision ON rev_actor = actor_id
LEFT JOIN user ON user_id = actor_user
LEFT JOIN templatelinks coi_t ON page_id = coi_t.tl_from AND coi_t.tl_namespace = 10 AND coi_t.tl_title = 'COI'
LEFT JOIN templatelinks upe_t ON page_id = upe_t.tl_from AND upe_t.tl_namespace = 10 AND upe_t.tl_title = 'Undisclosed paid'
WHERE cl_to = 'Pending_AfC_submissions'
AND page_namespace = 118;
SQL

Checking query status...
