Comparte la noticia

SELECT emp_eventos.*, emp.comercial, emp.cod as codigo_empresa FROM emp_eventos LEFT JOIN emp ON emp.cod=emp_eventos.emp_oid LEFT JOIN emails em ON em.cod_emp=emp.cod WHERE em.cod_emp in () GROUP BY oid ORDER BY fecha_inicio DESC LIMIT 5