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

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

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

Pictures

• January: 80
• February: 700
• March: 567
• April: 377
• May: 1216
• June: 1190
• July: 463
• August: 556
• September: 251
• October: 430
• November: 101
• December: 740

Total: 6671 files

Uploaders

SELECT /* SLOW_OK */ DISTINCT img_user_text AS user, COUNT(image.img_name) as count FROM image, page, categorylinks WHERE page.page_id=categorylinks.cl_from AND image.img_name = page.page_title AND .categorylinks.cl_to = "All_medias_supported_by_Wikimedia_France" AND img_timestamp BETWEEN 20110101000000 AND 20120101000000 GROUP BY user ORDER BY count DESC;

43 uploaders:

• Thesupermat: 2201
• Esby: 1898
• Coyau: 671
• Archaeodontosaurus: 528
• Okki: 389
• Trizek: 228
• Lionel Allorge: 166
• Rotatebot: 101
• Starus: 93
• CaptainHaddock: 89
• Jastrow: 80
• Jebulon: 34
• Jeriby: 24
• ~Pyb: 20
• Inisheer: 18
• Myrabella: 16
• VIGNERON: 16
• Elfix: 14
• Lomita: 14
• PierreSelim: 11
• TCY: 10
• Plyd: 9
• Mmenal: 8
• GNUtoo: 6
• Agamitsudo: 4
• Jules78120: 4
• Photon Libre: 4
• Floflo: 4
• Pymouss: 2
• Maurilbert: 2
• Ludo29: 2
• Cjp24: 2
• Beria: 1
• Zimeah: 1
• Poke2001: 1
• Melberg: 1
• Ceridwen: 1
• Conty: 1
• Jean-Frédéric: 1
• Paris 16: 1
• Reedy RotateBot: 1
• Carschten: 1
• Flickr upload bot: 1

Total: 6679 files

Trivia

• Average size: 10,153,133.3360
• Average width: 4,230.1412
• Average height: 3,510.5074

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 20110101000000 AND 20120101000000;

• Number of files used: 1374
• Nmber of usages: 102446
• Number of wikis: 226