Warning (512): SQL Error: 1305: PROCEDURE kinnshar_kinnsharedev.geodist_nearbyBlds does not exist [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query: call geodist_nearbyBlds( 13.730300, 100.530998, 1500, 1437, 3)
KinnShare: Hotel Rose Hotel Bangkok - ร้านอาหารทั้งหมด รูป แผนที่และการเดินทาง
This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find

Hotel Rose Hotel Bangkok

โรงแรมโรส โฮเทล กรุงเทพ

No. of restaurants: 2
[Incorrect info?]
02-266-8268-72
118, Suriwong Rd, Si Phraya, Bang Rak
Bangkok
Website: 
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
http://www.rosehotelbkk.com
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions

MRT-Sam Yan
118, Suriwong Rd, Si Phraya, Bang Rak
Bangkok
Find direction to here
X
By:

or pick up and drop him where you want to find direction.
Did you mean...?
(Directions by Google Maps)
Back to top
Restaurants in Hotel Rose Hotel Bangkok (2)
Search in this bldg:
Loading restaurants...
No restaurant info
Add a new restaurant here
Loading restaurants...
Back to top
Building near Hotel Rose Hotel Bangkok (1)
Banner 160x600
(default) 16 queries took 82 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rests_histories`545421
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `articles`141418
4SHOW FULL COLUMNS FROM `articles_pics`6613
5SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
6SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`lat`, `Bts`.`lng`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`lat`, `Mrt`.`lng`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `BldType`.`nameTh`, `BldType`.`nameEn`, `ThProvince`.`nameTh`, `ThProvince`.`nameEn`, `Country`.`name`, `Country`.`nameEn`, `PrimaryPic`.`id`, `PrimaryPic`.`file_name_s`, `PrimaryPic`.`file_name_thumb_s`, `PrimaryPic`.`caption`, `PrimaryPic`.`num_likes`, `PrimaryPic`.`member_id` FROM `blds` AS `Bld` LEFT JOIN `btses` AS `Bts` ON (`Bld`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Bld`.`mrt_id` = `Mrt`.`id`) LEFT JOIN `bld_types` AS `BldType` ON (`Bld`.`bld_type_id` = `BldType`.`id`) LEFT JOIN `th_provinces` AS `ThProvince` ON (`Bld`.`th_province_id` = `ThProvince`.`id`) LEFT JOIN `countries` AS `Country` ON (`Bld`.`country_id` = `Country`.`id`) LEFT JOIN `blds_pics` AS `PrimaryPic` ON (`Bld`.`primary_blds_pic_id` = `PrimaryPic`.`id` AND `PrimaryPic`.`active` = 1) WHERE `Bld`.`id` = 1437 AND `Bld`.`active` = 1 LIMIT 1114
7SELECT `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`lat`, `Mrt`.`lng`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 17 110
8SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 3 110
9SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 110
10SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 110
11SELECT `BldsPic`.`id`, `BldsPic`.`file_name_l`, `BldsPic`.`file_name_m`, `BldsPic`.`file_name_s`, `BldsPic`.`file_name_thumb_s`, `BldsPic`.`caption`, `BldsPic`.`num_likes`, `BldsPic`.`member_id`, `BldsPic`.`bld_id` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = (1437) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5002
12SELECT `BldsHour`.`day_from`, `BldsHour`.`day_to`, `BldsHour`.`hour_open`, `BldsHour`.`hour_close`, `BldsHour`.`description`, `BldsHour`.`bld_id` FROM `blds_hours` AS `BldsHour` WHERE `BldsHour`.`bld_id` = (1437) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC 002
13SELECT `RestsPic`.`id`, `RestsPic`.`num_likes`, `RestsPic`.`caption`, `RestsPic`.`file_name_thumb_s`, `RestsPic`.`file_name_s`, `Rest`.`id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`seo_url`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username` FROM `rests_pics` AS `RestsPic` INNER JOIN rests AS `Rest` ON (`Rest`.`id` = `RestsPic`.`rest_id`) LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`bld_id` = 1437 ORDER BY `RestsPic`.`id` DESC LIMIT 50012
14SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1437 AND `BldsPic`.`active` = 1 111
15 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1437' ) 117
16call geodist_nearbyBlds( 13.730300, 100.530998, 1500, 1437, 3)1305: PROCEDURE kinnshar_kinnsharedev.geodist_nearbyBlds does not exist0
Submit feedback to KinnShare
If you would like to submit feedback to us, report any bugs or problems using KinnShare website, or found any incorrect info. You can use the form below to contact us :-).
submitting ...