Request rules: Minimum Track Repeat 60 mins, Minimum Artist Repeat 30 mins, Request Count Limit of 3 songs per every 60 mins.
WordPress database error: [Incorrect file format 'queuelist']SELECT s.`ID`, s.`artist`, s.`title`, s.`duration`, s.`date_played`, s.`artist_played`,
TIMESTAMPDIFF(MINUTE, s.`date_played`, NOW()) AS `played_minutes`,
TIMESTAMPDIFF(MINUTE, s.`artist_played`, NOW()) AS `artist_played_minutes`,
(CASE WHEN r.played = 0 THEN r.requested END) AS requested,
TIMESTAMPDIFF(MINUTE, r.requested, NOW()) AS `requested_minutes`,
q.songID AS in_queue
FROM `songs` AS s
LEFT JOIN `requests` AS r ON( s.ID = r.songID )
LEFT JOIN `queuelist` AS q ON ( s.ID = q.songID )
WHERE s.enabled = 1
AND s.song_type IN(0)
AND `id_subcat` IN(4,34,39)
ORDER BY s.artist, s.title ASC
LIMIT 50, 25
Top Request Songs
| # | Artist | Title | Count |
|---|---|---|---|
| 1. | 24kGoldn Ft. Iann Dior | Mood | 4 |
| 2. | 10cc | I'm Not In Love | 4 |