| Use commonswiki_p;
SELECT img_name, COUNT(img_size)
FROM image
GROUP BY... |
8 years ago |
| Use commonswiki_p;
SELECT img_name, COUNT(img_sha1)
FROM image
GROUP BY... |
8 years ago |
| Use commonswiki_p;
select count(img_name) from image
where img_media_type... |
8 years ago |
| Use commonswiki_p;
select img_name from image
where img_media_type like... |
8 years ago |
| Using commonswiki_p
select img_name from image
where img_media_type like... |
8 years ago |
| Using commonswiki_p
select img_name from image where img_media_type like... |
8 years ago |
| Using commonswiki_p
select img_name from image where img_media_type =... |
8 years ago |
| USE commonswiki_p;
SELECT * from image where img_size<50 and img_size >0;
|
8 years ago |
| USE commonswiki_p;
SELECT * from image where img_size<20 and img_size >0;
|
8 years ago |
| USE commonswiki_p;
SELECT * from image where img_size<20;
|
8 years ago |
| USE commonswiki_p;
SELECT * from image
having img_size<20;
|
8 years ago |
| USE commonswiki_p;
SELECT img_name, img_size, img_sha1, count(img_sha1) from... |
8 years ago |
| USE commonswiki_p;
SELECT COUNT(img_sha1) from image; |
8 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
WHERE
... |
8 years ago |
| USE enwiki_p;
SELECT *
FROM revision_userindex
WHERE
rev_user_text =... |
8 years ago |
| USE enwiki_p;
SELECT *
FROM revision_userindex
WHERE
rev_user_text =... |
8 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
WHERE
... |
8 years ago |
| USE commonswiki_p;
SELECT page_title from page where
page_id = "1165840"; |
8 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
WHERE
rev_id = "2971218"; |
8 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
WHERE
... |
8 years ago |
| USE commonswiki_p;
SELECT *
FROM revision_userindex
WHERE
... |
8 years ago |
| USE commonswiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
| USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
| DESCRIBE commonswiki_p.category; |
8 years ago |
