Every Monday listen to the Unity 101 Top 10 Air Play Chart, live from 10 am till 12 noon.
This chart is a real time selection of the top 10 songs from the last 7 days, played right here on Southampton's Unity 101.
Sat SELECT COUNT(item_id) as play_count, title, artist, timeplayed FROM unity_music_log WHERE timeplayed BETWEEN DATE(NOW()) - INTERVAL 7 DAY AND DATE(NOW()) AND category NOT IN ('Mixed Songs','Sheeba & the Private Detectives','Faith On Sunday - Islamic','Cool Time Mukul Time','Blues','Bollywood Soft Instrumental') AND TIME(timeplayed) BETWEEN '10:00:00' AND '20:00:00' GROUP BY title ORDER BY play_count DESC LIMIT 10
