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

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

error = 

result = Array
(
    [0] => Array
        (
            [id] => 30380
            [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] => 1086
            [cur_id] => 243
            [cur_name] => USD
            [cur_b] => 72.25
            [cur_b_old] => 72.25
            [cur_s] => 76.37
            [cur_s_old] => 76.37
            [cur_dt] => 1614631260
            [dt] => 1614631639
            [abli_bank_id] => 1
        )

    [1] => Array
        (
            [id] => 30380
            [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] => 1086
            [cur_id] => 244
            [cur_name] => EUR
            [cur_b] => 87.42
            [cur_b_old] => 87.42
            [cur_s] => 91.91
            [cur_s_old] => 91.91
            [cur_dt] => 1614631260
            [dt] => 1614631639
            [abli_bank_id] => 1
        )

    [2] => Array
        (
            [id] => 30380
            [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] => 1086
            [cur_id] => 550
            [cur_name] => GBP
            [cur_b] => 99.22
            [cur_b_old] => 99.22
            [cur_s] => 108.38
            [cur_s_old] => 108.38
            [cur_dt] => 1614631380
            [dt] => 1614631639
            [abli_bank_id] => 1
        )

    [3] => Array
        (
            [id] => 30380
            [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] => 1086
            [cur_id] => 551
            [cur_name] => CHF
            [cur_b] => 78.26
            [cur_b_old] => 78.26
            [cur_s] => 85.08
            [cur_s_old] => 85.08
            [cur_dt] => 1614631260
            [dt] => 1614631639
            [abli_bank_id] => 1
        )

    [4] => Array
        (
            [id] => 30380
            [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] => 1086
            [cur_id] => 552
            [cur_name] => JPY
            [cur_b] => 66.47
            [cur_b_old] => 66.47
            [cur_s] => 72.90
            [cur_s_old] => 72.90
            [cur_dt] => 1614631440
            [dt] => 1614631639
            [abli_bank_id] => 1
        )

    [5] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 224
            [cur_name] => USD
            [cur_b] => 72.50
            [cur_b_old] => 73.25
            [cur_s] => 75.50
            [cur_s_old] => 75.25
            [cur_dt] => 1614617400
            [dt] => 1614633422
            [abli_bank_id] => 6
        )

    [6] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 225
            [cur_name] => EUR
            [cur_b] => 87.70
            [cur_b_old] => 88.45
            [cur_s] => 90.70
            [cur_s_old] => 90.45
            [cur_dt] => 1614610260
            [dt] => 1614633422
            [abli_bank_id] => 6
        )

    [7] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 469
            [cur_name] => AUD
            [cur_b] => 56.00
            [cur_b_old] => 56.00
            [cur_s] => 60.60
            [cur_s_old] => 60.60
            [cur_dt] => 1614628800
            [dt] => 1614631621
            [abli_bank_id] => 6
        )

    [8] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 470
            [cur_name] => CNY
            [cur_b] => 11.20
            [cur_b_old] => 11.20
            [cur_s] => 11.65
            [cur_s_old] => 11.65
            [cur_dt] => 1614631140
            [dt] => 1614631621
            [abli_bank_id] => 6
        )

    [9] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 471
            [cur_name] => NOK
            [cur_b] => 81.93
            [cur_b_old] => 83.85
            [cur_s] => 88.03
            [cur_s_old] => 89.15
            [cur_dt] => 1614617400
            [dt] => 1614633422
            [abli_bank_id] => 6
        )

    [10] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 472
            [cur_name] => GBP
            [cur_b] => 100.95
            [cur_b_old] => 100.95
            [cur_s] => 105.85
            [cur_s_old] => 105.85
            [cur_dt] => 1614631140
            [dt] => 1614631621
            [abli_bank_id] => 6
        )

    [11] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 473
            [cur_name] => SEK
            [cur_b] => 85.42
            [cur_b_old] => 85.75
            [cur_s] => 91.64
            [cur_s_old] => 90.95
            [cur_dt] => 1614617400
            [dt] => 1614633422
            [abli_bank_id] => 6
        )

    [12] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 474
            [cur_name] => CHF
            [cur_b] => 79.05
            [cur_b_old] => 79.05
            [cur_s] => 83.45
            [cur_s_old] => 83.45
            [cur_dt] => 1614631140
            [dt] => 1614631621
            [abli_bank_id] => 6
        )

    [13] => Array
        (
            [id] => 40419
            [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] => 1086
            [cur_id] => 475
            [cur_name] => JPY
            [cur_b] => 67.35
            [cur_b_old] => 67.35
            [cur_s] => 72.35
            [cur_s_old] => 72.35
            [cur_dt] => 1614631140
            [dt] => 1614631621
            [abli_bank_id] => 6
        )

    [14] => Array
        (
            [id] => 45442
            [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] => 1086
            [cur_id] => 373
            [cur_name] => USD
            [cur_b] => 73.10
            [cur_b_old] => 73.10
            [cur_s] => 75.10
            [cur_s_old] => 75.10
            [cur_dt] => 1614634380
            [dt] => 1614634852
            [abli_bank_id] => 42
        )

    [15] => Array
        (
            [id] => 45442
            [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] => 1086
            [cur_id] => 374
            [cur_name] => EUR
            [cur_b] => 88.30
            [cur_b_old] => 88.30
            [cur_s] => 90.50
            [cur_s_old] => 90.50
            [cur_dt] => 1614634380
            [dt] => 1614634852
            [abli_bank_id] => 42
        )

    [16] => Array
        (
            [id] => 50901
            [yid] => 0
            [license] => 3252
            [name] => Газэнергобанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6745
            [address] => 248030, г. Калуга, ул. Плеханова, д. 4
            [bank_url] => www.gebank.ru
            [phone] => 8 800 700-3000, — единая справочная служба, (4842) 55-77-55
            [bankiru_id] => 193300
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 193300
            [region_id] => 1086
            [cur_id] => 418
            [cur_name] => USD
            [cur_b] => 73.65
            [cur_b_old] => 73.65
            [cur_s] => 74.62
            [cur_s_old] => 74.62
            [cur_dt] => 1614634380
            [dt] => 1614634697
            [abli_bank_id] => 183
        )

    [17] => Array
        (
            [id] => 50901
            [yid] => 0
            [license] => 3252
            [name] => Газэнергобанк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6745
            [address] => 248030, г. Калуга, ул. Плеханова, д. 4
            [bank_url] => www.gebank.ru
            [phone] => 8 800 700-3000, — единая справочная служба, (4842) 55-77-55
            [bankiru_id] => 193300
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 193300
            [region_id] => 1086
            [cur_id] => 419
            [cur_name] => EUR
            [cur_b] => 88.76
            [cur_b_old] => 88.76
            [cur_s] => 89.74
            [cur_s_old] => 89.74
            [cur_dt] => 1614603000
            [dt] => 1614634697
            [abli_bank_id] => 183
        )

)

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

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