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 ="al-ayre-espanol"
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
