Juan de la Rubia & Xabier Urtasun

SELECT tx_quincena_domain_model_colaboradores.*, sys_file.identifier as imagen 
		FROM tx_news_domain_model_news 
		LEFT JOIN tx_quincena_eventos_colaboradores_mm
		ON tx_news_domain_model_news.uid = tx_quincena_eventos_colaboradores_mm.uid_local
		LEFT JOIN tx_quincena_domain_model_colaboradores
		ON tx_quincena_eventos_colaboradores_mm.uid_foreign = tx_quincena_domain_model_colaboradores.uid
		AND tx_quincena_domain_model_colaboradores.deleted=0
		AND tx_quincena_domain_model_colaboradores.hidden=0
		AND tx_quincena_domain_model_colaboradores.pid = 8	
		LEFT JOIN sys_file_reference
		ON tx_quincena_domain_model_colaboradores.uid = sys_file_reference.uid_foreign
		AND sys_file_reference.tablenames="tx_quincena_domain_model_colaboradores"	
		AND sys_file_reference.fieldname="logo"
		AND sys_file_reference.deleted=0
		LEFT JOIN sys_file
		ON sys_file_reference.uid_local = sys_file.uid
		WHERE tx_news_domain_model_news.path_segment ="juan-de-la-rubia-xabier-urtasun"
		AND tx_news_domain_model_news.sys_language_uid=0
		AND tx_news_domain_model_news.pid=4
		ORDER BY tx_quincena_eventos_colaboradores_mm.sorting ASC