| use commonswiki_p;
select count(*) from image where img_minor_mime in... |
3 years ago |
| use commonswiki_p;
select img_name, img_size from image where img_minor_mime... |
3 years ago |
| use commonswiki_p;
select img_name, img_size from image where img_minor_mime... |
3 years ago |
| select img_name, img_size from image where img_minor_mime in ("gif", "jpeg",... |
3 years ago |
| select img_name, img_size, from image where img_size <= 16777216 limit 100 |
3 years ago |
| select img_name, img_size, from image where img_minor_mime in ("gif",... |
3 years ago |
| select img_name, img_size, from image where img_minor_mime in ("gif",... |
3 years ago |
| use commonswiki_p;
select distinct img_minor_mime from image |
3 years ago |
| use commonswiki_p;
select img_name, img_size, img_major_mime, img_minor_mime... |
3 years ago |
| use commonswiki_p;
describe image |
3 years ago |
| select img_name, img_size, img_major_mime, img_minor_mime from image limit 100 |
3 years ago |
| use commonswiki_p;
describe image |
3 years ago |
| show tables in commonswiki_p |
3 years ago |
| describe commonswiki_p |
3 years ago |
| SELECT el_to FROM externallinks where el_to not like '%youtube.com/watch%'; |
3 years ago |
| SELECT el_to FROM externallinks where el_to like '%youtube.com%' limit 100; |
3 years ago |
| SELECT count(el_to) FROM externallinks where el_to like '%youtube.com%'; |
3 years ago |
| SELECT count(el_to) FROM externallinks LIMIT 100; |
3 years ago |
| SELECT * FROM externallinks LIMIT 100; |
3 years ago |
| SELECT * FROM externallinks LIMIT 1; |
3 years ago |
| SELECT COUNT(*) FROM externallinks |
3 years ago |
