Hi,
since last month, there is some mistakes when I want to extract airplay.
For example, in March, the SQL export says that this song has been played 31 times
But in song history, it has been played only one time
And with the mairlist report module, only one time too
Any idea ?
here is my SQL request :
SELECT i.title, i.artist, SUBSTRING(i.duration,1,3), count(*), a9.value, a3.value, a1.value, a2.value, a4.value, a5.value, a6.value, a7.value, a8.value
FROM playlistlog pl
JOIN items i ON pl.item=i.idx
LEFT JOIN item_attributes a9 ON a9.item=i.idx AND a9.name='Album'
LEFT JOIN item_attributes a1 ON a1.item=i.idx AND a1.name='ISRC'
LEFT JOIN item_attributes a2 ON a2.item=i.idx AND a2.name='Compositeur'
LEFT JOIN item_attributes a3 ON a3.item=i.idx AND a3.name='Style'
LEFT JOIN item_attributes a4 ON a4.item=i.idx AND a4.name='Leader'
LEFT JOIN item_attributes a5 ON a5.item=i.idx AND a5.name='Année'
LEFT JOIN item_attributes a6 ON a6.item=i.idx AND a6.name='Pays'
LEFT JOIN item_attributes a7 ON a7.item=i.idx AND a7.name='Région'
LEFT JOIN item_attributes a8 ON a8.item=i.idx AND a8.name='Langue'
WHERE i.type='Music' AND pl.starttime >= '2021-03-01' AND pl.starttime < '2021-04-01' GROUP BY i.title ORDER BY count(*) DESC ;