| select distinct pp_propname from page_props; |
9 years ago |
| select * from page_props limit 10; |
9 years ago |
| select * from page_props; |
9 years ago |
| select distinct ts_tags from tag_summary; |
9 years ago |
| select * from tag_summary limit 100; |
9 years ago |
| select * from revision where rev_user=0 limit 100; |
9 years ago |
| select * from revision limit 10 where rev_user=0; |
9 years ago |
| select * from revision limit 10; |
9 years ago |
| select * from langlinks limit 10; |
9 years ago |
| select * from lang_links limit 10; |
9 years ago |
| select * from interwiki limit 10; |
9 years ago |
| select * from pagelinks limit 10; |
9 years ago |
| select * from geo_tags limit 10; |
9 years ago |
| describe geo_tags; |
9 years ago |
| select * from revision where rev_page=43628265; |
9 years ago |
| select * from revision where rev_page_id=43628265; |
9 years ago |
| select
rev_page,
min(rev_timestamp) as first_edit_timestamp
from... |
9 years ago |
