Bueno alfinal he conseguido arreglarlo usando inner join y no left join y anidando entre parentesis dejo la consulta por si a alguien mas le ayuda:
Código SQL:
Ver originalSELECT t1.*,t2.*,t3.* FROM {$this->bd}{$this->Tcontenido} AS t1 INNER JOIN {$this->bd}{$this->Tsets} AS t2 INNER JOIN {$this->bd}{$this->Tcount} AS t3 ON ((t1.cod_noticia = t2.cod_noticia)AND(t2.cod_noticia=t3.cod_pieza)) WHERE t3.cod_pieza IN ($codigos) ORDER BY t3.counter DESC