User:Jean-Frédéric/WmFr/2013

Quarter 1 edit

Semester 1 edit

Count

10838, by ~~49 users~~ 29 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;