SELECT t.codtransp, t.razaosocial, t.endereco, t.bairro, t.complemento, t.cidade, t.uf, t.telefone, t.fax, t.email, t.site, (select img_logo from centtebr.compl_transportadora where codtransp = t.codtransp) as img_logo, (select slogan from centtebr.compl_transportadora where codtransp = t.codtransp) as slogan, (select descricao_emp from centtebr.compl_transportadora where codtransp = t.codtransp) as descricao_emp, (select NomedaPasta from Paginas where CodTransportadora = t.codtransp and Paginas.Ativo=1) as NomedaPasta, (select count(*) from centtebr.filial_transportadora where codtransp = t.codtransp) as filiais FROM centtebr.Transportadora t WHERE t.tipo in (1) and disponivel = 1 and t.codtransp = 0 order by t.razaosocial