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.726900, 100.533997, 1500, 1423, 3)

KinnShare: Hotel The Swiss Lodge - ร้านอาหารทั้งหมด รูป แผนที่และการเดินทาง
This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find

Hotel The Swiss Lodge

โรงแรมเดอะ สวิส ลอด์จ

No. of restaurants: 1
3, Convent Rd, Si Lom, Bang Rak
Bangkok
Website:
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
http://www.swisslodge.com
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions

BTS-Sala Daeng
MRT-Si Lom
3, Convent Rd, Si Lom, 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)
Restaurants in Hotel The Swiss Lodge (1)
Search in this bldg:
Loading restaurants...
No restaurant info
Add a new restaurant here
Loading restaurants...
Building near Hotel The Swiss Lodge (1)
(default) 38 queries took 272 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `mrts`323216
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `members`464611
4SHOW FULL COLUMNS FROM `cuisine_types`10109
5SHOW FULL COLUMNS FROM `th_provinces`999
6SHOW FULL COLUMNS FROM `countries`9911
7SHOW FULL COLUMNS FROM `rests_comments`272710
8SHOW FULL COLUMNS FROM `nonmembers`3318
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
10SHOW FULL COLUMNS FROM `rests_pics`222210
11SHOW FULL COLUMNS FROM `rest_pic_types`6619
12SHOW FULL COLUMNS FROM `admin_tmp_pics`121211
13SHOW FULL COLUMNS FROM `blds_pics`191924
14SHOW FULL COLUMNS FROM `bld_types`5516
15SHOW FULL COLUMNS FROM `blds_pics_likes`559
16SHOW FULL COLUMNS FROM `visits`779
17SHOW FULL COLUMNS FROM `unique_visitors`559
18SHOW FULL COLUMNS FROM `searches`101013
19SHOW FULL COLUMNS FROM `rests_comments_likes`5510
20SHOW FULL COLUMNS FROM `rests_pics_likes`559
21SHOW FULL COLUMNS FROM `external_reviews_likes`5512
22SHOW FULL COLUMNS FROM `external_reviews`23239
23SHOW FULL COLUMNS FROM `rests_rest_types`339
24SHOW FULL COLUMNS FROM `rest_types`10109
25SHOW FULL COLUMNS FROM `rest_chains_rest_features`339
26SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
27SELECT `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` = 1423 AND `Bld`.`active` = 1 LIMIT 1110
28SELECT `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` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 21 110
29SELECT `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` = 16 110
30SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 3 110
31SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 110
32SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 110
33SELECT `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` = (1423) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5000
34SELECT `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` = (1423) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC 000
35SELECT `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` = 1423 ORDER BY `RestsPic`.`id` DESC LIMIT 5000
36SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1423 AND `BldsPic`.`active` = 1 110
37 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1423' ) 110
38call geodist_nearbyBlds( 13.726900, 100.533997, 1500, 1423, 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 ...