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

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

Banner 728x90

English

ภาษาไทย

Near where

Wanna Eat/Find

Home » Find restaurants » Chain Kanemochi Ice cream

Chain Kanemochi Ice cream

Chain คาเนะโมจิ ไอศกรีม

No. of branches: 1

Cuisine types:

Drinks/Beverages, Snacks/Desserts, Ice-creams, Smoothies

Price range:

50-100 B

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

1 branches

( 0ppl)

Taste

(0ppl)

Atmosphere

(0ppl)

Service

(0ppl)

Price

(0ppl)

View all branches(1)

View all pics(0)

Add a new branch

[Chain info incorrect?]

Website: http://www.kanemochiicecream.com

Facebook: http://www.facebook.com/KanemochiIcec...

Official Menu: http://www.facebook.com/KanemochiIcec...

Parking:

building's parking

Good for?:

kids

alone

Map and branches of chain Kanemochi Ice cream (1)

Loading restaurants...

This chain has no branch info yet.

Add a new brach of the chain Kanemochi Ice cream

Loading restaurants...

Chain we think you might be interested in (30)

1. ChainThe Deli House

European, Snacks/Desserts, Drinks/Beverages, Italian, Pasta, Cakes, Smoothies, Breads/Bakery, Coffee/Teas

(3 branches)
2. ChainMezzo Coffee

Snacks/Desserts, Drinks/Beverages, Smoothies, Coffee/Teas, Cakes

(7 branches)
3. ChainSecret Recipe

European, Drinks/Beverages, Snacks/Desserts, Italian, Pasta, Coffee/Teas, Cakes, Smoothies

(4 branches)
4. ChainCold Stone Creamery

Snacks/Desserts, Drinks/Beverages, Coffee/Teas, Smoothies, Ice-creams

(3 branches)
5. ChainBug & Bee

Drinks/Beverages, International, Snacks/Desserts, Fusion, Cakes, Coffee/Teas, Smoothies

(2 branches)
6. ChainCoffee World

Drinks/Beverages, Snacks/Desserts, Smoothies, Cakes, Coffee/Teas

(15 branches)
7. ChainMister Donuts

Snacks/Desserts, Drinks/Beverages, Smoothies, Donuts, Coffee/Teas

(4 branches)
8. ChainAfter You

Other Cuisine, Snacks/Desserts, Drinks/Beverages, Breads/Bakery, Coffee/Teas, Cakes, Smoothies

(1 branches)
9. ChainKrispy Kream

Drinks/Beverages, Snacks/Desserts, Coffee/Teas, Donuts, Smoothies

(4 branches)
10. ChainMPB Sweet Cake

Snacks/Desserts, Drinks/Beverages, Coffee/Teas, Cakes, Smoothies

(2 branches)
11. ChainInthanin Premio

Drinks/Beverages, Snacks/Desserts, Cakes, Smoothies, Coffee/Teas

(1 branches)
12. ChainChadokoro Bangkok

Asian, Snacks/Desserts, Drinks/Beverages, Japanese, Ice-creams, Smoothies, Cakes, Coffee/Teas

(2 branches)
13. ChainPeony Teafé and Gallery

European, Snacks/Desserts, Drinks/Beverages, Italian, Pasta, Ice-creams, Smoothies, Cakes, Coffee/Teas

(1 branches)
14. ChainPeony Tea Room

European, Drinks/Beverages, Italian, Pasta, Smoothies, Coffee/Teas

(1 branches)
15. ChainVista Cafe by Verasu

European, Snacks/Desserts, Drinks/Beverages, Healthy food, Breads/Bakery, Coffee/Teas, Cakes, Smoothies

(5 branches)
16. ChainHanabira

Asian, Drinks/Beverages, Japanese, Snacks/Desserts, Smoothies, Coffee/Teas

(2 branches)
17. ChainStarbucks

Snacks/Desserts, Drinks/Beverages, Coffee/Teas

(104 branches)
18. ChainAu Bon Pain

Americas, Drinks/Beverages, Snacks/Desserts, American, Breads/Bakery, Hamburger/Sandwich, Coffee/Teas

(37 branches)
19. ChainS&P

Asian, Snacks/Desserts, Thai, Breads/Bakery, Cakes

(19 branches)
20. ChainHaagen-Dazs

Snacks/Desserts, Ice-creams

(14 branches)
21. ChainIce Monster

Snacks/Desserts, Ice-creams

(6 branches)
22. Chainete Homemade Ice Cream

Snacks/Desserts, Ice-creams

(4 branches)
23. ChainLittle Home Bakery

Snacks/Desserts, Cakes, Breads/Bakery

(5 branches)
24. Chainiberry Cafe

Snacks/Desserts, Ice-creams

(5 branches)
25. ChainGulliver's Traveler's Tavern

Americas, European, Asian, Thai, International, American, Snacks/Desserts, Hamburger/Sandwich

(3 branches)
26. ChainBreadTalk & ToastBox

Asian, Singaporean, Snacks/Desserts, Drinks/Beverages, Malaysian, Cakes, Breads/Bakery, Coffee/Teas

(5 branches)
27. ChainWhittard of Chelsea

Snacks/Desserts, Drinks/Beverages, Breads/Bakery, Coffee/Teas, Cakes

(5 branches)
28. ChainMelt Me Hokkaido Chocolate & Healthy Gelato

Snacks/Desserts, Ice-creams

(2 branches)
29. ChainNew Zealand Natural

Snacks/Desserts, Ice-creams

(2 branches)
30. ChainCream & Fudge Factory

Snacks/Desserts, Ice-creams

(3 branches)

Banner 160x600

Site map

About us

Help

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

(default) 47 queries took 402 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	0
2	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` = 288 AND `RestChain`.`active` = 1 LIMIT 1	1	1	2
3	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` = 288 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	4	4	3
4	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` = 288 AND `RestChainsRestType`.`rest_type_id` = `RestType`.`id`) ORDER BY `level` ASC	0	0	1
5	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` = 288 AND `RestChainsRestFeature`.`rest_feature_id` = `RestFeature`.`id`) ORDER BY `level` ASC	3	3	2
6	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
7	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` = '288' ) AND RestsPic.`active` = '1' ORDER BY RestsPic.`num_likes` DESC, RestsPic.`id` DESC LIMIT 5	0	0	6
8	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` = '288' ) AND RestsPic.`active` = '1'	1	1	5
9	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` = 288 AND `WebsiteDeal`.`active` = 1 AND `WebsiteDeal`.`valid_to` >= '2024-04-24'	0	0	1
10	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` = 288 AND `RestChain`.`active` = 1 LIMIT 1	1	1	1
11	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` = 288 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `CuisineType`.`level` DESC	4	4	1
12	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` = ('288')) AND `RestChainsCuisineType`.`cuisine_type_id` = 116 GROUP BY `RestChain`.`id` LIMIT 30	16	16	20
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` IN (76, 91, 151, 166, 185, 198, 217, 258, 278, 285, 313, 336, 342, 343, 345, 352)	16	16	2
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` IN (76, 91, 151, 166, 185, 198, 217, 258, 278, 285, 313, 336, 342, 343, 345, 352) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	103	103	6
15	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=76 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	11
16	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=91 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	7
17	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=151 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=166 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=185 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	7
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=198 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	12
21	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=217 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	18
22	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=258 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	8
23	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=278 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=285 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	16
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=313 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	6
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=336 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	9
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=342 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	16
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=343 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	8
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=345 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	21
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=352 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	4
31	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 ('288', '76', '91', '151', '166', '185', '198', '217', '258', '278', '285', '313', '336', '342', '343', '345', '352')) AND `RestChainsCuisineType`.`cuisine_type_id` = 117 GROUP BY `RestChain`.`id` LIMIT 14	14	14	21
32	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 (1, 2, 9, 10, 37, 52, 58, 60, 80, 119, 137, 167, 168, 188)	14	14	1
33	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 (1, 2, 9, 10, 37, 52, 58, 60, 80, 119, 137, 167, 168, 188) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC	53	53	3
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=1 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=2 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	8
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=9 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	8
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=10 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	12
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=37 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	26
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=52 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	26
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=58 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	19
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=60 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=80 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	9
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=119 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=137 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5
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=167 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	19
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=168 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	0	0	17
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=188 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;	1	1	5

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 Kanemochi Ice cream

Chain คาเนะโมจิ ไอศกรีม

Feedback Sent!