Code: Select all
var customNodesDefinitions = {
tracks: [{
title: 'Show 5 most played tracks',
description: 'Currently showing 5 most played tracks',
sql: 'Songs.PlayCounter > 0 ORDER BY Songs.PlayCounter DESC LIMIT 5'
},
.....
{
Code: Select all
SELECT
Songs.PlayCounter, strftime('%Y',julianday(DateAdded + 2415018.5),'localtime') as addedyear
FROM
Songs
WHERE addedyear = '2015' AND Songs.PlayCounter > 0 ORDER BY Songs.PlayCounter DESC LIMIT 5
Code: Select all
var customNodesDefinitions = {
tracks: [{
title: 'Show 5 most played tracks in 2015',
description: 'Currently showing 5 most played tracks',
sql: 'strftime('%Y',julianday(DateAdded + 2415018.5),'localtime') = '2015' AND Songs.PlayCounter > 0 ORDER BY Songs.PlayCounter DESC LIMIT 5'
},
....
{
What's wrong in line ?:
Code: Select all
sql: 'strftime('%Y',julianday(DateAdded + 2415018.5),'localtime') = '2015' AND Songs.PlayCounter > 0 ORDER BY Songs.PlayCounter DESC LIMIT 5'
Carsten