USE hiwiki_p;
SELECT CONCAT("File:", oi_name)
FROM oldimage
WHERE oi_deleted... |
4 years ago |
USE hiwiki_p;
SELECT oi_name
FROM oldimage
WHERE oi_deleted = 0
GROUP BY oi_name |
4 years ago |
USE hiwiki_p;
SELECT oi_name
FROM oldimage
WHERE oi_deleted = 0 |
4 years ago |
USE hiwiki_p;
SELECT oi_name
FROM oldimage |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(*)
FROM image
GROUP BY img_name
ORDER... |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(*)
FROM image
ORDER BY COUNT(*) DESC |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(*)
FROM image
GROUP BY img_name,... |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(DISTINCT img_timestamp)
FROM... |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(*)
FROM image
GROUP BY img_name
ORDER... |
4 years ago |
USE hiwiki_p;
SELECT img_name, COUNT(img_timestamp)
FROM image
GROUP BY... |
4 years ago |
USE commonswiki_p;
SELECT img_name, COUNT(img_timestamp)
FROM image
GROUP BY... |
4 years ago |