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 226 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `blds`41412
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`993
10SHOW FULL COLUMNS FROM `countries`993
11SHOW FULL COLUMNS FROM `rests_comments`27274
12SHOW FULL COLUMNS FROM `nonmembers`334
13SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
14SHOW FULL COLUMNS FROM `rests_pics`22224
15SHOW FULL COLUMNS FROM `rest_pic_types`664
16SHOW FULL COLUMNS FROM `admin_tmp_pics`12124
17SHOW FULL COLUMNS FROM `blds_pics`19194
18SHOW FULL COLUMNS FROM `bld_types`554
19SHOW FULL COLUMNS FROM `blds_pics_likes`554
20SHOW FULL COLUMNS FROM `reported_pics`16163
21SHOW FULL COLUMNS FROM `visits`773
22SHOW FULL COLUMNS FROM `unique_visitors`553
23SHOW FULL COLUMNS FROM `searches`10103
24SHOW FULL COLUMNS FROM `rests_comments_likes`553
25SHOW FULL COLUMNS FROM `rests_pics_likes`553
26SHOW FULL COLUMNS FROM `external_reviews_likes`553
27SHOW FULL COLUMNS FROM `external_reviews`23233
28SHOW FULL COLUMNS FROM `price_ranges`774
29SHOW FULL COLUMNS FROM `rests_cuisine_types`333
30SHOW FULL COLUMNS FROM `rest_chains_cuisine_types`332
31SHOW FULL COLUMNS FROM `rests_rest_types`332
32SHOW FULL COLUMNS FROM `rest_types`10101
33SHOW FULL COLUMNS FROM `rest_chains_rest_types`331
34SHOW FULL COLUMNS FROM `rests_rest_features`331
35SHOW FULL COLUMNS FROM `rest_features`10101
36SHOW FULL COLUMNS FROM `rest_chains_rest_features`331
37SHOW FULL COLUMNS FROM `rests_hours`991
38SHOW FULL COLUMNS FROM `rests_histories`54542
39SHOW FULL COLUMNS FROM `saved_rests`662
40SHOW FULL COLUMNS FROM `corrected_rests`52522
41SHOW FULL COLUMNS FROM `report_statuses`552
42SHOW FULL COLUMNS FROM `reported_comments`15152
43SHOW FULL COLUMNS FROM `reported_members`11114
44SHOW FULL COLUMNS FROM `corrected_blds`32325
45SHOW FULL COLUMNS FROM `corrected_rest_chains`21214
46SHOW FULL COLUMNS FROM `messages`12124
47SHOW FULL COLUMNS FROM `follows`554
48SHOW FULL COLUMNS FROM `website_deals`171710
49SHOW FULL COLUMNS FROM `deal_websites`552
50SHOW FULL COLUMNS FROM `articles`141459
51SHOW FULL COLUMNS FROM `articles_pics`667
52SHOW FULL COLUMNS FROM `articles_comments`885
53SHOW FULL COLUMNS FROM `articles_blds`551
54SHOW FULL COLUMNS FROM `articles_rests`552
55SHOW FULL COLUMNS FROM `blds_histories`33332
56SHOW FULL COLUMNS FROM `blds_hours`992
57SHOW FULL COLUMNS FROM `rests_comments_histories`24242
58SHOW FULL COLUMNS FROM `rests_comments_replies`992
59SHOW FULL COLUMNS FROM `rest_chains_histories`18182
60SHOW FULL COLUMNS FROM `settings`442
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 1111
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 3330
73SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1971 AND `BldsPic`.`active` = 1 110
74 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1971' ) 110
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 ...