Unnamed

Selectvoip_dest.id as destid,voip_dest_prefix.id as prefixid,voip_dest.name,voip_dest.country_id,voip_dest_prefix.dest_id,voip_dest_prefix.prefix,voip_dest_prefix.num_len_min,voip_dest_prefix.num_len_max,voip_provider_interconnect.ip_peer_prefix,voipsw_server_cluster.ip_address,MID(voipsw_protocols.protocol_type,8,LENGTH(voipsw_protocols.protocol_type)) AS protocol_type,voip_provider_route_out.cc_required,voip_provider_rates_outTerm.connection_charge+(voip_provider_rates_outTerm.first_int_rate+voip_provider_rates_outTerm.next_int_rate)/(voip_provider_rates_outTerm.first_int+voip_provider_rates_outTerm.next_int) as tFromvoipsw_server_clusterLeft Join voip_provider_interconnect ON voip_provider_interconnect.cluster_id = voipsw_server_cluster.idLeft Join voip_provider_route_out ON voip_provider_route_out.interconn_id = voip_provider_interconnect.idLeft Join sys_countries ON sys_countries.id = voip_provider_route_out.country_idLeft Join voip_provider_rates_outTerm ON voip_provider_rates_outTerm.route_id = voip_provider_route_out.idLeft Join voip_provider_time_slot ON voip_provider_time_slot.id = voip_provider_rates_outTerm.time_slot_idLeft Join voip_provider_route_out_dest ON voip_provider_route_out_dest.route_id = voip_provider_rates_outTerm.route_idLeft Join voipsw_protocols ON voipsw_protocols.cluster_id = voipsw_server_cluster.idLeft Join voip_dest ON voip_dest.id = voip_provider_route_out_dest.dest_idinner Join voip_dest_subincl ON voip_dest_subincl.dest_id = voip_dest.idinner Join voip_dest_prefix ON voip_dest_prefix.dest_id = voip_dest_subincl.incl_dest_idWHERE voip_dest_prefix.prefix not like (Selectconcat(voip_dest_prefix.prefix,'%')Fromvoipsw_server_clusterLeft Join voip_provider_interconnect ON voip_provider_interconnect.cluster_id = voipsw_server_cluster.idLeft Join voip_provider_route_out ON voip_provider_route_out.interconn_id = voip_provider_interconnect.idLeft Join sys_countries ON sys_countries.id = voip_provider_route_out.country_idLeft Join voip_provider_rates_outTerm ON voip_provider_rates_outTerm.route_id = voip_provider_route_out.idLeft Join voip_provider_time_slot ON voip_provider_time_slot.id = voip_provider_rates_outTerm.time_slot_idLeft Join voip_provider_route_out_dest ON voip_provider_route_out_dest.route_id = voip_provider_rates_outTerm.route_idLeft Join voipsw_protocols ON voipsw_protocols.cluster_id = voipsw_server_cluster.idLeft Join voip_dest ON voip_dest.id = voip_provider_route_out_dest.dest_idinner Join voip_dest_subexcl ON voip_dest_subexcl.dest_id = voip_dest.idinner Join voip_dest_prefix ON voip_dest_prefix.dest_id = voip_dest_subexcl.excl_dest_id)