select a.id, a.filename, a.filepath, disable_download, a.size, (select avg(c.rating) from rating as c where c.content_type=1 and c.content_id=a.id group by c.content_id) as rating_avg, (select count(g.id) from comment as g where g.content_id=a.id and g.content_type=2) as comments, (select count(c.id) from rating as c where c.content_type=1 and c.content_id=a.id) as rating_count, (select performance_name from dj as b where b.id=a.dj_id) as dj_name, (select name from genre as g where g.id=genre_id) as genre_name, (select username from user as d left join dj as e on e.user_id=d.id where e.id=a.dj_id) as dj_id, a.title, a.description, a.timestamp, a.length, a.format, a.genre_id, a.order_id, (select m.t_val from hit_counters as m where m.t_id=a.id and m.t_type=1) as dl_total, (select t_val from hit_counters as m where m.t_id=a.id and m.t_type=2) as od_total, image_path from mix as a where a.hidden<>1 and a.id=3861 [nativecode=1242 ** Subquery returns more than 1 row] Mixes - TransmissionFM

Now Playing
Listen	Breaks	Break Free !	Playlist
Listen	Drum and Bass	Massivv 04	Playlist
Listen	Hip-Hop	BENJAMMIN SET 2	Playlist
Listen	House	1st Dimension	Playlist
Listen	Techno	MoUsE HoUsE 2 - 07/04/07	Playlist
Listen	Trance	Emotion	Playlist
See All Playlists		05:47:54 02/09/12 (GMT)

Page not found

The page you were looking for was not found.
If you believe you have reached this page in error please Contact us.

Breaks Mixes

Volume #752)

Drum and Bass Mixes

Volume #823)

Hip-Hop Mixes

Volume #422)

House Mixes

Volume #119)

Techno Mixes

Volume #200)

Trance Mixes

Volume #203)

Page not found