SELECT title, extra, sum FROM ( ( SELECT broadcast.title AS title, producers.producer AS extra, SUM(dl_times) AS sum FROM broadcastTrack LEFT JOIN broadcast ON broadcast.id=broadcastTrack.broadcast LEFT JOIN producers ON broadcast.producer=producers.id WHERE broadcast.title IS NOT NULL GROUP BY broadcastTrack.broadcast ORDER BY SUM(dl_times) DESC LIMIT 0,40 ) AS derived_table_1 UNION ALL ( SELECT clips.title AS title, fileTypes.fileType AS extra, SUM(dl_times) AS sum FROM clipTrack LEFT JOIN clips ON clips.id=clipTrack.clip LEFT JOIN fileTypes ON fileTypes.id=clips.fileType WHERE clips.title IS NOT NULL GROUP BY clipTrack.clip ORDER BY SUM(dl_times) DESC LIMIT 0,40 ) AS derived_table_2 ) AS main_table_1 LIMIT 0, 40