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

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

error = 

result = Array
(
    [0] => Array
        (
            [id] => 40104
            [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] => 512
            [cur_id] => 224
            [cur_name] => USD
            [cur_b] => 73.25
            [cur_b_old] => 73.25
            [cur_s] => 81.55
            [cur_s_old] => 81.55
            [cur_dt] => 1680082380
            [dt] => 1680298583
            [abli_bank_id] => 6
        )

    [1] => Array
        (
            [id] => 40104
            [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] => 512
            [cur_id] => 225
            [cur_name] => EUR
            [cur_b] => 79.75
            [cur_b_old] => 79.75
            [cur_s] => 86.85
            [cur_s_old] => 86.85
            [cur_dt] => 1680082680
            [dt] => 1680298583
            [abli_bank_id] => 6
        )

    [2] => Array
        (
            [id] => 42464
            [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] => 512
            [cur_id] => 212
            [cur_name] => USD
            [cur_b] => 75.12
            [cur_b_old] => 75.12
            [cur_s] => 79.12
            [cur_s_old] => 79.12
            [cur_dt] => 1680264000
            [dt] => 1680298583
            [abli_bank_id] => 11
        )

    [3] => Array
        (
            [id] => 42464
            [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] => 512
            [cur_id] => 213
            [cur_name] => EUR
            [cur_b] => 82.13
            [cur_b_old] => 82.13
            [cur_s] => 86.63
            [cur_s_old] => 86.63
            [cur_dt] => 1680298440
            [dt] => 1680298583
            [abli_bank_id] => 11
        )

    [4] => Array
        (
            [id] => 42464
            [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] => 512
            [cur_id] => 569
            [cur_name] => CNY
            [cur_b] => 10.31
            [cur_b_old] => 10.31
            [cur_s] => 13.41
            [cur_s_old] => 13.41
            [cur_dt] => 1680298380
            [dt] => 1680298583
            [abli_bank_id] => 11
        )

    [5] => Array
        (
            [id] => 42464
            [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] => 512
            [cur_id] => 570
            [cur_name] => CHF
            [cur_b] => 55.12
            [cur_b_old] => 55.12
            [cur_s] => 95.12
            [cur_s_old] => 95.12
            [cur_dt] => 1680298380
            [dt] => 1680298583
            [abli_bank_id] => 11
        )

    [6] => Array
        (
            [id] => 43385
            [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] => 512
            [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] => 1680298440
            [dt] => 1680298570
            [abli_bank_id] => 17
        )

    [7] => Array
        (
            [id] => 43385
            [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] => 512
            [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] => 1680298320
            [dt] => 1680298570
            [abli_bank_id] => 17
        )

    [8] => Array
        (
            [id] => 43651
            [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] => 512
            [cur_id] => 16
            [cur_name] => USD
            [cur_b] => 75.27
            [cur_b_old] => 77.23
            [cur_s] => 81.04
            [cur_s_old] => 79.04
            [cur_dt] => 1680298500
            [dt] => 1680298634
            [abli_bank_id] => 19
        )

    [9] => Array
        (
            [id] => 43651
            [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] => 512
            [cur_id] => 17
            [cur_name] => EUR
            [cur_b] => 80.99
            [cur_b_old] => 84.36
            [cur_s] => 88.46
            [cur_s_old] => 85.83
            [cur_dt] => 1680298500
            [dt] => 1680298634
            [abli_bank_id] => 19
        )

    [10] => Array
        (
            [id] => 44398
            [yid] => 101
            [license] => 3255
            [name] => Банк Зенит
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2846
            [address] => 117638, г. Москва, Одесская ул., д. 2
            [bank_url] => www.zenit.ru
            [phone] => 8 800 500-66-77, — единая справочная служба
            [bankiru_id] => 863
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 863
            [region_id] => 512
            [cur_id] => 449
            [cur_name] => USD
            [cur_b] => 76.30
            [cur_b_old] => 77.10
            [cur_s] => 79.00
            [cur_s_old] => 78.70
            [cur_dt] => 1680298140
            [dt] => 1680298573
            [abli_bank_id] => 28
        )

    [11] => Array
        (
            [id] => 44398
            [yid] => 101
            [license] => 3255
            [name] => Банк Зенит
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 2846
            [address] => 117638, г. Москва, Одесская ул., д. 2
            [bank_url] => www.zenit.ru
            [phone] => 8 800 500-66-77, — единая справочная служба
            [bankiru_id] => 863
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 863
            [region_id] => 512
            [cur_id] => 450
            [cur_name] => EUR
            [cur_b] => 83.50
            [cur_b_old] => 84.10
            [cur_s] => 86.30
            [cur_s_old] => 85.90
            [cur_dt] => 1680298260
            [dt] => 1680298573
            [abli_bank_id] => 28
        )

    [12] => Array
        (
            [id] => 45919
            [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] => 512
            [cur_id] => 564
            [cur_name] => USD
            [cur_b] => 75.50
            [cur_b_old] => 75.50
            [cur_s] => 84.50
            [cur_s_old] => 84.50
            [cur_dt] => 1680298260
            [dt] => 1680298652
            [abli_bank_id] => 43
        )

    [13] => Array
        (
            [id] => 45919
            [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] => 512
            [cur_id] => 565
            [cur_name] => EUR
            [cur_b] => 82.40
            [cur_b_old] => 82.40
            [cur_s] => 91.40
            [cur_s_old] => 91.40
            [cur_dt] => 1680298260
            [dt] => 1680298652
            [abli_bank_id] => 43
        )

    [14] => Array
        (
            [id] => 45919
            [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] => 512
            [cur_id] => 566
            [cur_name] => CNY
            [cur_b] => 10.50
            [cur_b_old] => 10.50
            [cur_s] => 13.00
            [cur_s_old] => 13.00
            [cur_dt] => 1680298260
            [dt] => 1680298652
            [abli_bank_id] => 43
        )

    [15] => Array
        (
            [id] => 45919
            [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] => 512
            [cur_id] => 567
            [cur_name] => GBP
            [cur_b] => 89.00
            [cur_b_old] => 89.00
            [cur_s] => 103.00
            [cur_s_old] => 103.00
            [cur_dt] => 1680298260
            [dt] => 1680298652
            [abli_bank_id] => 43
        )

    [16] => Array
        (
            [id] => 45919
            [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] => 512
            [cur_id] => 568
            [cur_name] => CHF
            [cur_b] => 78.00
            [cur_b_old] => 78.00
            [cur_s] => 92.00
            [cur_s_old] => 92.00
            [cur_dt] => 1680298260
            [dt] => 1680298652
            [abli_bank_id] => 43
        )

    [17] => Array
        (
            [id] => 47384
            [yid] => 0
            [license] => 705
            [name] => Банк Синара (СКБ-Банк)
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6659
            [address] => 620026, г. Екатеринбург, ул. Куйбышева, д. 75
            [bank_url] => www.skbbank.ru
            [phone] => 8 800 100-06-00, — единая справочная служба
            [bankiru_id] => 96003
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 96003
            [region_id] => 512
            [cur_id] => 251
            [cur_name] => USD
            [cur_b] => 77.34
            [cur_b_old] => 77.34
            [cur_s] => 80.35
            [cur_s_old] => 80.35
            [cur_dt] => 1680298500
            [dt] => 1680298666
            [abli_bank_id] => 57
        )

    [18] => Array
        (
            [id] => 47384
            [yid] => 0
            [license] => 705
            [name] => Банк Синара (СКБ-Банк)
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6659
            [address] => 620026, г. Екатеринбург, ул. Куйбышева, д. 75
            [bank_url] => www.skbbank.ru
            [phone] => 8 800 100-06-00, — единая справочная служба
            [bankiru_id] => 96003
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 96003
            [region_id] => 512
            [cur_id] => 252
            [cur_name] => EUR
            [cur_b] => 84.12
            [cur_b_old] => 84.12
            [cur_s] => 87.13
            [cur_s_old] => 87.13
            [cur_dt] => 1680298500
            [dt] => 1680298666
            [abli_bank_id] => 57
        )

)

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

Внимание! Актуальные курсы скоро обновятся.

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