This is the test environment server: dev.kinnshare.com
แถวไหน
อยากกิน/หาร้าน


Chain ไมโดะโอคินิ

Chain Maido Ookini

จำนวนสาขา: 3
ประเภทอาหาร:
เอเชียน, ญี่ปุ่น
คะแนนรวมของทั้ง
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
3 สาขา
( 0คน)
รสชาติ
(0คน)
บรรยากาศ
(0คน)
บริการ
(0คน)
คุ้มค่า
(0คน)
คุณอยากจะ..
ภายในหน้านี้...
ไปอีกหน้า...
Share
แผนที่ และสาขาของ chain ไมโดะโอคินิ (3)
Loading restaurants...
Chain นี้ยังไม่มีข้อมูลสาขา.
เพิ่มสาขาใหม่ของ chain ไมโดะโอคินิ
Loading restaurants...
Chainอื่นที่น่าสนใจ (29)
(default) 50 queries took 521 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rest_chains`353523
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `reported_pics`161619
4SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
5SELECT `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` = 85 AND `RestChain`.`active` = 1 LIMIT 1110
6SELECT `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` = 85 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC 220
7SELECT `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` = 85 AND `RestChainsRestType`.`rest_type_id` = `RestType`.`id`) ORDER BY `level` ASC 000
8SELECT `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` = 85 AND `RestChainsRestFeature`.`rest_feature_id` = `RestFeature`.`id`) ORDER BY `level` ASC 000
9SELECT `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
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` = '85' ) AND RestsPic.`active` = '1' ORDER BY RestsPic.`num_likes` DESC, RestsPic.`id` DESC LIMIT 5 0014
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` = '85' ) AND RestsPic.`active` = '1' 114
12SELECT `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` = 85 AND `WebsiteDeal`.`active` = 1 AND `WebsiteDeal`.`valid_to` >= '2024-05-06' 002
13SELECT `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` = 85 AND `RestChain`.`active` = 1 LIMIT 1111
14SELECT `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` = 85 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `CuisineType`.`level` DESC 224
15SELECT `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` = ('85')) AND `RestChainsCuisineType`.`cuisine_type_id` = 8 GROUP BY `RestChain`.`id` LIMIT 30303024
16SELECT `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 (30, 3, 4, 5, 6, 11, 14, 15, 16, 21, 24, 35, 38, 43, 46, 50, 51, 56, 62, 64, 66, 68, 69, 82, 84, 87, 93, 96, 99, 102) 29292
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`, `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 (3, 4, 5, 6, 11, 14, 15, 16, 21, 24, 35, 38, 43, 46, 50, 51, 56, 62, 64, 66, 68, 69, 82, 84, 87, 93, 96, 99, 102) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC 92927
18SELECT 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=3 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1112
19SELECT 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=4 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;115
20SELECT 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=5 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;115
21SELECT 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=6 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;112
22SELECT 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=11 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1110
23SELECT 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=14 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1111
24SELECT 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=15 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0017
25SELECT 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=16 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0020
26SELECT 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=21 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0021
27SELECT 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=24 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1112
28SELECT 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=35 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;115
29SELECT 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=38 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1114
30SELECT 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=43 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;113
31SELECT 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=46 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;114
32SELECT 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=50 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0016
33SELECT 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=51 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0018
34SELECT 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=56 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;119
35SELECT 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=62 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;112
36SELECT 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=64 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;119
37SELECT 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=66 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0018
38SELECT 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=68 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;119
39SELECT 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=69 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1111
40SELECT 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=82 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0025
41SELECT 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=84 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;116
42SELECT 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=87 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0020
43SELECT 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=93 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;1111
44SELECT 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=96 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0027
45SELECT 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=99 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0013
46SELECT 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=102 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;0014
47SELECT `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 ('85', '3', '4', '5', '6', '11', '14', '15', '16', '21', '24', '35', '38', '43', '46', '50', '51', '56', '62', '64', '66', '68', '69', '82', '84', '87', '93', '96', '99', '102')) AND `RestChainsCuisineType`.`cuisine_type_id` = 2 GROUP BY `RestChain`.`id` LIMIT 11130
48SELECT `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` = (30) 001
49SELECT `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 ('85', '3', '4', '5', '6', '11', '14', '15', '16', '21', '24', '35', '38', '43', '46', '50', '51', '56', '62', '64', '66', '68', '69', '82', '84', '87', '93', '96', '99', '102')) GROUP BY `RestChain`.`id` LIMIT 11140
50SELECT `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` = (30) 000
Submit feedback to KinnShare
ถ้าคุณต้องการส่ง Feedback ให้ทางทีมงานกินแชร์, แจ้งปัญหาการใช้งานหรือบั๊กของระบบ หรือพบข้อมูลที่ไม่ถูกต้อง คุณสามารถใช้แบบฟอร์มข้างล่างนี้ติดต่อกับเราได้เลยค่ะ
submitting ...