| show databases; |
8 years ago |
| use enwiktionary_p;
select count(*) from imagelinks where il_to like '%.ogg'; |
8 years ago |
| use enwiktionary_p;
select count(*) from imagelinks where i_to like '%.ogg'; |
8 years ago |
| use enwiktionary_p;
select * from page where page_id = 37813 limit 1; |
8 years ago |
| use enwiktionary_p;
select * from page limit 1; |
8 years ago |
| use enwiktionary_p;
show tables; |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to =... |
8 years ago |
| use enwiktionary_p;
select * from pagelinks where pl_title like... |
8 years ago |
| use enwiktionary_p;
select * from pagelinks where pl_title =... |
8 years ago |
| use enwiktionary_p;
select * from pagelinks where pl_namespace=6 and... |
8 years ago |
| use enwiktionary_p;
select * from pagelinks where pl_namespace=6 limit 1; |
8 years ago |
| use enwiktionary_p;
select * from pagelinks limit 1; |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to =... |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to =... |
8 years ago |
| use enwiktionary;
select * from imagelinks where il_to = 'En-us-pope.ogg' limit 1; |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to =... |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to like 'pope.ogg' limit 1; |
8 years ago |
| use enwiktionary_p;
select * from imagelinks where il_to like '%.ogg' limit 1; |
8 years ago |
| use enwiktionary_p;
select * from imagelinks limit 1; |
8 years ago |
| use enwiktionary_p;
select * from interwiki limit 1; |
8 years ago |
| use enwiktionary_p;
show tables; |
8 years ago |
| use enwiktionary_p;
select distinct img_major_mime from image; |
8 years ago |
| use enwiktionary_p;
select distinct img_major_type from image; |
8 years ago |
| use enwiktionary_p;
show tables; |
8 years ago |
| use enwiktionary_p;
select fa_storage_group, fa_major_mime, fa_minor_mime,... |
8 years ago |
| use enwiktionary_p;
select * from filearchive limit 1; |
8 years ago |
| use enwiktionary_p;
select distinct fa_storage_group from filearchive; |
8 years ago |
| use enwiktionary_p;
--select * from filearchive limit 1;
select distinct... |
8 years ago |
| use enwiktionary_p; select * from filearchive limit 1; |
8 years ago |
| use enwiktionary_p; show tables; |
8 years ago |
| use enwiktionary_p; select distinct img_major_mime, img_minor_mime from image; |
8 years ago |
| use enwiktionary_p; select distinct img_major_mime from image; |
8 years ago |
| use enwiktionary_p; select * from image limit 1; |
8 years ago |
| use enwiktionary_p; show tables; |
8 years ago |
| use wiktionary_p; show tables; |
8 years ago |
| use enwiktionary;
select * from imagelinks limit 1; |
8 years ago |
| use enwiktionary;
show tables; |
8 years ago |
| use enwiktionary;
select * from image limit 1; |
8 years ago |
| use enwiktionary;
show tables; |
8 years ago |
| show databases; |
8 years ago |
| show tables; |
8 years ago |
