Курсы валют в Соколе

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

error = 

result = Array
(
    [0] => Array
        (
            [id] => 31230
            [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] => 2023
            [cur_id] => 243
            [cur_name] => USD
            [cur_b] => 62.71
            [cur_b_old] => 62.71
            [cur_s] => 78.00
            [cur_s_old] => 78.00
            [cur_dt] => 1664783940
            [dt] => 1664784371
            [abli_bank_id] => 1
        )

    [1] => Array
        (
            [id] => 31230
            [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] => 2023
            [cur_id] => 244
            [cur_name] => EUR
            [cur_b] => 59.82
            [cur_b_old] => 59.82
            [cur_s] => 75.91
            [cur_s_old] => 75.91
            [cur_dt] => 1664783940
            [dt] => 1664784371
            [abli_bank_id] => 1
        )

    [2] => Array
        (
            [id] => 31230
            [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] => 2023
            [cur_id] => 550
            [cur_name] => GBP
            [cur_b] => 41.55
            [cur_b_old] => 41.55
            [cur_s] => 71.34
            [cur_s_old] => 71.34
            [cur_dt] => 1664783940
            [dt] => 1664784371
            [abli_bank_id] => 1
        )

    [3] => Array
        (
            [id] => 31230
            [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] => 2023
            [cur_id] => 551
            [cur_name] => CHF
            [cur_b] => 42.25
            [cur_b_old] => 42.25
            [cur_s] => 62.25
            [cur_s_old] => 62.25
            [cur_dt] => 1664782260
            [dt] => 1664782567
            [abli_bank_id] => 1
        )

    [4] => Array
        (
            [id] => 31230
            [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] => 2023
            [cur_id] => 552
            [cur_name] => JPY
            [cur_b] => 34.16
            [cur_b_old] => 34.16
            [cur_s] => 52.68
            [cur_s_old] => 52.68
            [cur_dt] => 1664783940
            [dt] => 1664784371
            [abli_bank_id] => 1
        )

    [5] => Array
        (
            [id] => 40932
            [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] => 2023
            [cur_id] => 224
            [cur_name] => USD
            [cur_b] => 56.70
            [cur_b_old] => 56.70
            [cur_s] => 73.60
            [cur_s_old] => 73.60
            [cur_dt] => 1664787600
            [dt] => 1664787995
            [abli_bank_id] => 6
        )

    [6] => Array
        (
            [id] => 40932
            [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] => 2023
            [cur_id] => 225
            [cur_name] => EUR
            [cur_b] => 54.85
            [cur_b_old] => 54.85
            [cur_s] => 71.80
            [cur_s_old] => 71.80
            [cur_dt] => 1664787660
            [dt] => 1664787995
            [abli_bank_id] => 6
        )

    [7] => Array
        (
            [id] => 42513
            [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] => 2023
            [cur_id] => 212
            [cur_name] => USD
            [cur_b] => 58.46
            [cur_b_old] => 58.46
            [cur_s] => 64.46
            [cur_s_old] => 64.46
            [cur_dt] => 1664329080
            [dt] => 1664787996
            [abli_bank_id] => 11
        )

    [8] => Array
        (
            [id] => 42513
            [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] => 2023
            [cur_id] => 213
            [cur_name] => EUR
            [cur_b] => 56.20
            [cur_b_old] => 56.20
            [cur_s] => 63.70
            [cur_s_old] => 63.70
            [cur_dt] => 1664329020
            [dt] => 1664787996
            [abli_bank_id] => 11
        )

    [9] => Array
        (
            [id] => 42513
            [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] => 2023
            [cur_id] => 569
            [cur_name] => CNY
            [cur_b] => 7.15
            [cur_b_old] => 7.15
            [cur_s] => 10.25
            [cur_s_old] => 10.25
            [cur_dt] => 1664329080
            [dt] => 1664787996
            [abli_bank_id] => 11
        )

    [10] => Array
        (
            [id] => 42513
            [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] => 2023
            [cur_id] => 570
            [cur_name] => CHF
            [cur_b] => 54.16
            [cur_b_old] => 54.16
            [cur_s] => 69.16
            [cur_s_old] => 69.16
            [cur_dt] => 1664329020
            [dt] => 1664787996
            [abli_bank_id] => 11
        )

    [11] => Array
        (
            [id] => 46430
            [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] => 2023
            [cur_id] => 564
            [cur_name] => USD
            [cur_b] => 57.00
            [cur_b_old] => 57.00
            [cur_s] => 67.00
            [cur_s_old] => 67.00
            [cur_dt] => 1664787420
            [dt] => 1664788093
            [abli_bank_id] => 43
        )

    [12] => Array
        (
            [id] => 46430
            [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] => 2023
            [cur_id] => 565
            [cur_name] => EUR
            [cur_b] => 55.00
            [cur_b_old] => 55.00
            [cur_s] => 66.00
            [cur_s_old] => 66.00
            [cur_dt] => 1664787420
            [dt] => 1664788093
            [abli_bank_id] => 43
        )

    [13] => Array
        (
            [id] => 46430
            [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] => 2023
            [cur_id] => 566
            [cur_name] => CNY
            [cur_b] => 8.70
            [cur_b_old] => 8.70
            [cur_s] => 10.20
            [cur_s_old] => 10.20
            [cur_dt] => 1664787420
            [dt] => 1664788093
            [abli_bank_id] => 43
        )

    [14] => Array
        (
            [id] => 46430
            [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] => 2023
            [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] => 1664787420
            [dt] => 1664788093
            [abli_bank_id] => 43
        )

    [15] => Array
        (
            [id] => 46430
            [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] => 2023
            [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] => 1664787420
            [dt] => 1664788093
            [abli_bank_id] => 43
        )

)

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

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