select SQL_CALC_FOUND_ROWS id, (select count(g.id) from comment as g where g.content_id=a.id and g.content_type=2 and g.date > (unix_timestamp() - 10080)) as new_comments, filename, filepath, size, disable_download, (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 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, (select performance_name from dj as b where b.id=a.dj_id) as dj_name, title, description, timestamp, length, format, genre_id, 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 from mix as a where hidden<>1 order by od_total DESC limit 0, 15 [nativecode=1242 ** Subquery returns more than 1 row]
Mixes - TransmissionFM
