Fork of
Longest RfAs @ zhwiki
by WhitePhosphorus
This query is marked as a draft
This query has been published
by WhitePhosphorus.
SQL
AخA
SELECT MIN(rev_timestamp) ts, page_title, page_len FROM page
JOIN revision ON rev_page = page_id
WHERE page_namespace = 4
AND page_title LIKE '申请成为管理员/%'
AND NOT page_is_redirect
AND page_len > 200 # 排除列表页面,非实际 RfA
GROUP BY page_id
ORDER BY ts
DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.