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.826319, 100.676437, 1500, 2042, 2)

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

Mall The Promenade

ห้างเดอะ พรอมานาด

No. of restaurants: 26
587, 589 Thanon Ram Intra, Khanna Yao, Bangkok, 10230
Bangkok
Website:
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
http://www.promenade.in.th
Building hours:
Mon - Sun : 10:00 - 22:00
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions

587, 589 Thanon Ram Intra, Khanna Yao, Bangkok, 10230
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 Mall The Promenade (26)
Search in this bldg:
Loading restaurants...
No restaurant info
Add a new restaurant here
Loading restaurants...
Building near Mall The Promenade (1)
(default) 24 queries took 99 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `corrected_rest_chains`212124
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `messages`121215
4SHOW FULL COLUMNS FROM `follows`5511
5SHOW FULL COLUMNS FROM `website_deals`171711
6SHOW FULL COLUMNS FROM `deal_websites`5515
7SHOW FULL COLUMNS FROM `settings`4419
8SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';113
9SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
10SELECT `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` = 2042 AND `Bld`.`active` = 1 LIMIT 1111
11SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 110
12SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 110
13SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 110
14SELECT `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` = (2042) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5550
15SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
16SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
17SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
18SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
19SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
20SELECT `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` = (2042) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC 110
21SELECT `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` = 2042 ORDER BY `RestsPic`.`id` DESC LIMIT 3330
22SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 2042 AND `BldsPic`.`active` = 1 110
23 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '2042' ) 110
24call geodist_nearbyBlds( 13.826319, 100.676437, 1500, 2042, 2)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 ...