Dewd. You so totally rock! <div class="gmail_quote">On Tue, Jan 18, 2011 at 10:23 AM, Roger Martín <<a href="mailto:rg1024@gmail.com">rg1024@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> 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 <a href="mailto:leandrosciola@gmail.com" target="_blank">leandrosciola@gmail.com</a> 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 <a href="mailto:leandrosciola@gmail.com" target="_blank">leandrosciola@gmail.com</a> 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 <a href="mailto:clipart@lists.freedesktop.org">clipart@lists.freedesktop.org</a> <a href="http://lists.freedesktop.org/mailman/listinfo/clipart" target="_blank">http://lists.freedesktop.org/mailman/listinfo/clipart</a> </blockquote></div> -- Cheers Chovynz