SELECT t.id_country, country, truncate( min(t.rate+o.rate) ,2) rate
                     FROM bell.origination o
                    INNER join bell.termination t on t.id_cc=o.id_cc
                    INNER join bell.card_company cc on cc.id_card_company=o.id_cc
                    inner join bell.country c on c.id_country=t.id_country
                    WHERE o.id_country='182'
                      AND cc.active='y'
                    group by t.id_country
                    ORDER by country

Use "View Source" to view xml


5 Afghanistan 16.70 555 Afghanistan - CELL 13.20 13 Albania 16.40 415 Albania - CELL 30.60 621 Albania - Tirana 16.62 10 Algeria 5.90 556 Algeria - CELL 55.55 11 Amer. Samoa 2.80 12 Andorra 2.60 547 Andorra - CELL 13.90 18 Angola 4.40 557 Angola - CELL 9.10 235 Anguilla 17.40 558 Anguilla - CELL 20.20 6 Antarctica 66.90 14 Antigua 20.90 475 Antigua - CELL 23.50 15 Argentina 1.10 244 Argentina - Buenos Aires 0.50 287 Argentina - CELL 6.70 649 Argentina - Cordoba 3.55 650 Argentina - La Plata 3.53 652 Argentina - Mendoza 3.47 723 Argentina - Pilar 4.47 715 Argentina - Santa Fe 4.03 719 Argentina - Tucuman 4.26 950 Argentina - Zarate 3.55 16 Armenia 13.00 289 Armenia - CELL 20.80 17 Aruba 8.20 417 Aruba - CELL 18.30 245 Ascension Isl. 57.77 7 Australia 1.00 246 Australia - CELL 2.30 1043 Australia Territories 89.90 8 Austria 1.00 290 Austria - CELL 3.00 654 Austria - Vienna 4.83 9 Azerbaijan 18.30 291 Azerbaijan - CELL 25.69 236 Bahamas 12.36 418 Bahamas - CELL 19.90 21 Bahrain 8.80 561 Bahrain - CELL 11.30 19 Bangladesh 1.40 297 Bangladesh - CELL 1.40 292 Bangladesh - Chittagong 12.30 294 Bangladesh - Dhaka 7.48 296 Bangladesh - Sylhet 13.29 237 Barbados 7.40 554 Barbados - CELL 18.30 22 Belarus 32.70 419 Belarus - CELL 33.80 23 Belgium 3.00 655 Belgium - Brussels 5.12 420 Belgium - CELL 9.20 24 Belize 20.00 562 Belize - CELL 20.20 25 Benin 23.60 476 Benin - CELL 24.90 27 Bermuda 3.30 421 Bermuda - CELL 2.10 36 Bhutan 4.40 563 Bhutan - CELL 4.60 28 Bolivia 8.80 477 Bolivia - CELL 14.30 564 Bolivia - Cochabamba 8.60 565 Bolivia - La Paz 8.90 566 Bolivia - Santa Cruz 9.38 30 15.40 422 34.90 31 Botswana 10.40 478 Botswana - CELL 20.70 32 Brazil 0.50 305 Brazil - CELL 1.10 952 Brazil - Governado Valeres 8.06 301 Brazil - Rio de Janeiro 0.50 298 Brazil - Sao Paulo 0.50 238 British V.I. 15.37 424 British V.I. - CELL 21.30 33 Brunei 2.70 567 Brunei - CELL 7.81 29 Bulgaria 0.70 425 Bulgaria - CELL 4.00 404 Bulgaria - Sofia 7.10 34 Burkina Faso 19.04 568 Burkina Faso - CELL 32.60 35 Burundi 19.58 479 Burundi - CELL 44.80 83 Cambodia 5.40 452 Cambodia - CELL 4.40 84 Cameroon 11.30 480 Cameroon - CELL 15.00 569 Cameroon - Douala 22.70 85 Canada 0.60 150 Cape Verde 12.60 481 Cape Verde - CELL 23.70 234 CAR 30.50 570 CAR - CELL 37.20 224 Cayman Isl. 4.90 426 Cayman Isl. - CELL 13.90 208 Chad Rep. 34.42 482 Chad Rep. - CELL 45.40 209 Chile 1.00 483 Chile - CELL 1.10 623 Chile - Santiago 0.80 90 China 1.20 307 China - CELL 1.10 141 Christmas Isl. 5.98 92 Colombia 1.00 954 Colombia - Armenia 10.15 320 Colombia - Barranquilla 6.95 314 Colombia - Bogota 7.42 955 Colombia - Bucaramanga 10.70 956 Colombia - Buga 7.62 315 Colombia - Cali 7.57 957 Colombia - Cali Region 10.67 958 Colombia - Cartegna 10.54 313 Colombia - CELL 0.60 961 Colombia - Manizales 8.42 317 Colombia - Medellin 10.49 962 Colombia - Palmira 8.46 947 Colombia - Pereira 10.13 93 Comoros 33.30 572 Comoros - CELL 47.90 94 Congo 40.90 548 Congo - CELL 38.30 145 Cook Isl. 46.10 95 Costa Rica 1.90 324 Costa Rica - CELL 5.40 207 Croatia 1.80 325 Croatia - CELL 3.00 96 Cuba 56.50 37 Cuba Guantanamo 50.60 88 Cyprus 0.90 326 Cyprus - CELL 2.40 241 Czech Rep. 1.90 273 Czech Rep. - CELL 3.50 67 Dem. Rep. Congo 37.30 544 Dem. Rep. Congo - CELL 29.10 992 Dem. Rep. Congo - Kinshasa 34.29 62 Denmark 0.70 327 Denmark - CELL 1.10 64 Diego Garcia 81.81 63 Djibouti 27.90 228 Dominica 16.60 485 Dominica - CELL 19.60 65 Dominican Rep. 3.10 329 Dominican Rep. - CELL 9.10 453 East Timor 24.30 213 Ecuador 10.40 330 Ecuador - CELL 11.50 696 Ecuador - Cuenca 13.93 332 Ecuador - Guayaquil 17.34 66 Egypt 6.80 334 Egypt - CELL 7.90 164 El Salvador 6.90 335 El Salvador - CELL 9.80 214 Equator. Guinea 32.28 576 Equator. Guinea - CELL 38.40 215 Eritrea 21.20 577 Eritrea - CELL 20.90 216 Estonia 1.50 336 Estonia - CELL 20.60 993 Estonia - Tallin 5.91 217 Ethiopia 15.70 994 Ethiopia - Addis Ababa 44.35 486 Ethiopia - CELL 15.60 199 Faeroe Isl. 21.30 578 Faeroe Isl. - CELL 2.50 203 Falkland Isl. 77.40 200 Fiji Isl. 19.90 487 Fiji Isl. - CELL 20.20 202 Finland 5.40 337 Finland - CELL 2.60 787 Finland - Helsinki 6.65 204 France 0.90 265 France - CELL 3.70 205 French Guiana 1.00 581 French Guiana - CELL 3.60 206 French Polynesia 18.20 44 Gabon Rep. 20.71 488 Gabon Rep. - CELL 36.60 47 Gambia 37.80 583 Gambia - CELL 36.70 60 Georgia 9.00 338 Georgia - CELL 22.00 454 Georgia - Tbilisi 12.80 53 Germany 0.50 255 Germany - CELL 2.40 48 Ghana 21.40 489 Ghana - CELL 19.50 967 Ghana - Tema 11.27 54 Gibraltar 3.10 490 Gibraltar - CELL 21.50 59 Greece 0.60 339 Greece - Athens 6.29 343 Greece - CELL 1.00 58 Greenland 4.80 57 Grenada 9.00 492 Grenada - CELL 17.00 49 Guadeloupe 1.00 493 Guadeloupe - CELL 3.90 61 Guam 1.80 50 Guatemala 6.90 494 Guatemala - CELL 12.50 51 Guinea 18.45 495 Guinea - CELL 38.90 52 Guinea Bissau 47.10 496 Guinea Bissau - CELL 41.30 46 Guyana 21.70 497 Guyana - CELL 17.40 45 Haiti 24.00 498 Haiti - CELL 23.60 969 Haiti - Port-au-Prince 16.15 55 Honduras 11.10 499 Honduras - CELL 13.30 56 Hong Kong 1.80 345 Hong Kong - CELL 2.50 41 Hungary 1.70 270 Hungary - Budapest 6.55 346 Hungary - CELL 3.50 78 Iceland 0.80 500 Iceland - CELL 1.80 72 India 1.30 455 India - Ahmadabad 30.40 347 India - CELL 1.30 352 India - Hyderabad 9.43 349 India - New Delhi 15.21 73 Indonesia 3.90 356 Indonesia - CELL 3.40 353 Indonesia - Jakarta 5.85 76 Iran 11.20 456 Iran - CELL 13.70 457 Iran - Tehran 7.50 75 Iraq 12.60 585 Iraq - CELL 17.90 77 Ireland 0.70 358 Ireland - CELL 0.90 357 Ireland - Dublin 4.73 71 Israel 0.50 254 Israel - CELL 2.40 630 Israel-Palestine 7.80 80 Italy 0.50 267 Italy - CELL 4.10 26 Ivory Coast 25.00 458 Ivory Coast - Abidjan 22.02 501 Ivory Coast - CELL 27.70 221 Jamaica 15.37 459 Jamaica - CELL 18.00 222 Japan 1.70 359 Japan - CELL 3.00 74 Jordan 11.10 461 Jordan - CELL 15.00 82 Kazakhstan 2.40 620 Kazakhstan - Almaty 11.28 428 Kazakhstan - CELL 11.00 87 Kenya 12.50 502 Kenya - CELL 8.20 995 Kenya - Mombasa 17.53 586 Kenya - Nairobi 17.17 160 Kiribati 88.13 409 Korea North 61.50 407 Korea South 1.30 364 Korea South - CELL 1.10 638 Korea South - Seoul 7.40 97 Kuwait 3.60 504 Kuwait - CELL 3.40 89 Kyrgyzstan 9.50 278 Kyrgyzstan - CELL 12.13 98 Laos 7.40 99 Latvia 16.10 249 Latvia - CELL 28.00 102 Lebanon 8.00 505 Lebanon - CELL 15.30 100 Lesotho 27.77 588 Lesotho - CELL 26.50 101 Liberia 38.70 549 Liberia - CELL 35.20 103 Libya 22.01 589 Libya - CELL 24.10 229 Liechtenstein 5.70 104 Lithuania 14.57 365 Lithuania - CELL 27.77 105 Luxembourg 1.20 433 Luxembourg - CELL 3.00 110 Macau 7.50 506 Macau - CELL 7.91 225 Macedonia 14.70 473 Macedonia - CELL 35.40 109 Madagascar 39.17 507 Madagascar - CELL 53.40 111 Malawi 9.45 590 Malawi - CELL 9.73 112 Malaysia 1.00 366 Malaysia - CELL 1.10 113 Maldives 65.70 591 Maldives - CELL 71.40 108 Mali 22.00 695 Mali - Bamako 21.08 592 Mali - CELL 28.00 114 Malta 2.40 474 Malta - CELL 2.40 117 Marshall Isl. 22.20 116 Martinique 1.00 683 Martinique - CELL 3.40 107 Mauritania 43.20 594 Mauritania - CELL 53.30 106 Mauritius 8.40 509 Mauritius - CELL 8.40 138 Mayotte Isl. 3.00 595 Mayotte Isl. - CELL 6.60 118 Mexico 0.50 434 Mexico - CELL 0.60 462 Mexico - Guadalajara 5.08 369 Mexico - MexicoCity 5.10 370 Mexico - Monterrey 5.20 675 Mexico - Puebla 6.84 119 Micronesia 40.50 121 Moldova 14.62 371 Moldova - CELL 20.50 122 Monaco 6.20 510 Monaco - CELL 33.44 123 Mongolia 1.40 597 Mongolia - CELL 1.40 647 Montenegro 15.30 648 Montenegro - CELL 40.30 124 Montserrat 21.40 598 Montserrat - CELL 44.40 115 Morocco 1.60 625 Morocco - Casablanca 27.05 511 Morocco - CELL 31.00 626 Morocco - Rabat 25.87 120 Mozambique 11.20 512 Mozambique - CELL 16.66 125 Myanmar (Burma) 10.80 599 Myanmar (Burma) - CELL 12.70 126 Namibia 6.20 513 Namibia - CELL 3.50 127 Nauru 102.77 129 Nepal 9.70 515 Nepal - CELL 11.40 617 Nepal - Katmandu 11.30 131 Nether. Antilles 7.20 516 Nether. Antilles - CELL 25.31 975 Nether. Antilles - Curacao 4.80 977 Nether. Antilles - St. Martin 9.60 978 Nether. Antilles - St. Martin CELL 11.40 132 Netherlands 0.80 372 Netherlands - CELL 1.80 643 Nevis 37.81 136 New Caledonia 15.10 135 New Zealand 1.30 437 New Zealand - CELL 3.40 133 Nicaragua 12.20 517 Nicaragua - CELL 16.80 979 Nicaragua - Managua 21.40 230 Niger 18.60 600 Niger - CELL 21.30 130 Nigeria 4.80 518 Nigeria - CELL 3.30 996 Nigeria - Ilorin 33.40 627 Nigeria - Lagos 5.30 134 Niue Isl. 57.00 139 Norfolk Isl. 50.00 142 Northern Mariana Islands 3.30 137 Norway 0.60 373 Norway - CELL 0.90 149 Oman 10.00 521 Oman - CELL 18.80 151 Pakistan 4.10 466 Pakistan - CELL 3.60 464 Pakistan - Karachi 33.29 465 Pakistan - Lahore 36.59 152 Palau 21.20 601 Palau - CELL 22.40 618 Palestine 15.60 619 Palestine - CELL 17.80 153 Panama 2.00 522 Panama - CELL 8.00 636 Panama - Panama-City 7.37 154 Papua New Guinea 58.50 523 Papua New Guinea - CELL 85.90 155 Paraguay 2.00 467 Paraguay - Asuncion 2.00 550 Paraguay - CELL 2.90 156 Peru 0.50 524 Peru - CELL 0.50 468 Peru - Lima 0.50 201 Philippines 10.50 981 Philippines - Cebu 20.19 375 Philippines - CELL 10.40 374 Philippines - Manila 27.70 157 Poland 1.00 260 Poland - CELL 1.70 259 Poland - Warsaw 5.89 158 Portugal 0.50 438 Portugal - CELL 1.00 159 Puerto Rico 0.30 86 Qatar 14.80 525 Qatar - CELL 15.10 140 Reunion Isl. 1.30 526 Reunion Isl. - CELL 5.80 163 Romania 0.50 271 Romania - Bucharest 12.00 274 Romania - CELL 1.40 161 Russia 1.90 1037 Russia - Abkhazia 17.00 279 Russia - CELL 3.80 247 Russia - Moscow 1.20 982 Russia - Rostovdon 7.44 248 Russia - S.Peter 1.10 162 Rwanda 26.40 602 Rwanda - CELL 25.10 165 San Marino 5.30 166 Sao Tome 72.80 168 Saudi Arabia 8.60 470 Saudi Arabia - CELL 11.50 469 Saudi Arabia - Jeddah 7.32 410 Saudi Arabia - Riyadh 8.73 174 Senegal 25.61 527 Senegal - CELL 17.20 376 Senegal - Dakar 34.10 218 Serbia 14.30 451 Serbia - CELL 39.40 1021 Serbia - Kosovo 35.80 171 Seychelles Isl. 30.42 605 Seychelles Isl. - CELL 30.45 233 Sierra Leone 37.39 528 Sierra Leone - CELL 39.50 983 Sierra Leone - Freetown 23.43 175 Singapore 0.90 377 Singapore - CELL 0.80 1044 Sint Maarten 10.90 240 Slovakia 0.50 440 Slovakia - CELL 4.20 177 Slovenia 8.30 441 Slovenia - CELL 21.20 178 Solomon Island 73.10 179 Somalia 43.00 606 Somalia - CELL 21.90 219 South Africa 2.90 380 South Africa - CELL 3.20 1030 South Sudan 30.80 1033 South Sudan - CELL 33.30 79 Spain 0.50 381 Spain - CELL 1.40 4 Special Services 23.00 212 Sri Lanka 13.90 442 Sri Lanka - CELL 13.50 984 Sri Lanka - Colombo 19.17 231 St. Helena 91.63 242 St. Kitts 16.30 530 St. Kitts - CELL 17.30 167 St. Lucia 13.20 531 St. Lucia - CELL 17.60 172 St. Vincent 13.10 532 St. Vincent - CELL 18.70 173 27.06 180 Sudan 14.20 609 Sudan - CELL 13.60 181 Suriname 12.80 533 Suriname - CELL 13.60 169 Swaziland 7.00 534 Swaziland - CELL 9.50 211 Sweden 0.50 387 Sweden - CELL 0.80 210 Switzerland 1.30 389 Switzerland - CELL 8.60 176 Syria 13.80 610 Syria - CELL 19.40 184 Taiwan 1.80 390 Taiwan - CELL 7.70 639 Taiwan - Taipei 4.17 183 Tajikistan 11.10 443 Tajikistan - CELL 14.60 186 Tanzania 27.80 535 Tanzania - CELL 27.30 611 Tanzania - Dar Es Salaam 19.47 185 Thailand 0.90 412 Thailand - Bangkok 7.18 445 Thailand - CELL 1.00 187 Togo 26.40 612 Togo - CELL 28.50 188 Tokelau 96.50 189 Tonga 40.78 553 Tonga - CELL 67.30 190 4.50 536 15.20 192 Tunisia 28.72 537 Tunisia - CELL 71.42 194 Turkey 2.60 628 Turkey - Ankara 16.70 391 Turkey - CELL 5.90 392 Turkey - Istanbul 14.10 985 Turkey - Izmir 16.70 193 Turkmenistan 9.30 446 Turkmenistan - CELL 10.90 146 24.04 614 19.40 191 Tuvalu 85.50 148 UAE 12.30 447 UAE - CELL 14.50 195 Uganda 13.95 539 Uganda - CELL 19.52 286 UK 0.60 262 UK - CELL 1.00 197 Ukraine 11.60 393 Ukraine - CELL 10.90 472 Ukraine - Dnepropetrovsk 13.06 685 Ukraine - Kharkov 14.65 250 Ukraine - Kiev 17.45 471 Ukraine - Lvov 15.56 198 Uruguay 4.70 540 Uruguay - CELL 12.90 1025 Uruguay - Montevideo 3.40 239 US Virgin Isl. 1.30 182 USA 0.50 283 USA - Alaska 1.60 284 USA - Hawaii 0.70 1056 USA - Toll Free 2.70 196 Uzbekistan 6.30 449 Uzbekistan - CELL 6.60 38 Vanuatu 73.40 541 Vanuatu - CELL 73.40 42 Venezuela 0.70 413 Venezuela - Caracas 5.10 450 Venezuela - CELL 4.90 414 Venezuela - Maracaibo 15.00 43 Vietnam 5.60 396 Vietnam - CELL 5.60 688 Vietnam - Ho Chi Minh 39.97 147 29.20 69 Western Samoa 55.78 542 Western Samoa - CELL 85.50 223 Yemen 12.50 543 Yemen - CELL 12.50 68 Zambia 13.71 545 Zambia - CELL 31.90 989 Zambia - Lusaka 9.90 70 Zimbabwe 11.22 546 Zimbabwe - CELL 30.50
Back to http://www.pushline.com/export/index.php