Курсы валют в Горячем Ключе

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` = 987) AND (`cur`.`dt` > '1664018946')

error = 

result = Array
(
    [0] => Array
        (
            [id] => 30285
            [yid] => 23441
            [license] => 1481
            [name] => Сбербанк России
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2574
            [address] => 117997, г. Москва, ул. Вавилова, д. 19
            [bank_url] => www.sberbank.ru
            [phone] => 8(800) 555-55-50, 8(800) 555-57-77
            [bankiru_id] => 322
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 322
            [region_id] => 987
            [cur_id] => 243
            [cur_name] => USD
            [cur_b] => 54.50
            [cur_b_old] => 54.50
            [cur_s] => 74.85
            [cur_s_old] => 74.85
            [cur_dt] => 1664101620
            [dt] => 1664102168
            [abli_bank_id] => 1
        )

    [1] => Array
        (
            [id] => 30285
            [yid] => 23441
            [license] => 1481
            [name] => Сбербанк России
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2574
            [address] => 117997, г. Москва, ул. Вавилова, д. 19
            [bank_url] => www.sberbank.ru
            [phone] => 8(800) 555-55-50, 8(800) 555-57-77
            [bankiru_id] => 322
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 322
            [region_id] => 987
            [cur_id] => 244
            [cur_name] => EUR
            [cur_b] => 51.01
            [cur_b_old] => 51.01
            [cur_s] => 73.41
            [cur_s_old] => 73.41
            [cur_dt] => 1664101920
            [dt] => 1664102168
            [abli_bank_id] => 1
        )

    [2] => Array
        (
            [id] => 30285
            [yid] => 23441
            [license] => 1481
            [name] => Сбербанк России
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2574
            [address] => 117997, г. Москва, ул. Вавилова, д. 19
            [bank_url] => www.sberbank.ru
            [phone] => 8(800) 555-55-50, 8(800) 555-57-77
            [bankiru_id] => 322
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 322
            [region_id] => 987
            [cur_id] => 550
            [cur_name] => GBP
            [cur_b] => 41.30
            [cur_b_old] => 41.30
            [cur_s] => 72.35
            [cur_s_old] => 72.35
            [cur_dt] => 1664101560
            [dt] => 1664102168
            [abli_bank_id] => 1
        )

    [3] => Array
        (
            [id] => 30285
            [yid] => 23441
            [license] => 1481
            [name] => Сбербанк России
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2574
            [address] => 117997, г. Москва, ул. Вавилова, д. 19
            [bank_url] => www.sberbank.ru
            [phone] => 8(800) 555-55-50, 8(800) 555-57-77
            [bankiru_id] => 322
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 322
            [region_id] => 987
            [cur_id] => 551
            [cur_name] => CHF
            [cur_b] => 41.98
            [cur_b_old] => 41.98
            [cur_s] => 63.13
            [cur_s_old] => 63.13
            [cur_dt] => 1664101680
            [dt] => 1664102168
            [abli_bank_id] => 1
        )

    [4] => Array
        (
            [id] => 30285
            [yid] => 23441
            [license] => 1481
            [name] => Сбербанк России
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2574
            [address] => 117997, г. Москва, ул. Вавилова, д. 19
            [bank_url] => www.sberbank.ru
            [phone] => 8(800) 555-55-50, 8(800) 555-57-77
            [bankiru_id] => 322
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 322
            [region_id] => 987
            [cur_id] => 552
            [cur_name] => JPY
            [cur_b] => 33.44
            [cur_b_old] => 33.44
            [cur_s] => 52.53
            [cur_s_old] => 52.53
            [cur_dt] => 1664101680
            [dt] => 1664102168
            [abli_bank_id] => 1
        )

    [5] => Array
        (
            [id] => 42061
            [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] => 987
            [cur_id] => 380
            [cur_name] => USD
            [cur_b] => 62.80
            [cur_b_old] => 62.80
            [cur_s] => 74.95
            [cur_s_old] => 74.95
            [cur_dt] => 1664103480
            [dt] => 1664103979
            [abli_bank_id] => 8
        )

    [6] => Array
        (
            [id] => 42061
            [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] => 987
            [cur_id] => 381
            [cur_name] => EUR
            [cur_b] => 61.20
            [cur_b_old] => 61.20
            [cur_s] => 73.40
            [cur_s_old] => 73.40
            [cur_dt] => 1664103540
            [dt] => 1664103979
            [abli_bank_id] => 8
        )

    [7] => Array
        (
            [id] => 40373
            [yid] => 173
            [license] => 3349
            [name] => Россельхозбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2534
            [address] => 119034, г. Москва, Гагаринский пер., д. 3
            [bank_url] => www.rshb.ru
            [phone] => 8 800 100-01-00, — единая справочная служба
            [bankiru_id] => 4725
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 4725
            [region_id] => 987
            [cur_id] => 224
            [cur_name] => USD
            [cur_b] => 54.70
            [cur_b_old] => 54.70
            [cur_s] => 73.20
            [cur_s_old] => 73.20
            [cur_dt] => 1664103780
            [dt] => 1664103994
            [abli_bank_id] => 6
        )

    [8] => Array
        (
            [id] => 40373
            [yid] => 173
            [license] => 3349
            [name] => Россельхозбанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2534
            [address] => 119034, г. Москва, Гагаринский пер., д. 3
            [bank_url] => www.rshb.ru
            [phone] => 8 800 100-01-00, — единая справочная служба
            [bankiru_id] => 4725
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 4725
            [region_id] => 987
            [cur_id] => 225
            [cur_name] => EUR
            [cur_b] => 56.00
            [cur_b_old] => 56.00
            [cur_s] => 74.80
            [cur_s_old] => 74.80
            [cur_dt] => 1663914780
            [dt] => 1664103994
            [abli_bank_id] => 6
        )

    [9] => Array
        (
            [id] => 43686
            [yid] => 88565
            [license] => 30
            [name] => Банк Уралсиб
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2848
            [address] => 119048, г. Москва, ул. Ефремова, д. 8
            [bank_url] => www.uralsib.ru
            [phone] => (495) 723-77-77, (495) 723-77-00, 8 800 250-57-57, — единая справочная служба
            [bankiru_id] => 63520
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 63520
            [region_id] => 987
            [cur_id] => 16
            [cur_name] => USD
            [cur_b] => 53.13
            [cur_b_old] => 53.13
            [cur_s] => 69.28
            [cur_s_old] => 69.28
            [cur_dt] => 1664104080
            [dt] => 1664104208
            [abli_bank_id] => 19
        )

    [10] => Array
        (
            [id] => 43686
            [yid] => 88565
            [license] => 30
            [name] => Банк Уралсиб
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2848
            [address] => 119048, г. Москва, ул. Ефремова, д. 8
            [bank_url] => www.uralsib.ru
            [phone] => (495) 723-77-77, (495) 723-77-00, 8 800 250-57-57, — единая справочная служба
            [bankiru_id] => 63520
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 63520
            [region_id] => 987
            [cur_id] => 17
            [cur_name] => EUR
            [cur_b] => 58.63
            [cur_b_old] => 58.63
            [cur_s] => 71.47
            [cur_s_old] => 71.47
            [cur_dt] => 1664104020
            [dt] => 1664104208
            [abli_bank_id] => 19
        )

    [11] => Array
        (
            [id] => 46123
            [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] => 987
            [cur_id] => 564
            [cur_name] => USD
            [cur_b] => 56.50
            [cur_b_old] => 56.50
            [cur_s] => 71.50
            [cur_s_old] => 71.50
            [cur_dt] => 1663960920
            [dt] => 1664104238
            [abli_bank_id] => 43
        )

    [12] => Array
        (
            [id] => 46123
            [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] => 987
            [cur_id] => 565
            [cur_name] => EUR
            [cur_b] => 54.50
            [cur_b_old] => 54.50
            [cur_s] => 69.50
            [cur_s_old] => 69.50
            [cur_dt] => 1663960920
            [dt] => 1664104238
            [abli_bank_id] => 43
        )

    [13] => Array
        (
            [id] => 46123
            [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] => 987
            [cur_id] => 566
            [cur_name] => CNY
            [cur_b] => 7.50
            [cur_b_old] => 7.50
            [cur_s] => 10.00
            [cur_s_old] => 10.00
            [cur_dt] => 1663960920
            [dt] => 1664104238
            [abli_bank_id] => 43
        )

    [14] => Array
        (
            [id] => 46123
            [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] => 987
            [cur_id] => 567
            [cur_name] => GBP
            [cur_b] => 1.00
            [cur_b_old] => 1.00
            [cur_s] => 999.00
            [cur_s_old] => 999.00
            [cur_dt] => 1663960980
            [dt] => 1664104238
            [abli_bank_id] => 43
        )

    [15] => Array
        (
            [id] => 46123
            [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] => 987
            [cur_id] => 568
            [cur_name] => CHF
            [cur_b] => 1.00
            [cur_b_old] => 1.00
            [cur_s] => 999.00
            [cur_s_old] => 999.00
            [cur_dt] => 1663960980
            [dt] => 1664104238
            [abli_bank_id] => 43
        )

)

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

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