gistfile1.txt

airmozilla=# select e.title, s.total_hits, extract(days from (now() - e.archive_time)), s.total_hits / extract(days from (now() - e.archive_time)) ^ 1.8 as score from main_eventhitstats s inner join main_event e on (event_id=e.id) where e.archive_time is not null order by score desc limit 60;
                                         title                                         | total_hits | date_part |       score
---------------------------------------------------------------------------------------+------------+-----------+--------------------
 Jay Sullivan at the Mozilla MWC Press Conference                                      |      37008 |       290 |    1.3676633819652
 hapi hapi joi joi - Web Development with HAPI and Node.js                             |      22457 |       328 |   0.66493442878887
 Architecting Servo: Pipelines and Parallelism                                         |       3955 |       132 |  0.602716959034957
 Minion - Automating Security for Developers                                           |      17702 |       336 |  0.501893576181002
 Higgs, a Monitoring JIT for JavaScript                                                |      13793 |       313 |  0.444302675646422
 Continuous Delivery at Google                                                         |       7744 |       260 |  0.348347997214276
 Product Design at Mozilla                                                             |      24241 |       545 |  0.287764242378729
 Mobile World Congress Press Conference                                                |       7581 |       290 |  0.280162562113007
 WebFWD III Team Presentations                                                         |       2980 |       189 |  0.238004416774238
 #teachtheweb Introduction to Webmaking                                                |       4037 |       224 |  0.237471948874251
 Intern Presentation: Brian O'Burg                                                     |       7382 |       386 |  0.163048531790285
 How to Work with the Creative Team by John Slater                                     |       1068 |       154 |  0.123320124693823
 Web Security Training                                                                 |       1221 |       176 |  0.110864591698173
 Two smart guys talking about advanced Node stuff                                      |       1273 |       181 |  0.109902347472749
 Region-Based Storage Management: ParaSailing without a (Garbage) Chute                |       3239 |       306 |  0.108670678924946
 Intern Presentation: Plugins, first run, and prefs - oh my!                           |       1484 |       202 |  0.105148101558975
 Scaling Happiness                                                                     |       3019 |       301 |  0.104338219405802
 Remix, Commentary and HTML5                                                           |       7828 |       524 | 0.0997365865169811
 Third-Party Cookie Discussion                                                         |        842 |       162 |  0.088753413519389
 WebFWD Cohort III Graduation Day                                                      |       1078 |       189 | 0.0860968997592715
 FirefoxOS Press Event                                                                 |        780 |       163 | 0.0813124252690395
 The Monday Meeting                                                                    |       1797 |       282 | 0.0698392685377853
 Online Identity: What Users Care About                                                |       2978 |       378 | 0.0683029488160332
 ElasticSearch: The Missing Intro                                                      |       1644 |       292 | 0.0600084874978521
 Poetic APIs                                                                           |       1139 |       244 | 0.0574410059073693
 Overview of Research Team Projects                                                    |       1188 |       252 | 0.0565321453936088
 Approximate Analyses for JavaScript IDE Services                                      |        804 |       203 | 0.0564629000328749
 A Browser Automation Standard                                                         |       1672 |       307 | 0.0557682731961518
 Firefox Health Report                                                                 |        213 |       106 | 0.0481758122850128
 Mozilla Distinguished Engineer: Boris Zbarsky                                         |       1123 |       270 | 0.0471981505010268
 B2G/FirefoxOS front-end automation in Python                                          |       1040 |       266 | 0.0449000054132471
 The Monday Meeting                                                                    |        462 |       170 | 0.0446512804040309
 Mozilla Distinguished Engineer: David Baron                                           |       1047 |       271 | 0.0437121288771926
 Mozilla Distinguished Engineer: Robert O'Callahan                                     |       1028 |       271 | 0.0429188810752187
 X-Tag - Web Components Workshop                                                       |       3534 |       539 | 0.0427963536654323
 Profiling Firefox Performance Issues                                                  |        993 |       281 |  0.038839879394353
 #teachtheweb Remix and Contextualize                                                  |        474 |       202 | 0.0335850405249018
 The Future of the Firefox Build System                                                |       1337 |       377 | 0.0308117933811808
 Changesets Evolution with Mercurial                                                   |        785 |       281 | 0.0307042349693526
 Marionette ...for Evil Masterminds                                                    |       1044 |       336 | 0.0295998697058505
 The Monday Meeting                                                                    |        252 |       156 | 0.0284299609878544
 Why Firefox OS And How To Talk About It                                               |        265 |       162 | 0.0279330814520642
 July MoCo Meeting                                                                     |        246 |       156 | 0.0277530571548102
 The Monday Meeting                                                                    |        264 |       163 |  0.027521128552598
 Dashboard, Charts & Metrics - Team/Project Goal Tracking Made Easy                    |        464 |       223 | 0.0275149816218697
 UI Testing of Firefox OS                                                              |        220 |       148 | 0.0272867362522016
 Roadmaps Presentation and Discussion                                                  |        172 |       133 | 0.0258580334645162
 Manager Hacking 3: Mentoring                                                          |        323 |       189 |  0.025797123026201