Tango.info track date statistics: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
Line 4: Line 4:


==Daily==
==Daily==
Day with the most tracks (As of 2011-04-02)
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
 
* http://www.tango.info/1935-03-19 86 Gardel
* http://www.tango.info/1935-03-19 86 Gardel
* http://www.tango.info/1934-07-30 75 Gardel
* http://www.tango.info/1934-07-30 75 Gardel

Revision as of 2011-04-02T15:56:11

Yearly

Daily

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
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_track_date_statistics&oldid=35838"