SQL
x
#select * from categorylinks where cl_type = "page"
Select * from page RIGHT JOIN categorylinks on page_title = cl_to
#Select page_title from page join categorylinks ON page_id = rev_page join where page_namespace = 0 and page_is_redirect =0 and page_id in (SELECT cl_from FROM categorylinks) Order by page_touched
LIMIT 10
#Select count(page_title) from page
#where page_title REGEXP ".+[A-Za-z ].+" and page_namespace=0 and page_title not in (SELECT ll_title FROM langlinks where ll_lang="ta")
#Total 8418902
#Total 6987406
#Total 5863496
#LIMIT 100;
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.