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` = 9) AND (`cur`.`dt` > '1686219168')
error =
result = Array ( [0] => Array ( [id] => 39783 [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] => 9 [cur_id] => 224 [cur_name] => USD [cur_b] => 77.75 [cur_b_old] => 77.75 [cur_s] => 84.45 [cur_s_old] => 84.45 [cur_dt] => 1686281280 [dt] => 1686281785 [abli_bank_id] => 6 ) [1] => Array ( [id] => 39783 [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] => 9 [cur_id] => 225 [cur_name] => EUR [cur_b] => 84.65 [cur_b_old] => 84.65 [cur_s] => 90.85 [cur_s_old] => 90.85 [cur_dt] => 1686281280 [dt] => 1686281785 [abli_bank_id] => 6 ) [2] => Array ( [id] => 41833 [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] => 9 [cur_id] => 380 [cur_name] => USD [cur_b] => 80.10 [cur_b_old] => 80.10 [cur_s] => 83.75 [cur_s_old] => 83.75 [cur_dt] => 1686281640 [dt] => 1686281774 [abli_bank_id] => 8 ) [3] => Array ( [id] => 41833 [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] => 9 [cur_id] => 381 [cur_name] => EUR [cur_b] => 88.00 [cur_b_old] => 88.00 [cur_s] => 94.00 [cur_s_old] => 94.00 [cur_dt] => 1686281640 [dt] => 1686281774 [abli_bank_id] => 8 ) [4] => Array ( [id] => 42327 [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] => 9 [cur_id] => 212 [cur_name] => USD [cur_b] => 80.54 [cur_b_old] => 80.54 [cur_s] => 83.69 [cur_s_old] => 83.69 [cur_dt] => 1686281280 [dt] => 1686281786 [abli_bank_id] => 11 ) [5] => Array ( [id] => 42327 [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] => 9 [cur_id] => 213 [cur_name] => EUR [cur_b] => 87.12 [cur_b_old] => 87.12 [cur_s] => 90.72 [cur_s_old] => 90.72 [cur_dt] => 1686281280 [dt] => 1686281786 [abli_bank_id] => 11 ) [6] => Array ( [id] => 42327 [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] => 9 [cur_id] => 569 [cur_name] => CNY [cur_b] => 11.30 [cur_b_old] => 11.30 [cur_s] => 12.50 [cur_s_old] => 12.50 [cur_dt] => 1686281280 [dt] => 1686281786 [abli_bank_id] => 11 ) [7] => Array ( [id] => 42327 [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] => 9 [cur_id] => 570 [cur_name] => CHF [cur_b] => 61.70 [cur_b_old] => 61.70 [cur_s] => 101.70 [cur_s_old] => 101.70 [cur_dt] => 1686281280 [dt] => 1686281786 [abli_bank_id] => 11 ) [8] => Array ( [id] => 43315 [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] => 9 [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] => 1686281520 [dt] => 1686281772 [abli_bank_id] => 17 ) [9] => Array ( [id] => 43315 [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] => 9 [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] => 1686281520 [dt] => 1686281772 [abli_bank_id] => 17 ) [10] => Array ( [id] => 45587 [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] => 9 [cur_id] => 564 [cur_name] => USD [cur_b] => 80.70 [cur_b_old] => 80.70 [cur_s] => 87.70 [cur_s_old] => 87.70 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [11] => Array ( [id] => 45587 [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] => 9 [cur_id] => 565 [cur_name] => EUR [cur_b] => 87.10 [cur_b_old] => 87.10 [cur_s] => 94.10 [cur_s_old] => 94.10 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [12] => Array ( [id] => 45587 [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] => 9 [cur_id] => 566 [cur_name] => CNY [cur_b] => 10.60 [cur_b_old] => 10.60 [cur_s] => 14.10 [cur_s_old] => 14.10 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [13] => Array ( [id] => 45587 [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] => 9 [cur_id] => 567 [cur_name] => GBP [cur_b] => 101.50 [cur_b_old] => 101.50 [cur_s] => 111.50 [cur_s_old] => 111.50 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [14] => Array ( [id] => 45587 [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] => 9 [cur_id] => 568 [cur_name] => CHF [cur_b] => 85.85 [cur_b_old] => 85.85 [cur_s] => 92.85 [cur_s_old] => 92.85 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [15] => Array ( [id] => 45587 [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] => 9 [cur_id] => 614 [cur_name] => AED [cur_b] => 22.05 [cur_b_old] => 22.05 [cur_s] => 23.55 [cur_s_old] => 23.55 [cur_dt] => 1686281580 [dt] => 1686281852 [abli_bank_id] => 43 ) [16] => Array ( [id] => 49965 [yid] => 110346 [license] => 1885 [name] => Фора-Банк [shortname] => [vbanke] => [banka] => [post_id] => 3783 [address] => 119021, г. Москва, Зубовский б-р, д. 25 [bank_url] => www.forabank.ru [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба [bankiru_id] => 80493 [bankiru_url] => [bank_export_url] => [license_revoked] => 0 [bank_export_exchange_rates_url] => [bank_id] => 80493 [region_id] => 9 [cur_id] => 303 [cur_name] => USD [cur_b] => 80.60 [cur_b_old] => 80.60 [cur_s] => 83.50 [cur_s_old] => 83.50 [cur_dt] => 1686281340 [dt] => 1686281865 [abli_bank_id] => 109 ) [17] => Array ( [id] => 49965 [yid] => 110346 [license] => 1885 [name] => Фора-Банк [shortname] => [vbanke] => [banka] => [post_id] => 3783 [address] => 119021, г. Москва, Зубовский б-р, д. 25 [bank_url] => www.forabank.ru [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба [bankiru_id] => 80493 [bankiru_url] => [bank_export_url] => [license_revoked] => 0 [bank_export_exchange_rates_url] => [bank_id] => 80493 [region_id] => 9 [cur_id] => 304 [cur_name] => EUR [cur_b] => 88.30 [cur_b_old] => 88.30 [cur_s] => 90.50 [cur_s_old] => 90.50 [cur_dt] => 1686281760 [dt] => 1686281865 [abli_bank_id] => 109 ) [18] => Array ( [id] => 49965 [yid] => 110346 [license] => 1885 [name] => Фора-Банк [shortname] => [vbanke] => [banka] => [post_id] => 3783 [address] => 119021, г. Москва, Зубовский б-р, д. 25 [bank_url] => www.forabank.ru [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба [bankiru_id] => 80493 [bankiru_url] => [bank_export_url] => [license_revoked] => 0 [bank_export_exchange_rates_url] => [bank_id] => 80493 [region_id] => 9 [cur_id] => 382 [cur_name] => GBP [cur_b] => 101.00 [cur_b_old] => 101.00 [cur_s] => 104.50 [cur_s_old] => 104.50 [cur_dt] => 1686281340 [dt] => 1686281865 [abli_bank_id] => 109 ) [19] => Array ( [id] => 49965 [yid] => 110346 [license] => 1885 [name] => Фора-Банк [shortname] => [vbanke] => [banka] => [post_id] => 3783 [address] => 119021, г. Москва, Зубовский б-р, д. 25 [bank_url] => www.forabank.ru [phone] => (495) 775-65-55, 8 800 100-98-89, — единая справочная служба [bankiru_id] => 80493 [bankiru_url] => [bank_export_url] => [license_revoked] => 0 [bank_export_exchange_rates_url] => [bank_id] => 80493 [region_id] => 9 [cur_id] => 383 [cur_name] => CHF [cur_b] => 57.00 [cur_b_old] => 57.00 [cur_s] => 89.50 [cur_s_old] => 89.50 [cur_dt] => 1686281340 [dt] => 1686281865 [abli_bank_id] => 109 ) )
Лучшие курсы обмена наличной валюты в Коломне на сегодня.
Название / Обновлено 09.06.2023 в |
USD | EUR | ||
---|---|---|---|---|
Покупка | Продажа | Покупка | Продажа | |
Россельхозбанк
06:36:25
|
77.75 | 84.45 | 84.65 | 90.85 |
Банк Открытие
06:36:14
|
80.10 | 83.75 | 88.00 | 94.00 |
Промсвязьбанк
06:36:26
|
80.54 | 83.69 | 87.12 | 90.72 |
Русский Стандарт
06:36:12
|
0.00 | 0.00 | 0.00 | 0.00 |
Совкомбанк | 80.70 | 87.70 | 87.10 | 94.10 |
Фора-Банк
06:37:45
|
80.60 | 83.50 | 88.30 | 90.50 |
Чтобы выгодно поменять доллары, евро на рубли или совершить обратную операцию, воспользуйтесь нашей таблицей. Самые выгодные курсы валют в банках Коломны выделены зеленым цветом.