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` > '1674833979')
error =
result = Array ( [0] => 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] => 70.40 [cur_b_old] => 70.40 [cur_s] => 73.95 [cur_s_old] => 73.95 [cur_dt] => 1674919980 [dt] => 1674920173 [abli_bank_id] => 8 ) [1] => 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] => 75.30 [cur_b_old] => 75.30 [cur_s] => 78.40 [cur_s_old] => 78.40 [cur_dt] => 1674919980 [dt] => 1674920173 [abli_bank_id] => 8 ) [2] => 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] => 67.50 [cur_b_old] => 67.50 [cur_s] => 72.50 [cur_s_old] => 72.50 [cur_dt] => 1674919680 [dt] => 1674920183 [abli_bank_id] => 11 ) [3] => 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] => 72.47 [cur_b_old] => 72.47 [cur_s] => 77.97 [cur_s_old] => 77.97 [cur_dt] => 1674920100 [dt] => 1674920183 [abli_bank_id] => 11 ) [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] => 569 [cur_name] => CNY [cur_b] => 9.25 [cur_b_old] => 9.25 [cur_s] => 12.35 [cur_s_old] => 12.35 [cur_dt] => 1674848580 [dt] => 1674920183 [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] => 570 [cur_name] => CHF [cur_b] => 70.36 [cur_b_old] => 70.36 [cur_s] => 85.36 [cur_s_old] => 85.36 [cur_dt] => 1674920100 [dt] => 1674920183 [abli_bank_id] => 11 ) [6] => 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] => 1674920100 [dt] => 1674920171 [abli_bank_id] => 17 ) [7] => 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] => 1674919980 [dt] => 1674920171 [abli_bank_id] => 17 ) [8] => 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] => 67.40 [cur_b_old] => 67.40 [cur_s] => 76.40 [cur_s_old] => 76.40 [cur_dt] => 1674919740 [dt] => 1674920251 [abli_bank_id] => 43 ) [9] => 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] => 73.40 [cur_b_old] => 73.40 [cur_s] => 82.40 [cur_s_old] => 82.40 [cur_dt] => 1674919740 [dt] => 1674920251 [abli_bank_id] => 43 ) [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] => 566 [cur_name] => CNY [cur_b] => 9.50 [cur_b_old] => 9.50 [cur_s] => 12.00 [cur_s_old] => 12.00 [cur_dt] => 1674919740 [dt] => 1674920251 [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] => 567 [cur_name] => GBP [cur_b] => 79.00 [cur_b_old] => 79.00 [cur_s] => 93.00 [cur_s_old] => 93.00 [cur_dt] => 1674919740 [dt] => 1674920251 [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] => 568 [cur_name] => CHF [cur_b] => 68.20 [cur_b_old] => 68.20 [cur_s] => 82.20 [cur_s_old] => 82.20 [cur_dt] => 1674919740 [dt] => 1674920251 [abli_bank_id] => 43 ) [13] => Array ( [id] => 45286 [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] => 9 [cur_id] => 373 [cur_name] => USD [cur_b] => 67.00 [cur_b_old] => 67.00 [cur_s] => 0.00 [cur_s_old] => 0.00 [cur_dt] => 1674874500 [dt] => 1674920193 [abli_bank_id] => 42 ) [14] => Array ( [id] => 45286 [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] => 9 [cur_id] => 374 [cur_name] => EUR [cur_b] => 73.00 [cur_b_old] => 73.00 [cur_s] => 0.00 [cur_s_old] => 0.00 [cur_dt] => 1674874500 [dt] => 1674920193 [abli_bank_id] => 42 ) [15] => 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] => 70.45 [cur_b_old] => 70.45 [cur_s] => 73.35 [cur_s_old] => 73.35 [cur_dt] => 1674849240 [dt] => 1674920264 [abli_bank_id] => 109 ) [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] => 304 [cur_name] => EUR [cur_b] => 76.00 [cur_b_old] => 76.00 [cur_s] => 78.70 [cur_s_old] => 78.70 [cur_dt] => 1674849240 [dt] => 1674920264 [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] => 382 [cur_name] => GBP [cur_b] => 84.00 [cur_b_old] => 84.00 [cur_s] => 88.50 [cur_s_old] => 88.50 [cur_dt] => 1674849180 [dt] => 1674920264 [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] => 383 [cur_name] => CHF [cur_b] => 72.00 [cur_b_old] => 72.00 [cur_s] => 78.40 [cur_s_old] => 78.40 [cur_dt] => 1674849180 [dt] => 1674920264 [abli_bank_id] => 109 ) )
Лучшие курсы обмена наличной валюты в Коломне на сегодня.
Название / Обновлено 28.01.2023 в | USD | EUR | ||
---|---|---|---|---|
Покупка | Продажа | Покупка | Продажа | |
Банк Открытие 18:36:13 | 70.40 | 73.95 | 75.30 | 78.40 |
Промсвязьбанк 18:36:23 | 67.50 | 72.50 | 72.47 | 77.97 |
Русский Стандарт 18:36:11 | 0.00 | 0.00 | 0.00 | 0.00 |
Совкомбанк | 67.40 | 76.40 | 73.40 | 82.40 |
Московский Индустриальный Банк 18:36:33 | 67.00 | 0.00 | 73.00 | 0.00 |
Фора-Банк 18:37:44 | 70.45 | 73.35 | 76.00 | 78.70 |
Чтобы выгодно поменять доллары, евро на рубли или совершить обратную операцию, воспользуйтесь нашей таблицей. Самые выгодные курсы валют в банках Коломны выделены зеленым цветом.