Reply To: FireStats – Top 40 php script (now with added charts)

#14772
sonichouse
Participant

That query works fine for me on my machine.

can you try

select date(time_added, 'unixepoch', 'localtime') as "Date", count(*) as Added from songs where date(time_added, 'unixepoch', 'localtime') between date('now' , '-14 day', 'localtime') and date('now' , 'localtime') group by 1;

in sqlite on yours ?

/Steve