SELECT t1.*, decode(t1.bd_senha,'passwd') as bd_senha_decode, t2.empresa as cliente, t3.titulo as plano, t4.titulo as topo, t5.titulo as area, t6.link as link_redirecionar, t6.texto as texto_parceiro FROM net_dominios t1 LEFT JOIN net_clientes t2 ON t1.codigo_cliente = t2.codigo LEFT JOIN net_planos t3 ON t1.codigo_plano = t3.codigo LEFT JOIN net_topos t4 ON t1.codigo = t4.codigo_dominio LEFT JOIN net_areas t5 ON t1.codigo_area = t5.codigo LEFT JOIN net_parceiros t6 ON t1.codigo_parceiro = t6.codigo WHERE t1.dominio='/' OR t1.dominio='www./'