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.744300, 100.529999, 1500, 1, 2)

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

Mall MBK Center

ห้างมาบุญครอง

No. of restaurants: 64
444, Phayatai Rd, Wang Mai, Pathum Wan
Bangkok
Building hours:
Mon - Sun : 10:00 - 22:00
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions

BTS-National Stadium
444, Phayatai Rd, Wang Mai, Pathum Wan
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 MBK Center (64)
Search in this bldg:
Loading restaurants...
No restaurant info
Add a new restaurant here
Loading restaurants...
Building near Mall MBK Center (1)
(default) 64 queries took 98 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `blds`41413
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `btses`33332
4SHOW FULL COLUMNS FROM `mrts`32322
5SHOW FULL COLUMNS FROM `rests`68683
6SHOW FULL COLUMNS FROM `rest_chains`35353
7SHOW FULL COLUMNS FROM `members`46463
8SHOW FULL COLUMNS FROM `cuisine_types`10102
9SHOW FULL COLUMNS FROM `th_provinces`992
10SHOW FULL COLUMNS FROM `countries`992
11SHOW FULL COLUMNS FROM `rests_comments`27272
12SHOW FULL COLUMNS FROM `nonmembers`331
13SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
14SHOW FULL COLUMNS FROM `rests_pics`22222
15SHOW FULL COLUMNS FROM `rest_pic_types`662
16SHOW FULL COLUMNS FROM `admin_tmp_pics`12122
17SHOW FULL COLUMNS FROM `blds_pics`19192
18SHOW FULL COLUMNS FROM `bld_types`552
19SHOW FULL COLUMNS FROM `blds_pics_likes`552
20SHOW FULL COLUMNS FROM `reported_pics`16162
21SHOW FULL COLUMNS FROM `visits`771
22SHOW FULL COLUMNS FROM `unique_visitors`551
23SHOW FULL COLUMNS FROM `searches`10102
24SHOW FULL COLUMNS FROM `rests_comments_likes`552
25SHOW FULL COLUMNS FROM `rests_pics_likes`552
26SHOW FULL COLUMNS FROM `external_reviews_likes`552
27SHOW FULL COLUMNS FROM `external_reviews`23232
28SHOW FULL COLUMNS FROM `price_ranges`772
29SHOW FULL COLUMNS FROM `rests_cuisine_types`332
30SHOW FULL COLUMNS FROM `rest_chains_cuisine_types`332
31SHOW FULL COLUMNS FROM `rests_rest_types`332
32SHOW FULL COLUMNS FROM `rest_types`10102
33SHOW FULL COLUMNS FROM `rest_chains_rest_types`331
34SHOW FULL COLUMNS FROM `rests_rest_features`331
35SHOW FULL COLUMNS FROM `rest_features`10102
36SHOW FULL COLUMNS FROM `rest_chains_rest_features`331
37SHOW FULL COLUMNS FROM `follows`552
38SHOW FULL COLUMNS FROM `website_deals`17173
39SHOW FULL COLUMNS FROM `deal_websites`552
40SHOW FULL COLUMNS FROM `articles`14142
41SHOW FULL COLUMNS FROM `articles_pics`662
42SHOW FULL COLUMNS FROM `articles_comments`882
43SHOW FULL COLUMNS FROM `articles_blds`552
44SHOW FULL COLUMNS FROM `articles_rests`552
45SHOW FULL COLUMNS FROM `blds_histories`33333
46SHOW FULL COLUMNS FROM `blds_hours`992
47SHOW FULL COLUMNS FROM `rests_comments_histories`24242
48SHOW FULL COLUMNS FROM `rests_comments_replies`992
49SHOW FULL COLUMNS FROM `rest_chains_histories`18184
50SHOW FULL COLUMNS FROM `settings`442
51SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
52SELECT `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` = 1 AND `Bld`.`active` = 1 LIMIT 1110
53SELECT `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` = 18 110
54SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 110
55SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 110
56SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 110
57SELECT `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` = (1) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5220
58SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
59SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
60SELECT `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` = (1) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC 110
61SELECT `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` = 1 ORDER BY `RestsPic`.`id` DESC LIMIT 3330
62SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1 AND `BldsPic`.`active` = 1 110
63 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1' ) 110
64call geodist_nearbyBlds( 13.744300, 100.529999, 1500, 1, 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 ...