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


Chain ฮะจิบัง ราเม็ง

Chain Hachiban Ramen

จำนวนสาขา: 6
ประเภทอาหาร:
เอเชียน, ญี่ปุ่น, ราเม็ง/ก๋วยเตี๋ยวญี่ปุ่น
ประเภทตัวร้าน:
ร้านในตึก/ห้าง
ช่วงราคา:
100-250บ.
คะแนนรวมของทั้ง
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
6 สาขา
( 0คน)
รสชาติ
(0คน)
บรรยากาศ
(0คน)
บริการ
(0คน)
คุ้มค่า
(0คน)
คุณอยากจะ..
ภายในหน้านี้...
ไปอีกหน้า...
Share
จอดรถ:
ที่จอดรถของตึก
เหมาะกับ:
เหมาะกับมากับเด็กๆ
เหมาะกับมาคนเดียว
เหมาะกับมาเป็นกลุ่ม
แผนที่ และสาขาของ chain ฮะจิบัง ราเม็ง (6)
Loading restaurants...
Chain นี้ยังไม่มีข้อมูลสาขา.
เพิ่มสาขาใหม่ของ chain ฮะจิบัง ราเม็ง
Loading restaurants...
Chainอื่นที่น่าสนใจ (29)
(default) 58 queries took 143 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rest_chains`353518
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `members`464619
4SHOW FULL COLUMNS FROM `cuisine_types`101019
5SHOW FULL COLUMNS FROM `blds_pics_likes`5521
6SHOW FULL COLUMNS FROM `external_reviews_likes`5523
7SHOW FULL COLUMNS FROM `external_reviews`232320
8SHOW FULL COLUMNS FROM `price_ranges`7720
9SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
10SELECT `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` = 247 AND `RestChain`.`active` = 1 LIMIT 1111
11SELECT `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` = 247 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC 330
12SELECT `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` = 247 AND `RestChainsRestType`.`rest_type_id` = `RestType`.`id`) ORDER BY `level` ASC 110
13SELECT `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` = 247 AND `RestChainsRestFeature`.`rest_feature_id` = `RestFeature`.`id`) ORDER BY `level` ASC 440
14SELECT `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
15 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` = '247' ) AND RestsPic.`active` = '1' ORDER BY RestsPic.`num_likes` DESC, RestsPic.`id` DESC LIMIT 5 440
16 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` = '247' ) AND RestsPic.`active` = '1' 110
17SELECT `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` = 247 AND `WebsiteDeal`.`active` = 1 AND `WebsiteDeal`.`valid_to` >= '2024-04-28' 000
18SELECT `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` = 247 AND `RestChain`.`active` = 1 LIMIT 1110
19SELECT `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` = 247 AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `CuisineType`.`level` DESC 330
20SELECT `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` = ('247')) AND `RestChainsCuisineType`.`cuisine_type_id` = 18 GROUP BY `RestChain`.`id` LIMIT 3024240
21SELECT `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 (5, 6, 14, 21, 50, 51, 62, 66, 105, 120, 139, 144, 150, 155, 165, 179, 183, 255, 257, 284, 296, 331, 339, 377) 24240
22SELECT `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 (5, 6, 14, 21, 50, 51, 62, 66, 105, 120, 139, 144, 150, 155, 165, 179, 183, 255, 257, 284, 296, 331, 339, 377) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC 85850
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=5 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=6 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=14 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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;000
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=50 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=51 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=62 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=66 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=105 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=120 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=139 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=144 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=150 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=155 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=165 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;000
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=179 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=183 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=255 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=257 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=284 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=296 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=331 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=339 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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=377 AND Rest.active=1 ) AND RestsPic.active=1 ORDER BY RestsPic.num_likes DESC LIMIT 1;110
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 ('247', '5', '6', '14', '21', '50', '51', '62', '66', '105', '120', '139', '144', '150', '155', '165', '179', '183', '255', '257', '284', '296', '331', '339', '377')) AND `RestChainsCuisineType`.`cuisine_type_id` = 8 GROUP BY `RestChain`.`id` LIMIT 6660
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` IN (30, 3, 4, 11, 15, 16) 550
49SELECT `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, 11, 15, 16) AND `RestChainsCuisineType`.`cuisine_type_id` = `CuisineType`.`id`) ORDER BY `level` ASC 14140
50SELECT 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;110
51SELECT 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;110
52SELECT 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;110
53SELECT 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;000
54SELECT 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;000
55SELECT `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 ('247', '5', '6', '14', '21', '50', '51', '62', '66', '105', '120', '139', '144', '150', '155', '165', '179', '183', '255', '257', '284', '296', '331', '339', '377', '3', '4', '11', '15', '16')) AND `RestChainsCuisineType`.`cuisine_type_id` = 2 GROUP BY `RestChain`.`id` LIMIT 1110
56SELECT `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
57SELECT `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 ('247', '5', '6', '14', '21', '50', '51', '62', '66', '105', '120', '139', '144', '150', '155', '165', '179', '183', '255', '257', '284', '296', '331', '339', '377', '3', '4', '11', '15', '16')) GROUP BY `RestChain`.`id` LIMIT 1110
58SELECT `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 ...