Guide to restaurants by KinnShare team and KinnShare members
Showing 1-3 from 3 total
« Prev Next »
Posted on: 3 Aug 2012 at 18:58
Hello everyone. Welcome back to Share Shuan Shim, a guide to restaurants in Bangkok on BTS/MRT lines.
Today I'm going to introduce you to a new shopping mall that just opened last month, named Gateway Ekamai (เกตเวย์ เอกมัย). This mall just had a grand openning on ... read more »
x7889
x0
Posted on: 29 Jul 2012 at 03:36
From the previous article (Let's take a walk at The Promenade mall), we took a quick look at the overall atmosphere at The Promenade Mall. Today KinnShare is going to give you another quick tour of the restaurants here.
What so cute about the restaurants here is th... read more »
x4953
x0
Posted on: 5 Jul 2012 at 17:39
Hello, สวัสดีครับ
Did you know there's a very cool shopping mall just opened in the subarb of Bangkok (Next to Fashion Island Mall) called The Promenade or เดอะ พรอมานาด ?
This is a brand new mall which is also run by Fashion Island Mall and&nbs... read more »
x3260
x2
Showing 1-3 from 3 total
« Prev Next »
Ad 300x250
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `th_provinces` | 9 | 9 | 21 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 3 | |
3 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
4 | SELECT COUNT(*) AS `count` FROM `articles` AS `Article` LEFT JOIN `articles_pics` AS `ArticlesPic` ON (`Article`.`articles_pic_id` = `ArticlesPic`.`id`) WHERE `Article`.`active` = 1 | 1 | 1 | 26 | |
5 | SELECT `Article`.`id`, `Article`.`nameTh`, `Article`.`nameEn`, `Article`.`seo_urlTh`, `Article`.`seo_urlEn`, `Article`.`tags`, `Article`.`contentTh`, `Article`.`contentEn`, `Article`.`num_comments`, `Article`.`num_views`, `Article`.`articles_pic_id`, `Article`.`created`, `Article`.`modified`, `Article`.`active`, `ArticlesPic`.`id`, `ArticlesPic`.`file_name`, `ArticlesPic`.`file_name_thumb`, `ArticlesPic`.`active`, `ArticlesPic`.`created`, `ArticlesPic`.`modified` FROM `articles` AS `Article` LEFT JOIN `articles_pics` AS `ArticlesPic` ON (`Article`.`articles_pic_id` = `ArticlesPic`.`id`) WHERE `Article`.`active` = 1 ORDER BY `Article`.`id` DESC LIMIT 30 | 3 | 3 | 2 | |
6 | 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`, `ArticlesBld`.`id`, `ArticlesBld`.`article_id`, `ArticlesBld`.`bld_id`, `ArticlesBld`.`created`, `ArticlesBld`.`modified` FROM `blds` AS `Bld` JOIN `articles_blds` AS `ArticlesBld` ON (`ArticlesBld`.`article_id` IN (3, 2, 1) AND `ArticlesBld`.`bld_id` = `Bld`.`id`) | 3 | 3 | 2 | |
7 | SELECT `Rest`.`id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`branch_nameEn`, `Rest`.`tags`, `Rest`.`descriptionTh`, `Rest`.`descriptionEn`, `Rest`.`seo_url`, `Rest`.`full_text`, `Rest`.`st_addrTh`, `Rest`.`st_addrEn`, `Rest`.`directionTh`, `Rest`.`directionEn`, `Rest`.`th_province_id`, `Rest`.`country_id`, `Rest`.`lat`, `Rest`.`lng`, `Rest`.`bts_id`, `Rest`.`bts_minutes`, `Rest`.`mrt_id`, `Rest`.`mrt_minutes`, `Rest`.`tel`, `Rest`.`official_website`, `Rest`.`official_menu`, `Rest`.`facebook`, `Rest`.`hours`, `Rest`.`price_range_id`, `Rest`.`rest_chain_id`, `Rest`.`bld_id`, `Rest`.`bld_floor`, `Rest`.`bld_zone`, `Rest`.`in_bld_addrTh_orig`, `Rest`.`in_bld_addrTh`, `Rest`.`in_bld_addrEn`, `Rest`.`cur_overall_rating`, `Rest`.`num_overall_rating`, `Rest`.`cur_taste_rating`, `Rest`.`num_taste_rating`, `Rest`.`cur_atmosphere_rating`, `Rest`.`num_atmosphere_rating`, `Rest`.`cur_price_rating`, `Rest`.`num_price_rating`, `Rest`.`cur_service_rating`, `Rest`.`num_service_rating`, `Rest`.`bayesian_rating`, `Rest`.`is_our_member`, `Rest`.`from_owner`, `Rest`.`num_comments`, `Rest`.`num_kratoos`, `Rest`.`num_pics`, `Rest`.`num_external_reviews`, `Rest`.`active`, `Rest`.`moved_to_rest_id`, `Rest`.`added_by_member_id`, `Rest`.`created`, `Rest`.`modified`, `Rest`.`primary_rests_pic_id`, `Rest`.`primary_pic_by_admin`, `Rest`.`primary_rests_pic_thumb_m`, `Rest`.`admin_validated`, `Rest`.`cuisine_type_ids`, `Rest`.`rest_type_ids`, `Rest`.`rest_feature_ids`, `Rest`.`logo`, `Rest`.`logo_s`, `Rest`.`logo_thumb`, `Rest`.`logo_thumb_s`, (CONCAT(`Rest`.`nameTh`, " (", `Rest`.`nameEn`, ")")) AS `Rest__nameThEn`, `ArticlesRest`.`id`, `ArticlesRest`.`article_id`, `ArticlesRest`.`rest_id`, `ArticlesRest`.`created`, `ArticlesRest`.`modified` FROM `rests` AS `Rest` JOIN `articles_rests` AS `ArticlesRest` ON (`ArticlesRest`.`article_id` IN (3, 2, 1) AND `ArticlesRest`.`rest_id` = `Rest`.`id`) | 0 | 0 | 1 |