FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FireStats – Top 40 php script (now with added charts) › Reply To: FireStats – Top 40 php script (now with added charts)
15/12/2007 at 7:50 PM
#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