SELECT		cnv_cn_id, objf_key, 
		objf_type, objf_wrap, case when objf_length = 'int' then cnv_int 
		when objf_length = 'varchar' then cnv_varchar when objf_length = 'blob' then cnv_blob else '' end 
		as cnv_value, case when objf_length = 'int' then replace(objf_wrap, 
		'|', cnv_int) when objf_length = 'varchar' then replace(objf_wrap, 
		'|', cnv_varchar) when objf_length = 'blob' then replace(objf_wrap, 
		'|', cnv_blob) else '' end as cnv_value_wrapped 

FROM		brandbox_web_contents_values 

LEFT JOIN		brandbox_web_objects_fields 
ON		objf_obj_id = cnv_obj_id 
AND		cnv_objf_id = objf_id 

WHERE		cnv_cn_id IN ()