Fotos

SELECT emp_news.*, emp_foto_news.nombre as pic, emp.comercial, emp.cod as codigo_empresa FROM emp_news LEFT JOIN emp ON emp.cod=emp_news.cod_emp LEFT JOIN emp_foto_news ON emp_news.cod=emp_foto_news.emp_news_oid LEFT JOIN emails em ON em.cod_emp=emp.cod WHERE emp_news.desde<=curdate() and (emp_news.hasta>=curdate() or emp_news.hasta is null) AND em.cod_emp in (773) GROUP BY cod ORDER BY desde DESC LIMIT 3