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