select transportadora.nome as transportadora,
transportadora.logo as logo,
transportadora.obs as obs,
transportadora.idTransportadora as idTransportadora,
precoTransportadora.valor as valor
from transportadora
inner join precoTransportadora on transportadora.idTransportadora = precoTransportadora.idTransportadora and
case
when transportadora.tipo=1 then '0' between precoTransportadora.de and precoTransportadora.ate
when transportadora.tipo=2 then '0' between precoTransportadora.de and precoTransportadora.ate
end
and
precoTransportadora.idPais = '176'