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

English: Media uploaded in 2012 and made with the support of Wikimédia France.

Français : Médias versés en 2012 et réalisés avec le soutien de Wikimédia France.

Uploaders

/Uploaders

69 uploaders (total)

Pictures

• January: 278
• February: 675
• March: 845
• April: 365
• May: 217
• June: 448
• July: 566
• August: 1165
• September: 1909
• October: 1065
• November: 1407
• December: 758

Total: 9689 files

Trivia

SELECT /* SLOW_OK */  AVG(img_size), AVG(img_width), AVG(img_height) 
    FROM image i, page p, categorylinks cl 
    WHERE i.img_name = p.page_title 
        AND p.page_id = cl.cl_from 
        AND cl.cl_to = "All_medias_supported_by_Wikimedia_France" 
        AND img_timestamp BETWEEN 20120101000000 AND 20130101000000;

• Average size: 11,794,594.9488
• Average width: 4,048.0971
• Average height: 3,613.1678

Distinctions

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="All_medias_supported_by_Wikimedia_France" 
        AND cl2.cl_to="Quality_images" 
        AND img_timestamp BETWEEN 20120101000000 AND 2013101000000 
    ORDER BY img_timestamp ASC;

(1 min 22.75 sec)

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="All_medias_supported_by_Wikimedia_France"
          AND cl2.cl_to="Quality_images"
          AND img_timestamp BETWEEN 20120101000000 AND 20130101000000
     GROUP BY uploader ORDER BY image_count DESC;

• Quality images: 315317 (by 17 users)
• Quality images (bis): 240
• Featured pictures: 45 (by 9 users)
• Valued images 82 (by 2 users)

Usage

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 = "All_medias_supported_by_Wikimedia_France"
        AND img_timestamp BETWEEN 20120101000000 AND 20130101000000;

• Number of files used: 1379 (= 14%)
• Nmber of usages: 16933
• Number of wikis: 233