Tango.info track date statistics

From tango.info wiki
Jump to navigation Jump to search

Overview

This page gives some tango.info track date statistics.

Yearly

Monthly

By date

Days with the most tracks (As of 2011-04-02)

SELECT track_date, COUNT( track_date ) 
FROM  `tango_tracks` 
WHERE track_date
RLIKE  '[0-9]{4}-[0-9]{2}-[0-9]{2}'
GROUP BY track_date
ORDER BY COUNT( track_date ) DESC 

By day

SELECT substring(track_date,6) AS track_day, 
 count(substring(track_date,6)) AS track_day_count
FROM `tango_tracks` 
WHERE substring(track_date,6) RLIKE '^[0-9]{2}-[0-9]{2}$' 
GROUP BY track_day ORDER BY track_day_count  
DESC

Most

  • 10-09 231
  • 12-17 185
  • 04-29 181
  • 12-19 179
  • 11-23 177
  • 12-14 166
  • 09-27 164
  • 03-20 161
  • 12-10 160
  • 04-25 159
  • 07-14 156
  • 11-13 152

Least

Without