Consulta erronea

[GrupoC]

Solucionado!

Código MySQL:

SELECT e.idempresa, e.nombre,e.email,COALESCE( pi_temp.restemp, 0 ) AS count_prensa,COALESCE( n_temp.restemp, 0 ) AS count_noticias,COALESCE( c_temp.restemp, 0 ) AS count_contacto
            FROM empresas e
            LEFT JOIN (
                SELECT count( * ) AS restemp, idempresa
                FROM prensa_interna
                GROUP BY idempresa
            ) AS pi_temp ON pi_temp.idempresa = e.idempresa
            LEFT JOIN (
                SELECT count( * ) AS restemp, idempresa
                FROM noticias
                GROUP BY idempresa
            ) AS n_temp ON n_temp.idempresa = e.idempresa
            LEFT JOIN (
                SELECT count( * ) AS restemp, idempresa
                FROM contacto
                GROUP BY idempresa
            ) AS c_temp ON c_temp.idempresa = e.idempresa
            WHERE 1
 

Para quien le interese :D