Курсы валют в Бийске

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

error = 

result = Array
(
    [0] => Array
        (
            [id] => 29828
            [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] => 497
            [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] => 1664071440
            [dt] => 1664071568
            [abli_bank_id] => 1
        )

    [1] => Array
        (
            [id] => 29828
            [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] => 497
            [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] => 1664071320
            [dt] => 1664071568
            [abli_bank_id] => 1
        )

    [2] => Array
        (
            [id] => 29828
            [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] => 497
            [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] => 1664071380
            [dt] => 1664071568
            [abli_bank_id] => 1
        )

    [3] => Array
        (
            [id] => 29828
            [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] => 497
            [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] => 1664071500
            [dt] => 1664071568
            [abli_bank_id] => 1
        )

    [4] => Array
        (
            [id] => 29828
            [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] => 497
            [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] => 1664071500
            [dt] => 1664071568
            [abli_bank_id] => 1
        )

    [5] => Array
        (
            [id] => 40095
            [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] => 497
            [cur_id] => 224
            [cur_name] => USD
            [cur_b] => 54.70
            [cur_b_old] => 55.40
            [cur_s] => 73.20
            [cur_s_old] => 72.10
            [cur_dt] => 1664080020
            [dt] => 1664080607
            [abli_bank_id] => 6
        )

    [6] => Array
        (
            [id] => 40095
            [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] => 497
            [cur_id] => 225
            [cur_name] => EUR
            [cur_b] => 56.00
            [cur_b_old] => 54.15
            [cur_s] => 74.80
            [cur_s_old] => 70.15
            [cur_dt] => 1663914780
            [dt] => 1664080607
            [abli_bank_id] => 6
        )

    [7] => Array
        (
            [id] => 43648
            [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] => 497
            [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] => 1664080320
            [dt] => 1664080703
            [abli_bank_id] => 19
        )

    [8] => Array
        (
            [id] => 43648
            [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] => 497
            [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] => 1664080260
            [dt] => 1664080703
            [abli_bank_id] => 19
        )

    [9] => Array
        (
            [id] => 45905
            [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] => 497
            [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] => 1664080736
            [abli_bank_id] => 43
        )

    [10] => Array
        (
            [id] => 45905
            [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] => 497
            [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] => 1664080736
            [abli_bank_id] => 43
        )

    [11] => Array
        (
            [id] => 45905
            [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] => 497
            [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] => 1664080736
            [abli_bank_id] => 43
        )

    [12] => Array
        (
            [id] => 45905
            [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] => 497
            [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] => 1664080736
            [abli_bank_id] => 43
        )

    [13] => Array
        (
            [id] => 45905
            [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] => 497
            [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] => 1664080736
            [abli_bank_id] => 43
        )

    [14] => Array
        (
            [id] => 46924
            [yid] => 0
            [license] => 1810
            [name] => Азиатско-Тихоокеанский Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6657
            [address] => 675000, Амурская обл., г. Благовещенск, ул. Амурская, д. 225
            [bank_url] => www.atb.su
            [phone] => 8 800 775-88-88, — единая справочная служба
            [bankiru_id] => 192833
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192833
            [region_id] => 497
            [cur_id] => 420
            [cur_name] => USD
            [cur_b] => 73.80
            [cur_b_old] => 58.04
            [cur_s] => 74.55
            [cur_s_old] => 89.03
            [cur_dt] => 1664079420
            [dt] => 1664079691
            [abli_bank_id] => 52
        )

    [15] => Array
        (
            [id] => 46924
            [yid] => 0
            [license] => 1810
            [name] => Азиатско-Тихоокеанский Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6657
            [address] => 675000, Амурская обл., г. Благовещенск, ул. Амурская, д. 225
            [bank_url] => www.atb.su
            [phone] => 8 800 775-88-88, — единая справочная служба
            [bankiru_id] => 192833
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192833
            [region_id] => 497
            [cur_id] => 421
            [cur_name] => EUR
            [cur_b] => 56.89
            [cur_b_old] => 56.89
            [cur_s] => 72.50
            [cur_s_old] => 72.50
            [cur_dt] => 1664079540
            [dt] => 1664079691
            [abli_bank_id] => 52
        )

    [16] => Array
        (
            [id] => 46924
            [yid] => 0
            [license] => 1810
            [name] => Азиатско-Тихоокеанский Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6657
            [address] => 675000, Амурская обл., г. Благовещенск, ул. Амурская, д. 225
            [bank_url] => www.atb.su
            [phone] => 8 800 775-88-88, — единая справочная служба
            [bankiru_id] => 192833
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192833
            [region_id] => 497
            [cur_id] => 422
            [cur_name] => GBP
            [cur_b] => 0.00
            [cur_b_old] => 0.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1664072160
            [dt] => 1664072548
            [abli_bank_id] => 52
        )

    [17] => Array
        (
            [id] => 46924
            [yid] => 0
            [license] => 1810
            [name] => Азиатско-Тихоокеанский Банк
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 6657
            [address] => 675000, Амурская обл., г. Благовещенск, ул. Амурская, д. 225
            [bank_url] => www.atb.su
            [phone] => 8 800 775-88-88, — единая справочная служба
            [bankiru_id] => 192833
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192833
            [region_id] => 497
            [cur_id] => 423
            [cur_name] => CHF
            [cur_b] => 0.00
            [cur_b_old] => 0.00
            [cur_s] => 0.00
            [cur_s_old] => 0.00
            [cur_dt] => 1664072220
            [dt] => 1664072548
            [abli_bank_id] => 52
        )

    [18] => Array
        (
            [id] => 52250
            [yid] => 57925
            [license] => 567
            [name] => Банк Акцепт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3156
            [address] => 630099, г. Новосибирск, ул. Советская, д. 14
            [bank_url] => www.akcept.ru
            [phone] => 8 800 100-27-37, — единая справочная служба
            [bankiru_id] => 192866
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192866
            [region_id] => 497
            [cur_id] => 537
            [cur_name] => USD
            [cur_b] => 58.10
            [cur_b_old] => 58.10
            [cur_s] => 67.90
            [cur_s_old] => 67.90
            [cur_dt] => 1664072340
            [dt] => 1664072589
            [abli_bank_id] => 226
        )

    [19] => Array
        (
            [id] => 52250
            [yid] => 57925
            [license] => 567
            [name] => Банк Акцепт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3156
            [address] => 630099, г. Новосибирск, ул. Советская, д. 14
            [bank_url] => www.akcept.ru
            [phone] => 8 800 100-27-37, — единая справочная служба
            [bankiru_id] => 192866
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192866
            [region_id] => 497
            [cur_id] => 538
            [cur_name] => EUR
            [cur_b] => 58.10
            [cur_b_old] => 58.10
            [cur_s] => 67.90
            [cur_s_old] => 67.90
            [cur_dt] => 1664072340
            [dt] => 1664072589
            [abli_bank_id] => 226
        )

    [20] => Array
        (
            [id] => 52250
            [yid] => 57925
            [license] => 567
            [name] => Банк Акцепт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3156
            [address] => 630099, г. Новосибирск, ул. Советская, д. 14
            [bank_url] => www.akcept.ru
            [phone] => 8 800 100-27-37, — единая справочная служба
            [bankiru_id] => 192866
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192866
            [region_id] => 497
            [cur_id] => 539
            [cur_name] => GBP
            [cur_b] => 55.00
            [cur_b_old] => 55.00
            [cur_s] => 77.00
            [cur_s_old] => 77.00
            [cur_dt] => 1664072340
            [dt] => 1664072589
            [abli_bank_id] => 226
        )

    [21] => Array
        (
            [id] => 52250
            [yid] => 57925
            [license] => 567
            [name] => Банк Акцепт
            [shortname] => 
            [vbanke] => 
            [banka] => 
            [post_id] => 3156
            [address] => 630099, г. Новосибирск, ул. Советская, д. 14
            [bank_url] => www.akcept.ru
            [phone] => 8 800 100-27-37, — единая справочная служба
            [bankiru_id] => 192866
            [bankiru_url] => 
            [bank_export_url] => 
            [license_revoked] => 0
            [bank_export_exchange_rates_url] => 
            [bank_id] => 192866
            [region_id] => 497
            [cur_id] => 540
            [cur_name] => CHF
            [cur_b] => 50.00
            [cur_b_old] => 50.00
            [cur_s] => 67.00
            [cur_s_old] => 67.00
            [cur_dt] => 1664072340
            [dt] => 1664072589
            [abli_bank_id] => 226
        )

)

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

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