User:Jean-Frédéric/WmFr/2013
< User:Jean-Frédéric | WmFr
Quarter 1
[edit]- /Phoebus/Quarter1 −
- /Quarter1 − 4K pictures
- /QI round2 Q2
Semester 1
[edit]- Count
- 10838, by
49 users29 users - Distinctions
-
- Quality images: 168 (by 15 users)
- Featured pictures: 21 (by 7 users)
- Usage
- 1201 distinct files used,
- 10361 reuses
- 224 wikis
Queries |
---|
These are SQL queries, run on the Wikimedia Tool Labs and their Database access.
SELECT /* SLOW_OK */ img_user_text AS uploader, COUNT(image.img_name) AS image_count
FROM image, page, categorylinks
WHERE page.page_id=categorylinks.cl_from
AND image.img_name = page.page_title
AND .categorylinks.cl_to = "Media_supported_by_Wikimedia_France"
AND img_timestamp BETWEEN 20130101000000 AND 20130701000000
GROUP BY uploader ORDER BY image_count DESC;
SELECT /* SLOW_OK */ COUNT(page_title)
FROM image, page, categorylinks
WHERE page.page_id=categorylinks.cl_from
AND image.img_name = page.page_title
AND .categorylinks.cl_to = "Media_supported_by_Wikimedia_France"
AND img_timestamp BETWEEN 20130101000000 AND 20130701000000;
SELECT /* SLOW_OK */ page_title, img_user_text AS uploader
FROM page
JOIN categorylinks AS cl1 ON page_id=cl1.cl_from
JOIN categorylinks AS cl2 ON page_id=cl2.cl_from
JOIN image ON image.img_name = page.page_title
WHERE cl1.cl_to="Media_supported_by_Wikimedia_France"
AND cl2.cl_to="Quality_images"
AND img_timestamp BETWEEN 20130101000000 AND 20130701000000
ORDER BY img_timestamp ASC;
SELECT /* SLOW_OK */ img_user_text AS uploader, COUNT(image.img_name) AS image_count
FROM page
JOIN categorylinks AS cl1 ON page_id=cl1.cl_from
JOIN categorylinks AS cl2 ON page_id=cl2.cl_from
JOIN image ON image.img_name = page.page_title
WHERE cl1.cl_to="Media_supported_by_Wikimedia_France"
AND cl2.cl_to="Quality_images"
AND img_timestamp BETWEEN 20130101000000 AND 20130701000000
GROUP BY uploader ORDER BY image_count DESC;
SELECT /* SLOW_OK */ COUNT(DISTINCT page_title) AS FilesUsed, COUNT(gil_wiki) AS Uses, COUNT(DISTINCT gil_wiki) AS NbWikis
FROM page
JOIN categorylinks
JOIN globalimagelinks
JOIN image ON image.img_name = page.page_title
WHERE page.page_id=categorylinks.cl_from
AND gil_page_namespace_id = 0 AND (gil_wiki!='metawiki')
AND gil_to = page_title
AND categorylinks.cl_to = "Media_supported_by_Wikimedia_France"
AND img_timestamp BETWEEN 20130101000000 AND 20130701000000;
|