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
012
5Afghanistan16.70
555Afghanistan - CELL13.20
13Albania16.40
415Albania - CELL30.60
621Albania - Tirana16.62
10Algeria5.90
556Algeria - CELL55.55
11Amer. Samoa2.80
12Andorra2.60
547Andorra - CELL13.90
18Angola4.40
557Angola - CELL9.10
235Anguilla17.40
558Anguilla - CELL20.20
6Antarctica66.90
14Antigua20.90
475Antigua - CELL23.50
15Argentina1.10
244Argentina - Buenos Aires0.50
287Argentina - CELL6.70
649Argentina - Cordoba3.55
650Argentina - La Plata3.53
652Argentina - Mendoza3.47
723Argentina - Pilar4.47
715Argentina - Santa Fe4.03
719Argentina - Tucuman4.26
950Argentina - Zarate3.55
16Armenia13.00
289Armenia - CELL20.80
17Aruba8.20
417Aruba - CELL18.30
245Ascension Isl.57.77
7Australia1.00
246Australia - CELL2.30
1043Australia Territories89.90
8Austria1.00
290Austria - CELL3.00
654Austria - Vienna4.83
9Azerbaijan18.30
291Azerbaijan - CELL25.69
236Bahamas12.36
418Bahamas - CELL19.90
21Bahrain8.80
561Bahrain - CELL11.30
19Bangladesh1.40
297Bangladesh - CELL1.40
292Bangladesh - Chittagong12.30
294Bangladesh - Dhaka7.48
296Bangladesh - Sylhet13.29
237Barbados7.40
554Barbados - CELL18.30
22Belarus32.70
419Belarus - CELL33.80
23Belgium3.00
655Belgium - Brussels5.12
420Belgium - CELL9.20
24Belize20.00
562Belize - CELL20.20
25Benin23.60
476Benin - CELL24.90
27Bermuda3.30
421Bermuda - CELL2.10
36Bhutan4.40
563Bhutan - CELL4.60
28Bolivia8.80
477Bolivia - CELL14.30
564Bolivia - Cochabamba8.60
565Bolivia - La Paz8.90
566Bolivia - Santa Cruz9.38
30Bosnia&Herz.15.40
422Bosnia&Herz. - CELL34.90
31Botswana10.40
478Botswana - CELL20.70
32Brazil0.50
305Brazil - CELL1.10
952Brazil - Governado Valeres8.06
301Brazil - Rio de Janeiro0.50
298Brazil - Sao Paulo0.50
238British V.I.15.37
424British V.I. - CELL21.30
33Brunei2.70
567Brunei - CELL7.81
29Bulgaria0.70
425Bulgaria - CELL4.00
404Bulgaria - Sofia7.10
34Burkina Faso19.04
568Burkina Faso - CELL32.60
35Burundi19.58
479Burundi - CELL44.80
83Cambodia5.40
452Cambodia - CELL4.40
84Cameroon11.30
480Cameroon - CELL15.00
569Cameroon - Douala22.70
85Canada0.60
150Cape Verde12.60
481Cape Verde - CELL23.70
234CAR30.50
570CAR - CELL37.20
224Cayman Isl.4.90
426Cayman Isl. - CELL13.90
208Chad Rep.34.42
482Chad Rep. - CELL45.40
209Chile1.00
483Chile - CELL1.10
623Chile - Santiago0.80
90China1.20
307China - CELL1.10
141Christmas Isl.5.98
92Colombia1.00
954Colombia - Armenia10.15
320Colombia - Barranquilla6.95
314Colombia - Bogota7.42
955Colombia - Bucaramanga10.70
956Colombia - Buga7.62
315Colombia - Cali7.57
957Colombia - Cali Region10.67
958Colombia - Cartegna10.54
313Colombia - CELL0.60
961Colombia - Manizales8.42
317Colombia - Medellin10.49
962Colombia - Palmira8.46
947Colombia - Pereira10.13
93Comoros33.30
572Comoros - CELL47.90
94Congo40.90
548Congo - CELL38.30
145Cook Isl.46.10
95Costa Rica1.90
324Costa Rica - CELL5.40
207Croatia1.80
325Croatia - CELL3.00
96Cuba56.50
37Cuba Guantanamo50.60
88Cyprus0.90
326Cyprus - CELL2.40
241Czech Rep.1.90
273Czech Rep. - CELL3.50
67Dem. Rep. Congo37.30
544Dem. Rep. Congo - CELL29.10
992Dem. Rep. Congo - Kinshasa34.29
62Denmark0.70
327Denmark - CELL1.10
64Diego Garcia81.81
63Djibouti27.90
228Dominica16.60
485Dominica - CELL19.60
65Dominican Rep.3.10
329Dominican Rep. - CELL9.10
453East Timor24.30
213Ecuador10.40
330Ecuador - CELL11.50
696Ecuador - Cuenca13.93
332Ecuador - Guayaquil17.34
66Egypt6.80
334Egypt - CELL7.90
164El Salvador6.90
335El Salvador - CELL9.80
214Equator. Guinea32.28
576Equator. Guinea - CELL38.40
215Eritrea21.20
577Eritrea - CELL20.90
216Estonia1.50
336Estonia - CELL20.60
993Estonia - Tallin5.91
217Ethiopia15.70
994Ethiopia - Addis Ababa44.35
486Ethiopia - CELL15.60
199Faeroe Isl.21.30
578Faeroe Isl. - CELL2.50
203Falkland Isl.77.40
200Fiji Isl.19.90
487Fiji Isl. - CELL20.20
202Finland5.40
337Finland - CELL2.60
787Finland - Helsinki6.65
204France0.90
265France - CELL3.70
205French Guiana1.00
581French Guiana - CELL3.60
206French Polynesia18.20
44Gabon Rep.20.71
488Gabon Rep. - CELL36.60
47Gambia37.80
583Gambia - CELL36.70
60Georgia9.00
338Georgia - CELL22.00
454Georgia - Tbilisi12.80
53Germany0.50
255Germany - CELL2.40
48Ghana21.40
489Ghana - CELL19.50
967Ghana - Tema11.27
54Gibraltar3.10
490Gibraltar - CELL21.50
59Greece0.60
339Greece - Athens6.29
343Greece - CELL1.00
58Greenland4.80
57Grenada9.00
492Grenada - CELL17.00
49Guadeloupe1.00
493Guadeloupe - CELL3.90
61Guam1.80
50Guatemala6.90
494Guatemala - CELL12.50
51Guinea18.45
495Guinea - CELL38.90
52Guinea Bissau47.10
496Guinea Bissau - CELL41.30
46Guyana21.70
497Guyana - CELL17.40
45Haiti24.00
498Haiti - CELL23.60
969Haiti - Port-au-Prince16.15
55Honduras11.10
499Honduras - CELL13.30
56Hong Kong1.80
345Hong Kong - CELL2.50
41Hungary1.70
270Hungary - Budapest6.55
346Hungary - CELL3.50
78Iceland0.80
500Iceland - CELL1.80
72India1.30
455India - Ahmadabad30.40
347India - CELL1.30
352India - Hyderabad9.43
349India - New Delhi15.21
73Indonesia3.90
356Indonesia - CELL3.40
353Indonesia - Jakarta5.85
76Iran11.20
456Iran - CELL13.70
457Iran - Tehran7.50
75Iraq12.60
585Iraq - CELL17.90
77Ireland0.70
358Ireland - CELL0.90
357Ireland - Dublin4.73
71Israel0.50
254Israel - CELL2.40
630Israel-Palestine7.80
80Italy0.50
267Italy - CELL4.10
26Ivory Coast25.00
458Ivory Coast - Abidjan22.02
501Ivory Coast - CELL27.70
221Jamaica15.37
459Jamaica - CELL18.00
222Japan1.70
359Japan - CELL3.00
74Jordan11.10
461Jordan - CELL15.00
82Kazakhstan2.40
620Kazakhstan - Almaty11.28
428Kazakhstan - CELL11.00
87Kenya12.50
502Kenya - CELL8.20
995Kenya - Mombasa17.53
586Kenya - Nairobi17.17
160Kiribati88.13
409Korea North61.50
407Korea South1.30
364Korea South - CELL1.10
638Korea South - Seoul7.40
97Kuwait3.60
504Kuwait - CELL3.40
89Kyrgyzstan9.50
278Kyrgyzstan - CELL12.13
98Laos7.40
99Latvia16.10
249Latvia - CELL28.00
102Lebanon8.00
505Lebanon - CELL15.30
100Lesotho27.77
588Lesotho - CELL26.50
101Liberia38.70
549Liberia - CELL35.20
103Libya22.01
589Libya - CELL24.10
229Liechtenstein5.70
104Lithuania14.57
365Lithuania - CELL27.77
105Luxembourg1.20
433Luxembourg - CELL3.00
110Macau7.50
506Macau - CELL7.91
225Macedonia14.70
473Macedonia - CELL35.40
109Madagascar39.17
507Madagascar - CELL53.40
111Malawi9.45
590Malawi - CELL9.73
112Malaysia1.00
366Malaysia - CELL1.10
113Maldives65.70
591Maldives - CELL71.40
108Mali22.00
695Mali - Bamako21.08
592Mali - CELL28.00
114Malta2.40
474Malta - CELL2.40
117Marshall Isl.22.20
116Martinique1.00
683Martinique - CELL3.40
107Mauritania43.20
594Mauritania - CELL53.30
106Mauritius8.40
509Mauritius - CELL8.40
138Mayotte Isl.3.00
595Mayotte Isl. - CELL6.60
118Mexico0.50
434Mexico - CELL0.60
462Mexico - Guadalajara5.08
369Mexico - MexicoCity5.10
370Mexico - Monterrey5.20
675Mexico - Puebla6.84
119Micronesia40.50
121Moldova14.62
371Moldova - CELL20.50
122Monaco6.20
510Monaco - CELL33.44
123Mongolia1.40
597Mongolia - CELL1.40
647Montenegro15.30
648Montenegro - CELL40.30
124Montserrat21.40
598Montserrat - CELL44.40
115Morocco1.60
625Morocco - Casablanca27.05
511Morocco - CELL31.00
626Morocco - Rabat25.87
120Mozambique11.20
512Mozambique - CELL16.66
125Myanmar (Burma)10.80
599Myanmar (Burma) - CELL12.70
126Namibia6.20
513Namibia - CELL3.50
127Nauru102.77
129Nepal9.70
515Nepal - CELL11.40
617Nepal - Katmandu11.30
131Nether. Antilles7.20
516Nether. Antilles - CELL25.31
975Nether. Antilles - Curacao4.80
977Nether. Antilles - St. Martin9.60
978Nether. Antilles - St. Martin CELL11.40
132Netherlands0.80
372Netherlands - CELL1.80
643Nevis37.81
136New Caledonia15.10
135New Zealand1.30
437New Zealand - CELL3.40
133Nicaragua12.20
517Nicaragua - CELL16.80
979Nicaragua - Managua21.40
230Niger18.60
600Niger - CELL21.30
130Nigeria4.80
518Nigeria - CELL3.30
996Nigeria - Ilorin33.40
627Nigeria - Lagos5.30
134Niue Isl.57.00
139Norfolk Isl.50.00
142Northern Mariana Islands3.30
137Norway0.60
373Norway - CELL0.90
149Oman10.00
521Oman - CELL18.80
151Pakistan4.10
466Pakistan - CELL3.60
464Pakistan - Karachi33.29
465Pakistan - Lahore36.59
152Palau21.20
601Palau - CELL22.40
618Palestine15.60
619Palestine - CELL17.80
153Panama2.00
522Panama - CELL8.00
636Panama - Panama-City7.37
154Papua New Guinea58.50
523Papua New Guinea - CELL85.90
155Paraguay2.00
467Paraguay - Asuncion2.00
550Paraguay - CELL2.90
156Peru0.50
524Peru - CELL0.50
468Peru - Lima0.50
201Philippines10.50
981Philippines - Cebu20.19
375Philippines - CELL10.40
374Philippines - Manila27.70
157Poland1.00
260Poland - CELL1.70
259Poland - Warsaw5.89
158Portugal0.50
438Portugal - CELL1.00
159Puerto Rico0.30
86Qatar14.80
525Qatar - CELL15.10
140Reunion Isl.1.30
526Reunion Isl. - CELL5.80
163Romania0.50
271Romania - Bucharest12.00
274Romania - CELL1.40
161Russia1.90
1037Russia - Abkhazia17.00
279Russia - CELL3.80
247Russia - Moscow1.20
982Russia - Rostovdon7.44
248Russia - S.Peter1.10
162Rwanda26.40
602Rwanda - CELL25.10
165San Marino5.30
166Sao Tome72.80
168Saudi Arabia8.60
470Saudi Arabia - CELL11.50
469Saudi Arabia - Jeddah7.32
410Saudi Arabia - Riyadh8.73
174Senegal25.61
527Senegal - CELL17.20
376Senegal - Dakar34.10
218Serbia14.30
451Serbia - CELL39.40
1021Serbia - Kosovo35.80
171Seychelles Isl.30.42
605Seychelles Isl. - CELL30.45
233Sierra Leone37.39
528Sierra Leone - CELL39.50
983Sierra Leone - Freetown23.43
175Singapore0.90
377Singapore - CELL0.80
1044Sint Maarten10.90
240Slovakia0.50
440Slovakia - CELL4.20
177Slovenia8.30
441Slovenia - CELL21.20
178Solomon Island73.10
179Somalia43.00
606Somalia - CELL21.90
219South Africa2.90
380South Africa - CELL3.20
1030South Sudan30.80
1033South Sudan - CELL33.30
79Spain0.50
381Spain - CELL1.40
4Special Services23.00
212Sri Lanka13.90
442Sri Lanka - CELL13.50
984Sri Lanka - Colombo19.17
231St. Helena91.63
242St. Kitts16.30
530St. Kitts - CELL17.30
167St. Lucia13.20
531St. Lucia - CELL17.60
172St. Vincent13.10
532St. Vincent - CELL18.70
173St.Pierre&Miquel27.06
180Sudan14.20
609Sudan - CELL13.60
181Suriname12.80
533Suriname - CELL13.60
169Swaziland7.00
534Swaziland - CELL9.50
211Sweden0.50
387Sweden - CELL0.80
210Switzerland1.30
389Switzerland - CELL8.60
176Syria13.80
610Syria - CELL19.40
184Taiwan1.80
390Taiwan - CELL7.70
639Taiwan - Taipei4.17
183Tajikistan11.10
443Tajikistan - CELL14.60
186Tanzania27.80
535Tanzania - CELL27.30
611Tanzania - Dar Es Salaam19.47
185Thailand0.90
412Thailand - Bangkok7.18
445Thailand - CELL1.00
187Togo26.40
612Togo - CELL28.50
188Tokelau96.50
189Tonga40.78
553Tonga - CELL67.30
190Trinidad&Tobago4.50
536Trinidad&Tobago - CELL15.20
192Tunisia28.72
537Tunisia - CELL71.42
194Turkey2.60
628Turkey - Ankara16.70
391Turkey - CELL5.90
392Turkey - Istanbul14.10
985Turkey - Izmir16.70
193Turkmenistan9.30
446Turkmenistan - CELL10.90
146Turks&Caicos24.04
614Turks&Caicos - CELL19.40
191Tuvalu85.50
148UAE12.30
447UAE - CELL14.50
195Uganda13.95
539Uganda - CELL19.52
286UK0.60
262UK - CELL1.00
197Ukraine11.60
393Ukraine - CELL10.90
472Ukraine - Dnepropetrovsk13.06
685Ukraine - Kharkov14.65
250Ukraine - Kiev17.45
471Ukraine - Lvov15.56
198Uruguay4.70
540Uruguay - CELL12.90
1025Uruguay - Montevideo3.40
239US Virgin Isl.1.30
182USA0.50
283USA - Alaska1.60
284USA - Hawaii0.70
1056USA - Toll Free2.70
196Uzbekistan6.30
449Uzbekistan - CELL6.60
38Vanuatu73.40
541Vanuatu - CELL73.40
42Venezuela0.70
413Venezuela - Caracas5.10
450Venezuela - CELL4.90
414Venezuela - Maracaibo15.00
43Vietnam5.60
396Vietnam - CELL5.60
688Vietnam - Ho Chi Minh39.97
147Wallis&Fortuna29.20
69Western Samoa55.78
542Western Samoa - CELL85.50
223Yemen12.50
543Yemen - CELL12.50
68Zambia13.71
545Zambia - CELL31.90
989Zambia - Lusaka9.90
70Zimbabwe11.22
546Zimbabwe - CELL30.50