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.779846, 100.544998, 1500, 1971, 2)

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

Mall La Villa Phahonyothin

ห้างลา วิลล่า พหลโยธิน

No. of restaurants: 9
Thanon Phahon Yothin, Samsen Nai, Phaya Thai, Bangkok 10400, Thailand
Bangkok
Building hours:
Mon - Sun : 08:00 - 00:00
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions

BTS-Ari
Thanon Phahon Yothin, Samsen Nai, Phaya Thai, Bangkok 10400, Thailand
Bangkok
Next to BTS Ari
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 La Villa Phahonyothin (9)
Search in this bldg:
Loading restaurants...
No restaurant info
Add a new restaurant here
Loading restaurants...
Building near Mall La Villa Phahonyothin (1)
(default) 75 queries took 153 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`33333
4SHOW FULL COLUMNS FROM `mrts`32324
5SHOW FULL COLUMNS FROM `rests`68684
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`332
13SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
14SHOW FULL COLUMNS FROM `rests_pics`22223
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`772
22SHOW FULL COLUMNS FROM `unique_visitors`552
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`332
34SHOW FULL COLUMNS FROM `rests_rest_features`332
35SHOW FULL COLUMNS FROM `rest_features`10102
36SHOW FULL COLUMNS FROM `rest_chains_rest_features`332
37SHOW FULL COLUMNS FROM `rests_hours`992
38SHOW FULL COLUMNS FROM `rests_histories`54543
39SHOW FULL COLUMNS FROM `saved_rests`662
40SHOW FULL COLUMNS FROM `corrected_rests`52523
41SHOW FULL COLUMNS FROM `report_statuses`552
42SHOW FULL COLUMNS FROM `reported_comments`15152
43SHOW FULL COLUMNS FROM `reported_members`11112
44SHOW FULL COLUMNS FROM `corrected_blds`32323
45SHOW FULL COLUMNS FROM `corrected_rest_chains`21212
46SHOW FULL COLUMNS FROM `messages`12122
47SHOW FULL COLUMNS FROM `follows`552
48SHOW FULL COLUMNS FROM `website_deals`17173
49SHOW FULL COLUMNS FROM `deal_websites`552
50SHOW FULL COLUMNS FROM `articles`14142
51SHOW FULL COLUMNS FROM `articles_pics`662
52SHOW FULL COLUMNS FROM `articles_comments`882
53SHOW FULL COLUMNS FROM `articles_blds`552
54SHOW FULL COLUMNS FROM `articles_rests`552
55SHOW FULL COLUMNS FROM `blds_histories`33333
56SHOW FULL COLUMNS FROM `blds_hours`993
57SHOW FULL COLUMNS FROM `rests_comments_histories`24243
58SHOW FULL COLUMNS FROM `rests_comments_replies`993
59SHOW FULL COLUMNS FROM `rest_chains_histories`18183
60SHOW FULL COLUMNS FROM `settings`443
61SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
62SELECT `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` = 1971 AND `Bld`.`active` = 1 LIMIT 11110
63SELECT `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` = 3 110
64SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 110
65SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 110
66SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 110
67SELECT `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` = (1971) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5330
68SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 3 110
69SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
70SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 110
71SELECT `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` = (1971) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC 110
72SELECT `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` = 1971 ORDER BY `RestsPic`.`id` DESC LIMIT 3332
73SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1971 AND `BldsPic`.`active` = 1 112
74 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1971' ) 114
75call geodist_nearbyBlds( 13.779846, 100.544998, 1500, 1971, 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 ...