Курсы валют в Коломне

query = SELECT *, `abli`.`id` AS `abli_bank_id` FROM `wp_all_banks_license_id` `abli` INNER JOIN `wp_banks_bank_region` `bbr` ON (`abli`.`id` = `bbr`.`bank_id`) INNER JOIN `curency` `cur` ON (`abli`.`bankiru_id` = `cur`.`bank_id`) WHERE (`bbr`.`region_id` = 9) AND (`cur`.`dt` > '1674833979')

error = 

result = Array
(
    [0] => Array
        (
            [id] => 41833
            [yid] => 83
            [license] => 2209
            [name] => Банк Открытие
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2700
            [address] => 115114, г. Москва, ул. Летниковская, д. 2, стр. 4
            [bank_url] => www.open.ru
            [phone] => 8 800 444-44-00, — единая справочная служба
            [bankiru_id] => 690
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 690
            [region_id] => 9
            [cur_id] => 380
            [cur_name] => USD
            [cur_b] => 70.40
            [cur_b_old] => 70.40
            [cur_s] => 73.95
            [cur_s_old] => 73.95
            [cur_dt] => 1674919980
            [dt] => 1674920173
            [abli_bank_id] => 8
        )

    [1] => Array
        (
            [id] => 41833
            [yid] => 83
            [license] => 2209
            [name] => Банк Открытие
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2700
            [address] => 115114, г. Москва, ул. Летниковская, д. 2, стр. 4
            [bank_url] => www.open.ru
            [phone] => 8 800 444-44-00, — единая справочная служба
            [bankiru_id] => 690
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 690
            [region_id] => 9
            [cur_id] => 381
            [cur_name] => EUR
            [cur_b] => 75.30
            [cur_b_old] => 75.30
            [cur_s] => 78.40
            [cur_s_old] => 78.40
            [cur_dt] => 1674919980
            [dt] => 1674920173
            [abli_bank_id] => 8
        )

    [2] => Array
        (
            [id] => 42327
            [yid] => 123046
            [license] => 3251
            [name] => Промсвязьбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2513
            [address] => 109052, г. Москва, ул. Смирновская, д. 10, стр. 22
            [bank_url] => www.psbank.ru
            [phone] => 8 800 333-03-03, — для физических лиц, звонок по России бесплатный, 8 800 333-25-50, — для юридических лиц, звонок по России бесплатный
            [bankiru_id] => 5306
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 5306
            [region_id] => 9
            [cur_id] => 212
            [cur_name] => USD
            [cur_b] => 67.50
            [cur_b_old] => 67.50
            [cur_s] => 72.50
            [cur_s_old] => 72.50
            [cur_dt] => 1674919680
            [dt] => 1674920183
            [abli_bank_id] => 11
        )

    [3] => Array
        (
            [id] => 42327
            [yid] => 123046
            [license] => 3251
            [name] => Промсвязьбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2513
            [address] => 109052, г. Москва, ул. Смирновская, д. 10, стр. 22
            [bank_url] => www.psbank.ru
            [phone] => 8 800 333-03-03, — для физических лиц, звонок по России бесплатный, 8 800 333-25-50, — для юридических лиц, звонок по России бесплатный
            [bankiru_id] => 5306
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 5306
            [region_id] => 9
            [cur_id] => 213
            [cur_name] => EUR
            [cur_b] => 72.47
            [cur_b_old] => 72.47
            [cur_s] => 77.97
            [cur_s_old] => 77.97
            [cur_dt] => 1674920100
            [dt] => 1674920183
            [abli_bank_id] => 11
        )

    [4] => Array
        (
            [id] => 42327
            [yid] => 123046
            [license] => 3251
            [name] => Промсвязьбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2513
            [address] => 109052, г. Москва, ул. Смирновская, д. 10, стр. 22
            [bank_url] => www.psbank.ru
            [phone] => 8 800 333-03-03, — для физических лиц, звонок по России бесплатный, 8 800 333-25-50, — для юридических лиц, звонок по России бесплатный
            [bankiru_id] => 5306
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 5306
            [region_id] => 9
            [cur_id] => 569
            [cur_name] => CNY
            [cur_b] => 9.25
            [cur_b_old] => 9.25
            [cur_s] => 12.35
            [cur_s_old] => 12.35
            [cur_dt] => 1674848580
            [dt] => 1674920183
            [abli_bank_id] => 11
        )

    [5] => Array
        (
            [id] => 42327
            [yid] => 123046
            [license] => 3251
            [name] => Промсвязьбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2513
            [address] => 109052, г. Москва, ул. Смирновская, д. 10, стр. 22
            [bank_url] => www.psbank.ru
            [phone] => 8 800 333-03-03, — для физических лиц, звонок по России бесплатный, 8 800 333-25-50, — для юридических лиц, звонок по России бесплатный
            [bankiru_id] => 5306
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 5306
            [region_id] => 9
            [cur_id] => 570
            [cur_name] => CHF
            [cur_b] => 70.36
            [cur_b_old] => 70.36
            [cur_s] => 85.36
            [cur_s_old] => 85.36
            [cur_dt] => 1674920100
            [dt] => 1674920183
            [abli_bank_id] => 11
        )

    [6] => Array
        (
            [id] => 43315
            [yid] => 381
            [license] => 2289
            [name] => Русский Стандарт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2640
            [address] => 105187, г. Москва, ул. Ткацкая, д. 36
            [bank_url] => www.rsb.ru
            [phone] => (495) 748-07-48
            [bankiru_id] => 351
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 351
            [region_id] => 9
            [cur_id] => 518
            [cur_name] => USD
            [cur_b] => 0.00
            [cur_b_old] => 0.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1674920100
            [dt] => 1674920171
            [abli_bank_id] => 17
        )

    [7] => Array
        (
            [id] => 43315
            [yid] => 381
            [license] => 2289
            [name] => Русский Стандарт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2640
            [address] => 105187, г. Москва, ул. Ткацкая, д. 36
            [bank_url] => www.rsb.ru
            [phone] => (495) 748-07-48
            [bankiru_id] => 351
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 351
            [region_id] => 9
            [cur_id] => 519
            [cur_name] => EUR
            [cur_b] => 0.00
            [cur_b_old] => 0.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1674919980
            [dt] => 1674920171
            [abli_bank_id] => 17
        )

    [8] => Array
        (
            [id] => 45587
            [yid] => 123137
            [license] => 963
            [name] => Совкомбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2847
            [address] => 156000, г. Кострома, просп. Текстильщиков, д. 46
            [bank_url] => www.sovcombank.ru
            [phone] => 8 800 200-66-96, 8 800 100-00-06, — единая справочная служба
            [bankiru_id] => 76620
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 1
            [bank_export_exchange_rates_url] => 
            [bank_id] => 76620
            [region_id] => 9
            [cur_id] => 564
            [cur_name] => USD
            [cur_b] => 67.40
            [cur_b_old] => 67.40
            [cur_s] => 76.40
            [cur_s_old] => 76.40
            [cur_dt] => 1674919740
            [dt] => 1674920251
            [abli_bank_id] => 43
        )

    [9] => Array
        (
            [id] => 45587
            [yid] => 123137
            [license] => 963
            [name] => Совкомбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2847
            [address] => 156000, г. Кострома, просп. Текстильщиков, д. 46
            [bank_url] => www.sovcombank.ru
            [phone] => 8 800 200-66-96, 8 800 100-00-06, — единая справочная служба
            [bankiru_id] => 76620
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 1
            [bank_export_exchange_rates_url] => 
            [bank_id] => 76620
            [region_id] => 9
            [cur_id] => 565
            [cur_name] => EUR
            [cur_b] => 73.40
            [cur_b_old] => 73.40
            [cur_s] => 82.40
            [cur_s_old] => 82.40
            [cur_dt] => 1674919740
            [dt] => 1674920251
            [abli_bank_id] => 43
        )

    [10] => Array
        (
            [id] => 45587
            [yid] => 123137
            [license] => 963
            [name] => Совкомбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2847
            [address] => 156000, г. Кострома, просп. Текстильщиков, д. 46
            [bank_url] => www.sovcombank.ru
            [phone] => 8 800 200-66-96, 8 800 100-00-06, — единая справочная служба
            [bankiru_id] => 76620
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 1
            [bank_export_exchange_rates_url] => 
            [bank_id] => 76620
            [region_id] => 9
            [cur_id] => 566
            [cur_name] => CNY
            [cur_b] => 9.50
            [cur_b_old] => 9.50
            [cur_s] => 12.00
            [cur_s_old] => 12.00
            [cur_dt] => 1674919740
            [dt] => 1674920251
            [abli_bank_id] => 43
        )

    [11] => Array
        (
            [id] => 45587
            [yid] => 123137
            [license] => 963
            [name] => Совкомбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2847
            [address] => 156000, г. Кострома, просп. Текстильщиков, д. 46
            [bank_url] => www.sovcombank.ru
            [phone] => 8 800 200-66-96, 8 800 100-00-06, — единая справочная служба
            [bankiru_id] => 76620
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 1
            [bank_export_exchange_rates_url] => 
            [bank_id] => 76620
            [region_id] => 9
            [cur_id] => 567
            [cur_name] => GBP
            [cur_b] => 79.00
            [cur_b_old] => 79.00
            [cur_s] => 93.00
            [cur_s_old] => 93.00
            [cur_dt] => 1674919740
            [dt] => 1674920251
            [abli_bank_id] => 43
        )

    [12] => Array
        (
            [id] => 45587
            [yid] => 123137
            [license] => 963
            [name] => Совкомбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2847
            [address] => 156000, г. Кострома, просп. Текстильщиков, д. 46
            [bank_url] => www.sovcombank.ru
            [phone] => 8 800 200-66-96, 8 800 100-00-06, — единая справочная служба
            [bankiru_id] => 76620
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 1
            [bank_export_exchange_rates_url] => 
            [bank_id] => 76620
            [region_id] => 9
            [cur_id] => 568
            [cur_name] => CHF
            [cur_b] => 68.20
            [cur_b_old] => 68.20
            [cur_s] => 82.20
            [cur_s_old] => 82.20
            [cur_dt] => 1674919740
            [dt] => 1674920251
            [abli_bank_id] => 43
        )

    [13] => Array
        (
            [id] => 45286
            [yid] => 0
            [license] => 912
            [name] => Московский Индустриальный Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6654
            [address] => 115419, г. Москва, ул. Орджоникидзе, д. 5
            [bank_url] => www.minbank.ru
            [phone] => 8 800 100-74-74, — единая справочная служба
            [bankiru_id] => 8594
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 8594
            [region_id] => 9
            [cur_id] => 373
            [cur_name] => USD
            [cur_b] => 67.00
            [cur_b_old] => 67.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1674874500
            [dt] => 1674920193
            [abli_bank_id] => 42
        )

    [14] => Array
        (
            [id] => 45286
            [yid] => 0
            [license] => 912
            [name] => Московский Индустриальный Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6654
            [address] => 115419, г. Москва, ул. Орджоникидзе, д. 5
            [bank_url] => www.minbank.ru
            [phone] => 8 800 100-74-74, — единая справочная служба
            [bankiru_id] => 8594
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 8594
            [region_id] => 9
            [cur_id] => 374
            [cur_name] => EUR
            [cur_b] => 73.00
            [cur_b_old] => 73.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1674874500
            [dt] => 1674920193
            [abli_bank_id] => 42
        )

    [15] => Array
        (
            [id] => 49965
            [yid] => 110346
            [license] => 1885
            [name] => Фора-Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3783
            [address] => 119021, г. Москва, Зубовский б-р, д. 25
            [bank_url] => www.forabank.ru
            [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба
            [bankiru_id] => 80493
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 80493
            [region_id] => 9
            [cur_id] => 303
            [cur_name] => USD
            [cur_b] => 70.45
            [cur_b_old] => 70.45
            [cur_s] => 73.35
            [cur_s_old] => 73.35
            [cur_dt] => 1674849240
            [dt] => 1674920264
            [abli_bank_id] => 109
        )

    [16] => Array
        (
            [id] => 49965
            [yid] => 110346
            [license] => 1885
            [name] => Фора-Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3783
            [address] => 119021, г. Москва, Зубовский б-р, д. 25
            [bank_url] => www.forabank.ru
            [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба
            [bankiru_id] => 80493
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 80493
            [region_id] => 9
            [cur_id] => 304
            [cur_name] => EUR
            [cur_b] => 76.00
            [cur_b_old] => 76.00
            [cur_s] => 78.70
            [cur_s_old] => 78.70
            [cur_dt] => 1674849240
            [dt] => 1674920264
            [abli_bank_id] => 109
        )

    [17] => Array
        (
            [id] => 49965
            [yid] => 110346
            [license] => 1885
            [name] => Фора-Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3783
            [address] => 119021, г. Москва, Зубовский б-р, д. 25
            [bank_url] => www.forabank.ru
            [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба
            [bankiru_id] => 80493
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 80493
            [region_id] => 9
            [cur_id] => 382
            [cur_name] => GBP
            [cur_b] => 84.00
            [cur_b_old] => 84.00
            [cur_s] => 88.50
            [cur_s_old] => 88.50
            [cur_dt] => 1674849180
            [dt] => 1674920264
            [abli_bank_id] => 109
        )

    [18] => Array
        (
            [id] => 49965
            [yid] => 110346
            [license] => 1885
            [name] => Фора-Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3783
            [address] => 119021, г. Москва, Зубовский б-р, д. 25
            [bank_url] => www.forabank.ru
            [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба
            [bankiru_id] => 80493
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 80493
            [region_id] => 9
            [cur_id] => 383
            [cur_name] => CHF
            [cur_b] => 72.00
            [cur_b_old] => 72.00
            [cur_s] => 78.40
            [cur_s_old] => 78.40
            [cur_dt] => 1674849180
            [dt] => 1674920264
            [abli_bank_id] => 109
        )

)

Лучшие курсы обмена наличной валюты в Коломне на сегодня.

Чтобы выгодно поменять доллары, евро на рубли или совершить обратную операцию, воспользуйтесь нашей таблицей. Самые выгодные курсы валют в банках Коломны выделены зеленым цветом.