SQL
AخA
select concat ("https://en.wikipedia.org/wiki/", page_title, "?redirect=no") as title, length(ptrpt_value) as l, ptrpt_value from
pagetriage_page
join page
on ptrp_page_id=page_id
join pagetriage_page_tags on ptrpt_page_id=page_id
where page_is_redirect=1
and page_namespace=0
and ptrpt_tag_id=9
and length(ptrpt_value) > 100
and ptrp_reviewed=0
order by l desc
limit 10
#select * from pagetriage_tags;
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.