show tables; |
2 years ago |
SELECT * from wiki where dbname like '%source%'; |
2 years ago |
show tables; |
2 years ago |
SELECT
p.page_id AS "page_id",
CAST(p.page_title AS CHAR(10000)... |
2 years ago |
SELECT
p.page_id AS "page_id",
CAST(p.page_title AS CHAR(10000)... |
2 years ago |
SELECT * from text limit 10; |
2 years ago |
SELECT * from page where page_id = 54843; |
2 years ago |
SELECT * from page limit 10; |
2 years ago |
SELECT * from iwlinks limit 10; |
2 years ago |
SELECT * from revision limit 10; |
2 years ago |
SELECT * from sites limit 10; |
2 years ago |
SELECT * from page_props limit 10; |
2 years ago |
SELECT * from page_restrictions limit 10; |
2 years ago |
SELECT * from pagelinks limit 10; |
2 years ago |
SELECT * from page limit 10; |
2 years ago |
SELECT * from ipblocks_compat limit 10; |
2 years ago |
SELECT * from ipblocks limit 10; |
2 years ago |
SELECT * from filearchive limit 10; |
2 years ago |
SELECT * from categorylinks limit 10; |
2 years ago |
SELECT * from category limit 10; |
2 years ago |
SELECT * from category limit 1; |
2 years ago |
SELECT * from archive limit 1; |
2 years ago |
SELECT * from content_models limit 1; |
2 years ago |
SELECT * from content limit 1; |
2 years ago |
SELECT * from page limit 1; |
2 years ago |
show tables; |
2 years ago |
SELECT * from wiki where lang = 'uk'; |
2 years ago |
SELECT * from wiki where lang = 'uk' limit 10; |
2 years ago |
SELECT * from wiki limit 10; |
2 years ago |
SELECT * from wiki limit 1; |
2 years ago |
SELECT * from wiki where id = 1; |
2 years ago |
SELECT * from content where content_id = 1; |
2 years ago |
SELECT * from text where old_id = 309721892; |
2 years ago |
SELECT * from content where content_id < 10; |
2 years ago |
SELECT * from actor where actor_id < 10; |
2 years ago |
SELECT * from actor where id < 10; |
2 years ago |
SELECT page_namespace, page_is_new, COUNT(*)
FROM revision
JOIN actor ON... |
2 years ago |