All pastes #902127 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-13 05:01 UTC
rendered paste body
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