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