[Clipart] stats about uploads
chovynz
chovynz at gmail.com
Mon Jan 17 18:06:37 PST 2011
Dewd. You so totally rock!
On Tue, Jan 18, 2011 at 10:23 AM, Roger Martín <rg1024 at gmail.com> wrote:
> Hi folk!
>
> Again with data of 12/dic/2010, i made some stats:
>
>
>
> total of user uploads (all format, png, svg) : 15,878,655 (1)
> total of user uploads (only svg): 13,399,497 (2)
>
>
> artist more uploaded (consider PNG and SVG):
> =========================================
> user_name OD PORC FILES RATIO
> johnny_automatic 1837674 11.57 3547 518 download per file
> Anonymous 1014888 6.39 2840 357
> nicubunu 566791 3.57 1274 445
> Gerald_G 465473 2.93 809 575
> ryanlerch 348889 2.20 362 964
> Machovka 287024 1.81 460 624
> Chrisdesign 261503 1.65 268 976
> liftarn 260321 1.64 333 782
> molumen 259944 1.64 271 959
> warszawianka 221324 1.39 548 404
> rg1024 198725 1.25 359 554
> ArtFavor 189209 1.19 1004 188
> papapishu 189132 1.19 392 482
> inky2010 184757 1.16 525 352
> zeimusu 154229 0.97 194 795
> yves_guillou 148600 0.94 400 372
> jean_victor_balin 147421 0.93 320 461
> rejon 132341 0.83 1296 102
> mystica 117743 0.74 212 555
> Peileppe 115617 0.73 126 918
> pitr 111383 0.70 185 602
> shokunin 98899 0.62 219 452
> laobc 98035 0.62 208 471
> netalloy 93916 0.59 267 352
> cibo00 89611 0.56 185 484
>
> conclusion: johnny_automatic is god!
>
>
> ARTISTS BY RATIO ( number of uploads / number of files)
> ============================================
>
> BEST(4).
> username RATIO FILES
> ----------------------------
> rgtaylor_csc 6305 7
> axcesar 4846 2
> ajith 4623 1
> gabe_anguiano 4520 1
> Darth_Gimp 4410 5
> bubba 4268 1
> juanjo 4074 4
> no_hope 4039 1
> adolflow 3755 1
> Fadookie 3716 1
> hce 3708 1
> Voxxi 3584 1
> brucewestfall 3207 1
> stephantom 3166 1
> msewtz 3162 1
> mola 3112 1
> Lynx 3077 1
> Ts-Pc 2981 1
> dokuro 2981 1
> manders2006 2944 1
> hatemeidc7 2929 1
> lagartoflojo 2911 1
> grimgiant 2900 2
> xxv 2898 1
> gopher 2888 3
>
> Conclusion: sometime less is more..
>
> WORST (5)
> user_name RATIO
> ---------------------------
> xavowski 7
> lemasney 7
> yodomark 15
> Ulomar 16
> Spirit_Walker 16
> nascent26 30
> yasinergene 35
> Lone Coder 38
> sitphong 62
> kdegames 62
> radiopiromania 62
> elmodos 63
> miltiadis 73
> matheus 73
> Rombicovh 84
> CrLz 89
> majo 90
> stvdns 90
> vicing 91
> Ariniko 94
> morits 96
> schicchero 97
> jars 102
> rejon 102
> arnelsx 102
>
> Conclusion: fortunately, Rejon is more better community manager than
> drawner ;-)
>
> UPLOADS per DAY (6)
>
> the num of uploads is accumulative (old clip arts have more uploads)
> cliparts by num_upload divided by days in open-clipart (sorry but we have
> not upload date before 2006/2/11 (aprox 5,000 cliparts)
>
> user clipart-id nº of download per day
> =================================
> fitorec 86989 191
> leandrosciola at gmail.com 63763 49
> jaschon 92725 48
> inky2010 86479 39
> Martouf 81865 36
> inky2010 93463 36
> inky2010 93445 35
> inky2010 87949 31
> vwanweb 81331 28
> inky2010 94393 25
> Ts-Pc 85075 24
> russel 74179 23
> mireille 93655 23
> rg1024 94723 23
> luciancaetano 63895 23
> shokunin 68317 22
> gustavorezende 74497 22
> netalloy 88201 22
> inky2010 94459 21
> 14thWarrior 83479 21
> mola 79399 20
> netalloy 87961 20
> netalloy 88753 20
> mireille 93487 20
> inky2010 94243 20
> leandrosciola at gmail.com 64771 19
> rones 88717 18
> inky2010 90895 18
> momoko 8780 18
> rones 68203 18
>
> conclusion: leandrosciola!! inky2010!! netalloy!!
>
>
>
>
>
> SQL ( before chovny ask it ;-)
>
> (1) select sum(file_num_download) from ocal_files where
> upload_config='media'
> (2) select sum(file_num_download) from ocal_files where
> upload_config='media' and filename rlike ".svg"
>
> (3) select user_name, sum(file_num_download) as OD, round(
> (sum(file_num_download)/15878655)*100,2) as PORC, count(id) as FILES,
> round(sum(file_num_download)/count(id),0) as RATIO from ocal_files where
> upload_config='media' group by user_name order by OD Desc limit 25
>
> (4) select user_name, round(sum(file_num_download)/count(id),0) as RATIO,
> count(id) AS FILES from ocal_files where upload_config='media' group by
> user_name order by RATIO Desc limit 25
>
> (5) select user_name, round(sum(file_num_download)/count(id),0) as RATIO
> from ocal_files where upload_config='media' group by user_name order by
> RATIO ASC limit 25
>
> (6) SELECT user_name,id, round(file_num_download / datediff ( curdate(),
> upload_date ),0) as RATIO from ocal_files WHERE upload_date> 0 Order by
> RATIO DESC
>
>
> _______________________________________________
> clipart mailing list
> clipart at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/clipart
>
>
--
Cheers
Chovynz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/clipart/attachments/20110118/e1a0415a/attachment.html>
More information about the clipart
mailing list