Stuff

select * from cv_fields c
				 join cv_rel_x_element e on c.ref_id = e.item_id
				  left join cv_data_ref d on c.ref_id = d.item_id
				   left join cv_cross_table t on c.ref_id = t.item_id
				    left join cv_field_data f on c.ref_id = f.ref_id
				     join cv_groups g on c.ref_id = g.item_id
                      join items i on c.ref_id = i.item_id
                       join asset_x_item x on c.ref_id = x.item_id
				where e.item_id =  27362 
					and e.rel_type  = 'I' 
					 and g.company_id = 209  
					  and g.name = 'Image'
                        and x.version = (select max(version) from asset_x_item where item_id = 27362)
                      order by x.version