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