User:SD0001/db-sandbox2

{{Database report

| sql =

SELECT page_title, rev_timestamp, page_latest, page_len, actor_name, user_editcount

FROM pagetriage_page

JOIN page on page_id = ptrp_page_id

JOIN revision ON page_id = rev_page AND rev_parent_id = 0

JOIN actor ON rev_actor = actor_id

LEFT JOIN user ON user_id = actor_user

WHERE page_namespace = 0

AND page_is_redirect = 0

AND ptrp_reviewed = 0

LIMIT 5

}}