select
	A.p_setid,
	(select C.Caption
		from cliplink C
		where C.p_setid = A.p_setid
			and coalesce(C.Caption, '') <> ''
			and C.mainobjectid = A.mainobjectid
		limit 1) Caption,
	(select FH.p_filename
		from cliplink FH
		where FH.p_setid = A.p_setid
			and FH.p_mimetype = 'video/x-flv'
			and FH.mainobjectid = A.mainobjectid
		order by FH.p_width desc, FH.p_height desc
		limit 1) flv_high,
	(select FL.p_filename
		from cliplink FL
		where FL.p_setid = A.p_setid
			and FL.p_mimetype = 'video/x-flv'
			and FL.mainobjectid = A.mainobjectid
		order by FL.p_width asc, FL.p_height asc
		limit 1) flv_low,
	(select QH.p_filename
		from cliplink QH
		where QH.p_setid = A.p_setid
			and QH.p_mimetype = 'video/quicktime'
			and QH.mainobjectid = A.mainobjectid
		order by QH.p_width desc, QH.p_height desc
		limit 1) qt_high,
	(select QL.p_filename
		from cliplink QL
		where QL.p_setid = A.p_setid
			and QL.p_mimetype = 'video/quicktime'
			and QL.mainobjectid = A.mainobjectid
		order by QL.p_width desc, QL.p_height desc
		limit 1) qt_low

from cliplink A
where A.mainobjectid = 'GW0000030470'
group by A.mainobjectid, A.p_setid
-- limit 10