Home
Restaurants
All Comments
Share Shuan Shim
View all (50 pic(s)) >>Bldg United Center
ตึกยูไนเต็ด เซ็นเตอร์
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions
BTS-Sala Daeng
MRT-Si Lom
323, Silom Rd, Si Lom, Bang Rak
Bangkok
Bangkok
Find direction to here
X
By:
or pick up 
and drop him where you want to find direction.
and drop him where you want to find direction.
Did you mean...?
Restaurants in Bldg United Center (14)
Search in this bldg:
Loading restaurants...
Building near Bldg United Center (1)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `blds_pics_likes` | 5 | 5 | 21 | |
| 2 | SHOW FULL COLUMNS FROM `rests_pics_likes` | 5 | 5 | 19 | |
| 3 | SHOW FULL COLUMNS FROM `external_reviews_likes` | 5 | 5 | 18 | |
| 4 | SHOW FULL COLUMNS FROM `external_reviews` | 23 | 23 | 11 | |
| 5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | |
| 6 | SHOW FULL COLUMNS FROM `price_ranges` | 7 | 7 | 15 | |
| 7 | SHOW FULL COLUMNS FROM `rests_cuisine_types` | 3 | 3 | 10 | |
| 8 | SHOW FULL COLUMNS FROM `rest_chains_cuisine_types` | 3 | 3 | 11 | |
| 9 | SHOW FULL COLUMNS FROM `rest_chains_rest_types` | 3 | 3 | 11 | |
| 10 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
| 11 | SELECT `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` = 229 AND `Bld`.`active` = 1 LIMIT 1 | 1 | 1 | 3 | |
| 12 | SELECT `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 | 1 | 1 | 0 | |
| 13 | SELECT `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 | 1 | 1 | 0 | |
| 14 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 1 | 1 | 1 | 0 | |
| 15 | SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 | 1 | 1 | 0 | |
| 16 | SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 | 1 | 1 | 0 | |
| 17 | SELECT `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` = (229) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5 | 5 | 5 | 1 | |
| 18 | SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 | 1 | 1 | 0 | |
| 19 | SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 | 1 | 1 | 0 | |
| 20 | SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 | 1 | 1 | 0 | |
| 21 | SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 | 1 | 1 | 0 | |
| 22 | SELECT `Member`.`id`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`unique_code` FROM `members` AS `Member` WHERE `Member`.`id` = 1 | 1 | 1 | 0 | |
| 23 | SELECT `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` = (229) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC | 0 | 0 | 1 | |
| 24 | SELECT `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` = 229 ORDER BY `RestsPic`.`id` DESC LIMIT 3 | 3 | 3 | 3 | |
| 25 | SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 229 AND `BldsPic`.`active` = 1 | 1 | 1 | 0 | |
| 26 | SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '229' ) | 1 | 1 | 0 | |
| 27 | call geodist_nearbyBlds( 13.727205, 100.531334, 1500, 229, 1) | 1305: PROCEDURE kinnshar_kinnsharedev.geodist_nearbyBlds does not exist | 0 |
