Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find
Search results for: "[All restaurants]" Near "BTS-Chit Lom"
[-] Search Filters
Near
  • BTS-Chit Lom
Include nearby stations
Restaurant Cuisines/Types
Cuisines types
more...
Restaurant types
more...
Restaurant features
more...
Price range
more...
 
No results found for your search.
Add new restaurant you know.
Don't find it?
Add new restaurant you know.
Loading map...
 
(default) 22 queries took 202 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `members`464644
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `cuisine_types`101012
4SHOW FULL COLUMNS FROM `countries`9920
5SHOW FULL COLUMNS FROM `rests_comments`272725
6SHOW FULL COLUMNS FROM `nonmembers`3320
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
8SHOW FULL COLUMNS FROM `rests_pics`222221
9SHOW FULL COLUMNS FROM `rest_pic_types`6628
10SHOW FULL COLUMNS FROM `rest_chains`353512
11SHOW FULL COLUMNS FROM `price_ranges`7710
12SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
13SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE ((`Bts`.`nameEn` LIKE '%ชิดลม%') OR (`Bts`.`nameTh` LIKE '%ชิดลม%')) LIMIT 1111
14SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToBts1`.`id`, `NearbyToBts1`.`isBtsOrMrt`, `NearbyToBts1`.`line`, `NearbyToBts1`.`station_no`, `NearbyToBts1`.`station_code`, `NearbyToBts1`.`nameTh`, `NearbyToBts1`.`nameEn`, `NearbyToBts1`.`addr`, `NearbyToBts1`.`lat`, `NearbyToBts1`.`lng`, `NearbyToBts1`.`num_rests`, `NearbyToBts1`.`num_blds`, `NearbyToBts1`.`exit1_lat`, `NearbyToBts1`.`exit1_long`, `NearbyToBts1`.`exit2_lat`, `NearbyToBts1`.`exit2_long`, `NearbyToBts1`.`exit3_lat`, `NearbyToBts1`.`exit3_long`, `NearbyToBts1`.`exit4_lat`, `NearbyToBts1`.`exit4_long`, `NearbyToBts1`.`exit5_lat`, `NearbyToBts1`.`exit5_long`, `NearbyToBts1`.`exit6_lat`, `NearbyToBts1`.`exit6_long`, `NearbyToBts1`.`created`, `NearbyToBts1`.`modified`, `NearbyToBts1`.`nearby_bts1_id`, `NearbyToBts1`.`nearby_bts2_id`, `NearbyToBts1`.`nearby_bts3_id`, `NearbyToBts1`.`nearby_mrt1_id`, `NearbyToBts1`.`nearby_mrt2_id`, `NearbyToBts1`.`nearby_mrt3_id`, `NearbyToBts1`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts1`.`nameTh`)) AS `NearbyToBts1__full_nameTh`, (CONCAT("BTS-", `NearbyToBts1`.`nameEn`)) AS `NearbyToBts1__full_nameEn`, `NearbyToBts2`.`id`, `NearbyToBts2`.`isBtsOrMrt`, `NearbyToBts2`.`line`, `NearbyToBts2`.`station_no`, `NearbyToBts2`.`station_code`, `NearbyToBts2`.`nameTh`, `NearbyToBts2`.`nameEn`, `NearbyToBts2`.`addr`, `NearbyToBts2`.`lat`, `NearbyToBts2`.`lng`, `NearbyToBts2`.`num_rests`, `NearbyToBts2`.`num_blds`, `NearbyToBts2`.`exit1_lat`, `NearbyToBts2`.`exit1_long`, `NearbyToBts2`.`exit2_lat`, `NearbyToBts2`.`exit2_long`, `NearbyToBts2`.`exit3_lat`, `NearbyToBts2`.`exit3_long`, `NearbyToBts2`.`exit4_lat`, `NearbyToBts2`.`exit4_long`, `NearbyToBts2`.`exit5_lat`, `NearbyToBts2`.`exit5_long`, `NearbyToBts2`.`exit6_lat`, `NearbyToBts2`.`exit6_long`, `NearbyToBts2`.`created`, `NearbyToBts2`.`modified`, `NearbyToBts2`.`nearby_bts1_id`, `NearbyToBts2`.`nearby_bts2_id`, `NearbyToBts2`.`nearby_bts3_id`, `NearbyToBts2`.`nearby_mrt1_id`, `NearbyToBts2`.`nearby_mrt2_id`, `NearbyToBts2`.`nearby_mrt3_id`, `NearbyToBts2`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts2`.`nameTh`)) AS `NearbyToBts2__full_nameTh`, (CONCAT("BTS-", `NearbyToBts2`.`nameEn`)) AS `NearbyToBts2__full_nameEn`, `NearbyToBts3`.`id`, `NearbyToBts3`.`isBtsOrMrt`, `NearbyToBts3`.`line`, `NearbyToBts3`.`station_no`, `NearbyToBts3`.`station_code`, `NearbyToBts3`.`nameTh`, `NearbyToBts3`.`nameEn`, `NearbyToBts3`.`addr`, `NearbyToBts3`.`lat`, `NearbyToBts3`.`lng`, `NearbyToBts3`.`num_rests`, `NearbyToBts3`.`num_blds`, `NearbyToBts3`.`exit1_lat`, `NearbyToBts3`.`exit1_long`, `NearbyToBts3`.`exit2_lat`, `NearbyToBts3`.`exit2_long`, `NearbyToBts3`.`exit3_lat`, `NearbyToBts3`.`exit3_long`, `NearbyToBts3`.`exit4_lat`, `NearbyToBts3`.`exit4_long`, `NearbyToBts3`.`exit5_lat`, `NearbyToBts3`.`exit5_long`, `NearbyToBts3`.`exit6_lat`, `NearbyToBts3`.`exit6_long`, `NearbyToBts3`.`created`, `NearbyToBts3`.`modified`, `NearbyToBts3`.`nearby_bts1_id`, `NearbyToBts3`.`nearby_bts2_id`, `NearbyToBts3`.`nearby_bts3_id`, `NearbyToBts3`.`nearby_mrt1_id`, `NearbyToBts3`.`nearby_mrt2_id`, `NearbyToBts3`.`nearby_mrt3_id`, `NearbyToBts3`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts3`.`nameTh`)) AS `NearbyToBts3__full_nameTh`, (CONCAT("BTS-", `NearbyToBts3`.`nameEn`)) AS `NearbyToBts3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `btses` AS `NearbyToBts1` ON (`Bts`.`nearby_bts1_id` = `NearbyToBts1`.`id`) LEFT JOIN `btses` AS `NearbyToBts2` ON (`Bts`.`nearby_bts2_id` = `NearbyToBts2`.`id`) LEFT JOIN `btses` AS `NearbyToBts3` ON (`Bts`.`nearby_bts3_id` = `NearbyToBts3`.`id`) WHERE `Bts`.`id` = 9 LIMIT 1113
15SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToMrt1`.`id`, `NearbyToMrt1`.`line`, `NearbyToMrt1`.`station_no`, `NearbyToMrt1`.`station_code`, `NearbyToMrt1`.`nameTh`, `NearbyToMrt1`.`nameEn`, `NearbyToMrt1`.`addr`, `NearbyToMrt1`.`lat`, `NearbyToMrt1`.`lng`, `NearbyToMrt1`.`num_rests`, `NearbyToMrt1`.`num_blds`, `NearbyToMrt1`.`exit1_lat`, `NearbyToMrt1`.`exit1_long`, `NearbyToMrt1`.`exit2_lat`, `NearbyToMrt1`.`exit2_long`, `NearbyToMrt1`.`exit3_lat`, `NearbyToMrt1`.`exit3_long`, `NearbyToMrt1`.`exit4_lat`, `NearbyToMrt1`.`exit4_long`, `NearbyToMrt1`.`exit5_lat`, `NearbyToMrt1`.`exit5_long`, `NearbyToMrt1`.`exit6_lat`, `NearbyToMrt1`.`exit6_long`, `NearbyToMrt1`.`created`, `NearbyToMrt1`.`modified`, `NearbyToMrt1`.`nearby_bts1_id`, `NearbyToMrt1`.`nearby_bts2_id`, `NearbyToMrt1`.`nearby_bts3_id`, `NearbyToMrt1`.`nearby_mrt1_id`, `NearbyToMrt1`.`nearby_mrt2_id`, `NearbyToMrt1`.`nearby_mrt3_id`, `NearbyToMrt1`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt1`.`nameTh`)) AS `NearbyToMrt1__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt1`.`nameEn`)) AS `NearbyToMrt1__full_nameEn`, `NearbyToMrt2`.`id`, `NearbyToMrt2`.`line`, `NearbyToMrt2`.`station_no`, `NearbyToMrt2`.`station_code`, `NearbyToMrt2`.`nameTh`, `NearbyToMrt2`.`nameEn`, `NearbyToMrt2`.`addr`, `NearbyToMrt2`.`lat`, `NearbyToMrt2`.`lng`, `NearbyToMrt2`.`num_rests`, `NearbyToMrt2`.`num_blds`, `NearbyToMrt2`.`exit1_lat`, `NearbyToMrt2`.`exit1_long`, `NearbyToMrt2`.`exit2_lat`, `NearbyToMrt2`.`exit2_long`, `NearbyToMrt2`.`exit3_lat`, `NearbyToMrt2`.`exit3_long`, `NearbyToMrt2`.`exit4_lat`, `NearbyToMrt2`.`exit4_long`, `NearbyToMrt2`.`exit5_lat`, `NearbyToMrt2`.`exit5_long`, `NearbyToMrt2`.`exit6_lat`, `NearbyToMrt2`.`exit6_long`, `NearbyToMrt2`.`created`, `NearbyToMrt2`.`modified`, `NearbyToMrt2`.`nearby_bts1_id`, `NearbyToMrt2`.`nearby_bts2_id`, `NearbyToMrt2`.`nearby_bts3_id`, `NearbyToMrt2`.`nearby_mrt1_id`, `NearbyToMrt2`.`nearby_mrt2_id`, `NearbyToMrt2`.`nearby_mrt3_id`, `NearbyToMrt2`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt2`.`nameTh`)) AS `NearbyToMrt2__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt2`.`nameEn`)) AS `NearbyToMrt2__full_nameEn`, `NearbyToMrt3`.`id`, `NearbyToMrt3`.`line`, `NearbyToMrt3`.`station_no`, `NearbyToMrt3`.`station_code`, `NearbyToMrt3`.`nameTh`, `NearbyToMrt3`.`nameEn`, `NearbyToMrt3`.`addr`, `NearbyToMrt3`.`lat`, `NearbyToMrt3`.`lng`, `NearbyToMrt3`.`num_rests`, `NearbyToMrt3`.`num_blds`, `NearbyToMrt3`.`exit1_lat`, `NearbyToMrt3`.`exit1_long`, `NearbyToMrt3`.`exit2_lat`, `NearbyToMrt3`.`exit2_long`, `NearbyToMrt3`.`exit3_lat`, `NearbyToMrt3`.`exit3_long`, `NearbyToMrt3`.`exit4_lat`, `NearbyToMrt3`.`exit4_long`, `NearbyToMrt3`.`exit5_lat`, `NearbyToMrt3`.`exit5_long`, `NearbyToMrt3`.`exit6_lat`, `NearbyToMrt3`.`exit6_long`, `NearbyToMrt3`.`created`, `NearbyToMrt3`.`modified`, `NearbyToMrt3`.`nearby_bts1_id`, `NearbyToMrt3`.`nearby_bts2_id`, `NearbyToMrt3`.`nearby_bts3_id`, `NearbyToMrt3`.`nearby_mrt1_id`, `NearbyToMrt3`.`nearby_mrt2_id`, `NearbyToMrt3`.`nearby_mrt3_id`, `NearbyToMrt3`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt3`.`nameTh`)) AS `NearbyToMrt3__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt3`.`nameEn`)) AS `NearbyToMrt3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `mrts` AS `NearbyToMrt1` ON (`Bts`.`nearby_mrt1_id` = `NearbyToMrt1`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt2` ON (`Bts`.`nearby_mrt2_id` = `NearbyToMrt2`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt3` ON (`Bts`.`nearby_mrt3_id` = `NearbyToMrt3`.`id`) WHERE `Bts`.`id` = 9 LIMIT 1113
16SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`show_in_filter` = 1 ORDER BY `CuisineType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`CuisineType`.`nameTh` USING tis620) ASC 74740
17SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`popular_ranking` > 0 ORDER BY `CuisineType`.`popular_ranking` ASC LIMIT 6660
18SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`popular_ranking` > 0 ORDER BY `RestType`.`popular_ranking` ASC LIMIT 6551
19SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`show_in_filter` = 1 ORDER BY `RestType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestType`.`nameTh` USING tis620) ASC 20200
20SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`popular_ranking` > 0 ORDER BY `RestFeature`.`popular_ranking` ASC LIMIT 6330
21SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`show_in_filter` = 1 ORDER BY `RestFeature`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestFeature`.`nameTh` USING tis620) ASC 27270
22SELECT `PriceRange`.`id`, `PriceRange`.`nameTh`, `PriceRange`.`nameEn`, `PriceRange`.`from`, `PriceRange`.`to`, `PriceRange`.`created`, `PriceRange`.`modified` FROM `price_ranges` AS `PriceRange` WHERE 1 = 1 ORDER BY `PriceRange`.`id` ASC 990
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 ...