Select
voip_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 t
From
voipsw_server_cluster
Left Join voip_provider_interconnect ON voip_provider_interconnect.cluster_id = voipsw_server_cluster.id
Left Join voip_provider_route_out ON voip_provider_route_out.interconn_id = voip_provider_interconnect.id
Left Join sys_countries ON sys_countries.id = voip_provider_route_out.country_id
Left Join voip_provider_rates_outTerm ON voip_provider_rates_outTerm.route_id = voip_provider_route_out.id
Left Join voip_provider_time_slot ON voip_provider_time_slot.id = voip_provider_rates_outTerm.time_slot_id
Left Join voip_provider_route_out_dest ON voip_provider_route_out_dest.route_id = voip_provider_rates_outTerm.route_id
Left Join voipsw_protocols ON voipsw_protocols.cluster_id = voipsw_server_cluster.id
Left Join voip_dest ON voip_dest.id = voip_provider_route_out_dest.dest_id
inner Join voip_dest_subincl ON voip_dest_subincl.dest_id = voip_dest.id
inner Join voip_dest_prefix ON voip_dest_prefix.dest_id = voip_dest_subincl.incl_dest_id
WHERE 
voip_dest_prefix.prefix not like (Select
concat(voip_dest_prefix.prefix,'%')
From
voipsw_server_cluster
Left Join voip_provider_interconnect ON voip_provider_interconnect.cluster_id = voipsw_server_cluster.id
Left Join voip_provider_route_out ON voip_provider_route_out.interconn_id = voip_provider_interconnect.id
Left Join sys_countries ON sys_countries.id = voip_provider_route_out.country_id
Left Join voip_provider_rates_outTerm ON voip_provider_rates_outTerm.route_id = voip_provider_route_out.id
Left Join voip_provider_time_slot ON voip_provider_time_slot.id = voip_provider_rates_outTerm.time_slot_id
Left Join voip_provider_route_out_dest ON voip_provider_route_out_dest.route_id = voip_provider_rates_outTerm.route_id
Left Join voipsw_protocols ON voipsw_protocols.cluster_id = voipsw_server_cluster.id
Left Join voip_dest ON voip_dest.id = voip_provider_route_out_dest.dest_id
inner Join voip_dest_subexcl ON voip_dest_subexcl.dest_id = voip_dest.id
inner Join voip_dest_prefix ON voip_dest_prefix.dest_id = voip_dest_subexcl.excl_dest_id)