KinnShare: Chain(s) The China Moon - ข้อมูลสาขาทั้งหมด รูป และแผนที่

This is the test environment server: dev.kinnshare.com

Banner 728x90

English

ภาษาไทย

Near where

Wanna Eat/Find

Home » Find restaurants » Chain The China Moon

Chain The China Moon

Chain เดอะไชน่า มูน

No. of branches: 2

Cuisine types:

Asian, Chinese, Cantonese

Ratings from all

Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]Code | Context        if(!isset($url['language']) && isset($this->params['language'])    ) 
        {
          $url['language'] = $this->params['language'];
$url	=	"#restaurants"
$full	=	false
AppHelper::url() - APP/app_helper.php, line 11
HtmlHelper::link() - CORE/cake/libs/view/helpers/html.php, line 284
include - APP/views/rest_chains/view.ctp, line 123
View::_render() - CORE/cake/libs/view/view.php, line 731
View::render() - CORE/cake/libs/view/view.php, line 426
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

2 branches

( 0ppl)

Taste

(0ppl)

Atmosphere

(0ppl)

Service

(0ppl)

Price

(0ppl)

View all branches(2)

View all pics(0)

Add a new branch

[Chain info incorrect?]

Website: www.miraclegrandhotel.com/restaurant....

Map and branches of chain The China Moon (2)

Loading restaurants...

This chain has no branch info yet.

Add a new brach of the chain The China Moon

Loading restaurants...

Chain we think you might be interested in (30)

1. ChainLee Cafe

Asian, Chinese, Cantonese

(7 branches)
2. ChainGrand Sanyod

Asian, Chinese, Cantonese

(2 branches)
3. ChainLiu Xiang Fong

Asian, Chinese, Cantonese

(1 branches)
4. ChainSeefah

Asian, Chinese, Thai

(11 branches)
5. ChainPeking Restaurants

Asian, Chinese, Beijing

(8 branches)
6. ChainCoca Restaurant

Asian, Chinese, Chinese hot pot

(7 branches)
7. ChainShanghai Xiaolong Pao

Asian, Chinese, Shanghai

(5 branches)
8. ChainMK Gold Restaurant

Asian, Chinese, Chinese hot pot

(5 branches)
9. ChainSukishi Buffet

Asian, Chinese, Chinese hot pot

(4 branches)
10. ChainHongmin

Asian, Chinese

(4 branches)
11. ChainCha Mudang

Asian, Chinese

(3 branches)
12. ChainCrystal Jade La Mian Xiao Long Bao

Asian, Chinese

(1 branches)
13. ChainYang Sheng Tang

Asian, Chinese

(2 branches)
14. ChainDalian Restaurant

Asian, Chinese

(2 branches)
15. ChainMaMa Do

Asian, Chinese, Chinese hot pot

(2 branches)
16. ChainScala Shark's Fin Restaurant

Asian, Chinese

(2 branches)
17. ChainShangarila Restaurant

Asian, Chinese

(2 branches)
18. ChainMK Restaurant

Asian, Chinese, Chinese hot pot

(6 branches)
19. ChainThe Canton House

Asian, Chinese, Dim sum

(1 branches)
20. ChainWaraporn Salapao

Asian, Chinese, Dim sum

(21 branches)
21. ChainTee U Tiao Long

Asian, Chinese, Dim sum, Noodle

(2 branches)
22. ChainRoyal Kitchen

Asian, Chinese

(2 branches)
23. ChainDin Tai Fung

Asian, Chinese, Dim sum

(2 branches)
24. ChainHua Seng Hong

Asian, Chinese

(2 branches)
25. ChainHong Kong Kitchen

Asian, Chinese

(2 branches)
26. ChainEvaime Shabu Shabu

Asian, Chinese, Japanese, Chinese hot pot, Shabu, Taiwanese

(3 branches)
27. ChainGustoso

European, Asian, Chinese, Japanese, Italian, International, Thai, Italian Pizza, Pasta

(2 branches)
28. ChainHot Pot Inter Buffet

Asian, Chinese, Thai, International, Japanese, Chinese hot pot

(2 branches)
29. ChainMali

Asian, Chinese

(1 branches)
30. ChainLieo Lieng Seng (Ice cream 555)

Asian, Snacks/Desserts, Chinese, Ice-creams

(2 branches)

Banner 160x600

Site map

About us

Help

KinnShare.com เป็น ภาษาไทย

(default) 50 queries took 105 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `members`	46	46	23
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
3	SHOW FULL COLUMNS FROM `external_reviews`	23	23	22
4	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	0
5	SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn`, `RelatedToChain1`.`id`, `RelatedToChain1`.`nameTh`, `RelatedToChain1`.`nameEn`, `RelatedToChain1`.`seo_url`, `RelatedToChain2`.`id`, `RelatedToChain2`.`nameTh`, `RelatedToChain2`.`nameEn`, `RelatedToChain2`.`seo_url`, `RelatedToChain3`.`id`, `RelatedToChain3`.`nameTh`, `RelatedToChain3`.`nameEn`, `RelatedToChain3`.`seo_url`, `PriceRange`.`nameTh`, `PriceRange`.`nameEn` FROM `rest_chains` AS `RestChain` LEFT JOIN `rest_chains` AS `RelatedToChain1` ON (`RestChain`.`related_chain1_id` = `RelatedToChain1`.`id` AND `RelatedToChain1`.`active` = 1) LEFT JOIN `rest_chains` AS `RelatedToChain2` ON (`RestChain`.`related_chain2_id` = `RelatedToChain2`.`id` AND `RelatedToChain2`.`active` = 1) LEFT JOIN `rest_chains` AS `RelatedToChain3` ON (`RestChain`.`related_chain3_id` = `RelatedToChain3`.`id` AND `RelatedToChain3`.`active` = 1) LEFT JOIN `price_ranges` AS `PriceRange` ON (`RestChain`.`price_range_id` = `PriceRange`.`id`) WHERE `RestChain`.`id` = 147 AND `RestChain`.`active` = 1 LIMIT 1	1	1	1
6	SELECT `CuisineType`.`id`, `CuisineType`.`nameTh`, `CuisineType`.`nameEn`, `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id` FROM `cuisine_types` AS `CuisineType` JOIN `rest_chains_cuisine_types` AS `RestChainsCuisineType` ON (`RestChainsCuisineType`.`rest_chain_id` = 147 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	3	3	2
7	SELECT `RestType`.`id`, `RestType`.`nameTh`, `RestType`.`nameEn`, `RestChainsRestType`.`id`, `RestChainsRestType`.`rest_chain_id`, `RestChainsRestType`.`rest_type_id` FROM `rest_types` AS `RestType` JOIN `rest_chains_rest_types` AS `RestChainsRestType` ON (`RestChainsRestType`.`rest_chain_id` = 147 AND `RestChainsRestType`.`rest_type_id` = `RestType`.`id`) ORDER BY `level` ASC	0	0	1
8	SELECT `RestFeature`.`id`, `RestFeature`.`nameTh`, `RestFeature`.`nameEn`, `RestChainsRestFeature`.`id`, `RestChainsRestFeature`.`rest_chain_id`, `RestChainsRestFeature`.`rest_feature_id` FROM `rest_features` AS `RestFeature` JOIN `rest_chains_rest_features` AS `RestChainsRestFeature` ON (`RestChainsRestFeature`.`rest_chain_id` = 147 AND `RestChainsRestFeature`.`rest_feature_id` = `RestFeature`.`id`) ORDER BY `level` ASC	0	0	2
9	SELECT `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	27	27	0
10	SELECT RestsPic.`id`, RestsPic.`file_name_l`, RestsPic.`file_name_s`, RestsPic.`file_name_thumb_s`, RestsPic.`caption`, RestsPic.`num_likes`, Member.`id`, Member.`username`, Member.`first_name`, Member.`last_name`, Member.`unique_code` FROM `rests_pics` AS RestsPic LEFT JOIN `members` AS Member ON Member.`id` = RestsPic.`member_id` WHERE RestsPic.`rest_id` IN ( SELECT Rest.`id` FROM `rests` AS Rest WHERE Rest.`rest_chain_id` = '147' ) AND RestsPic.`active` = '1' ORDER BY RestsPic.`num_likes` DESC, RestsPic.`id` DESC LIMIT 5	0	0	13
11	SELECT COUNT(*) AS `total_photo` FROM `rests_pics` AS RestsPic WHERE RestsPic.`rest_id` IN ( SELECT Rest.`id` FROM `rests` AS Rest WHERE Rest.`rest_chain_id` = '147' ) AND RestsPic.`active` = '1'	1	1	5
12	SELECT `WebsiteDeal`.`id`, `WebsiteDeal`.`subjectTh`, `WebsiteDeal`.`subjectEn`, `WebsiteDeal`.`descriptionTh`, `WebsiteDeal`.`descriptionEn`, `WebsiteDeal`.`url`, `WebsiteDeal`.`valid_from`, `WebsiteDeal`.`valid_to`, `WebsiteDeal`.`deal_website_id`, `WebsiteDeal`.`full_price`, `WebsiteDeal`.`deal_price`, `WebsiteDeal`.`promo_text`, `WebsiteDeal`.`rest_id`, `WebsiteDeal`.`rest_chain_id`, `WebsiteDeal`.`created`, `WebsiteDeal`.`modified`, `WebsiteDeal`.`active`, `DealWebsite`.`id`, `DealWebsite`.`nameTh`, `DealWebsite`.`nameEn`, `DealWebsite`.`logo`, `DealWebsite`.`url`, `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`, `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `website_deals` AS `WebsiteDeal` LEFT JOIN `deal_websites` AS `DealWebsite` ON (`WebsiteDeal`.`deal_website_id` = `DealWebsite`.`id`) LEFT JOIN `rests` AS `Rest` ON (`WebsiteDeal`.`rest_id` = `Rest`.`id`) LEFT JOIN `rest_chains` AS `RestChain` ON (`WebsiteDeal`.`rest_chain_id` = `RestChain`.`id`) WHERE `WebsiteDeal`.`rest_chain_id` = 147 AND `WebsiteDeal`.`active` = 1 AND `WebsiteDeal`.`valid_to` >= '2024-05-11'	0	0	2
13	SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` = 147 AND `RestChain`.`active` = 1 LIMIT 1	1	1	1
14	SELECT `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`, `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id` FROM `cuisine_types` AS `CuisineType` JOIN `rest_chains_cuisine_types` AS `RestChainsCuisineType` ON (`RestChainsCuisineType`.`rest_chain_id` = 147 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `CuisineType`.`level` DESC	3	3	2
15	SELECT `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id`, `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains_cuisine_types` AS `RestChainsCuisineType` LEFT JOIN `rest_chains` AS `RestChain` ON (`RestChainsCuisineType`.`rest_chain_id` = `RestChain`.`id` AND `RestChain`.`active` = 1) WHERE NOT (`RestChainsCuisineType`.`rest_chain_id` = ('147')) AND `RestChainsCuisineType`.`cuisine_type_id` = 14 GROUP BY `RestChain`.`id` LIMIT 30	3	3	16
16	SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` IN (25, 114, 358)	3	3	0
17	SELECT `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`, `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id` FROM `cuisine_types` AS `CuisineType` JOIN `rest_chains_cuisine_types` AS `RestChainsCuisineType` ON (`RestChainsCuisineType`.`rest_chain_id` IN (25, 114, 358) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	9	9	1
18	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=25 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
19	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=114 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
20	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=358 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
21	SELECT `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id`, `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains_cuisine_types` AS `RestChainsCuisineType` LEFT JOIN `rest_chains` AS `RestChain` ON (`RestChainsCuisineType`.`rest_chain_id` = `RestChain`.`id` AND `RestChain`.`active` = 1) WHERE NOT (`RestChainsCuisineType`.`rest_chain_id` IN ('147', '25', '114', '358')) AND `RestChainsCuisineType`.`cuisine_type_id` = 7 GROUP BY `RestChain`.`id` LIMIT 27	27	27	14
22	SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` IN (18, 22, 32, 40, 45, 55, 61, 67, 103, 161, 162, 163, 171, 177, 250, 256, 260, 261, 269, 282, 292, 293, 317, 323, 324, 333, 344)	27	27	0
23	SELECT `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`, `RestChainsCuisineType`.`id`, `RestChainsCuisineType`.`rest_chain_id`, `RestChainsCuisineType`.`cuisine_type_id` FROM `cuisine_types` AS `CuisineType` JOIN `rest_chains_cuisine_types` AS `RestChainsCuisineType` ON (`RestChainsCuisineType`.`rest_chain_id` IN (18, 22, 32, 40, 45, 55, 61, 67, 103, 161, 162, 163, 171, 177, 250, 256, 260, 261, 269, 282, 292, 293, 317, 323, 324, 333, 344) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	84	84	0
24	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=18 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
25	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=22 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
26	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=32 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
27	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=40 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
28	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=45 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
29	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=55 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
30	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=61 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
31	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=67 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
32	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=103 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
33	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=161 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
34	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=162 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
35	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=163 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
36	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=171 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
37	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=177 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
38	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=250 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
39	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=256 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
40	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=260 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
41	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=261 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
42	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=269 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
43	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=282 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
44	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=292 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
45	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=293 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
46	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=317 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
47	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=323 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
48	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=324 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0
49	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=333 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	0
50	SELECT RestsPic.*, Member.id, Member.unique_code from rests_pics AS RestsPic left join members AS Member ON RestsPic.member_id=Member.id WHERE RestsPic.rest_id IN (SELECT id from rests as Rest where Rest.rest_chain_id=344 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	0

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 :-).

Chain The China Moon

Chain เดอะไชน่า มูน

Feedback Sent!