1 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | | 2 | 2 | 0 |
2 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` LEFT JOIN rests AS `Rest` ON (`RestsComment`.`rest_id` = `Rest`.`id`) LEFT JOIN blds AS `Bld` ON (`Bld`.`id` = `Rest`.`bld_id`) LEFT JOIN `members` AS `Member` ON (`RestsComment`.`member_id` = `Member`.`id`) WHERE `RestsComment`.`active` = 1 | | 1 | 1 | 59 |
3 | SELECT `RestsComment`.`id`, `RestsComment`.`overall_rating`, `RestsComment`.`taste_rating`, `RestsComment`.`atmosphere_rating`, `RestsComment`.`price_rating`, `RestsComment`.`service_rating`, `RestsComment`.`subject`, `RestsComment`.`comment`, `RestsComment`.`visit_date`, `RestsComment`.`created`, `RestsComment`.`num_likes`, `RestsComment`.`order_in_rest`, `RestsComment`.`rest_id`, `RestsComment`.`owner_last_view`, `RestsComment`.`nonmember_id`, `RestsComment`.`nonmember_name`, `Member`.`id`, `Member`.`username`, `Member`.`unique_code`, `Member`.`avatar_file_name_s` FROM `rests_comments` AS `RestsComment` LEFT JOIN rests AS `Rest` ON (`RestsComment`.`rest_id` = `Rest`.`id`) LEFT JOIN blds AS `Bld` ON (`Bld`.`id` = `Rest`.`bld_id`) LEFT JOIN `members` AS `Member` ON (`RestsComment`.`member_id` = `Member`.`id`) WHERE `RestsComment`.`active` = 1 ORDER BY `RestsComment`.`id` DESC LIMIT 7960, 20 | | 14 | 14 | 83 |
4 | SELECT `RestsPic`.`id`, `RestsPic`.`file_name_m`, `RestsPic`.`caption`, `RestsPic`.`num_likes`, `RestsPic`.`rest_pic_type_id`, `RestsPic`.`rests_comment_id` FROM `rests_pics` AS `RestsPic` WHERE `RestsPic`.`active` = 1 AND `RestsPic`.`rests_comment_id` IN (14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) ORDER BY `RestsPic`.`order_in_comment` ASC | | 41 | 41 | 0 |
5 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
6 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
7 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
8 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
9 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
10 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
11 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
12 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
13 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
14 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
15 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
16 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 3 | | 1 | 1 | 0 |
17 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
18 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
19 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
20 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
21 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
22 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
23 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
24 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 2 | | 1 | 1 | 0 |
25 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
26 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
27 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 3 | | 1 | 1 | 0 |
28 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
29 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
30 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
31 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
32 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 3 | | 1 | 1 | 0 |
33 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
34 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
35 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
36 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
37 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 3 | | 1 | 1 | 0 |
38 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
39 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 4 | | 1 | 1 | 0 |
40 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
41 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
42 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 4 | | 1 | 1 | 0 |
43 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
44 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
45 | SELECT `RestPicType`.`id`, `RestPicType`.`nameTh`, `RestPicType`.`nameEn`, `RestPicType`.`icon_file_path`, `RestPicType`.`created`, `RestPicType`.`modified` FROM `rest_pic_types` AS `RestPicType` WHERE `RestPicType`.`id` = 1 | | 1 | 1 | 0 |
46 | SELECT `RestsCommentsReply`.`id`, `RestsCommentsReply`.`reply`, `RestsCommentsReply`.`created`, `RestsCommentsReply`.`member_id`, `RestsCommentsReply`.`rests_comment_id` FROM `rests_comments_replies` AS `RestsCommentsReply` WHERE `RestsCommentsReply`.`active` = 1 AND `RestsCommentsReply`.`rests_comment_id` IN (14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) ORDER BY `RestsCommentsReply`.`id` ASC | | 0 | 0 | 0 |
47 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 14 | | 1 | 1 | 0 |
48 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 14 | | 1 | 1 | 1 |
49 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 14 | | 1 | | 1 |
50 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 13 | | 1 | 1 | 0 |
51 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 13 | | 1 | 1 | 0 |
52 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 13 | | 1 | | 0 |
53 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 12 | | 1 | 1 | 0 |
54 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 12 | | 1 | 1 | 0 |
55 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 12 | | 1 | | 0 |
56 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 11 | | 1 | 1 | 0 |
57 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 11 | | 1 | 1 | 0 |
58 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 11 | | 1 | | 0 |
59 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 10 | | 1 | 1 | 0 |
60 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 10 | | 1 | 1 | 0 |
61 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 10 | | 1 | | 0 |
62 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 9 | | 1 | 1 | 0 |
63 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 9 | | 1 | 1 | 0 |
64 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 9 | | 1 | | 0 |
65 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 8 | | 1 | 1 | 0 |
66 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 8 | | 1 | 1 | 0 |
67 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 8 | | 1 | | 0 |
68 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 7 | | 1 | 1 | 0 |
69 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 7 | | 1 | 1 | 0 |
70 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 7 | | 1 | | 0 |
71 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 6 | | 1 | 1 | 0 |
72 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 6 | | 1 | 1 | 0 |
73 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 6 | | 1 | | 0 |
74 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 5 | | 1 | 1 | 0 |
75 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 5 | | 1 | 1 | 0 |
76 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 5 | | 1 | | 0 |
77 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 4 | | 1 | 1 | 0 |
78 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 4 | | 1 | 1 | 0 |
79 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 4 | | 1 | | 0 |
80 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 3 | | 1 | 1 | 0 |
81 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 3 | | 1 | 1 | 0 |
82 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 3 | | 1 | | 0 |
83 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 2 | | 1 | 1 | 0 |
84 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 2 | | 1 | 1 | 0 |
85 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 2 | | 1 | | 0 |
86 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 1 | | 1 | 1 | 0 |
87 | SELECT COUNT(*) AS `count` FROM `rests_comments` AS `RestsComment` WHERE `RestsComment`.`id` = 1 | | 1 | 1 | 0 |
88 | UPDATE `rests_comments` SET `owner_last_view` = NOW(), `modified` = '2024-05-15 09:38:40' WHERE `rests_comments`.`id` = 1 | | 1 | | 0 |
89 | SELECT `Rest`.`id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`branch_nameEn`, `Rest`.`tags`, `Rest`.`descriptionTh`, `Rest`.`descriptionEn`, `Rest`.`seo_url`, `Rest`.`full_text`, `Rest`.`st_addrTh`, `Rest`.`st_addrEn`, `Rest`.`directionTh`, `Rest`.`directionEn`, `Rest`.`th_province_id`, `Rest`.`country_id`, `Rest`.`lat`, `Rest`.`lng`, `Rest`.`bts_id`, `Rest`.`bts_minutes`, `Rest`.`mrt_id`, `Rest`.`mrt_minutes`, `Rest`.`tel`, `Rest`.`official_website`, `Rest`.`official_menu`, `Rest`.`facebook`, `Rest`.`hours`, `Rest`.`price_range_id`, `Rest`.`rest_chain_id`, `Rest`.`bld_id`, `Rest`.`bld_floor`, `Rest`.`bld_zone`, `Rest`.`in_bld_addrTh_orig`, `Rest`.`in_bld_addrTh`, `Rest`.`in_bld_addrEn`, `Rest`.`cur_overall_rating`, `Rest`.`num_overall_rating`, `Rest`.`cur_taste_rating`, `Rest`.`num_taste_rating`, `Rest`.`cur_atmosphere_rating`, `Rest`.`num_atmosphere_rating`, `Rest`.`cur_price_rating`, `Rest`.`num_price_rating`, `Rest`.`cur_service_rating`, `Rest`.`num_service_rating`, `Rest`.`bayesian_rating`, `Rest`.`is_our_member`, `Rest`.`from_owner`, `Rest`.`num_comments`, `Rest`.`num_kratoos`, `Rest`.`num_pics`, `Rest`.`num_external_reviews`, `Rest`.`active`, `Rest`.`moved_to_rest_id`, `Rest`.`added_by_member_id`, `Rest`.`created`, `Rest`.`modified`, `Rest`.`primary_rests_pic_id`, `Rest`.`primary_pic_by_admin`, `Rest`.`primary_rests_pic_thumb_m`, `Rest`.`admin_validated`, `Rest`.`cuisine_type_ids`, `Rest`.`rest_type_ids`, `Rest`.`rest_feature_ids`, `Rest`.`logo`, `Rest`.`logo_s`, `Rest`.`logo_thumb`, `Rest`.`logo_thumb_s`, (CONCAT(`Rest`.`nameTh`, " (", `Rest`.`nameEn`, ")")) AS `Rest__nameThEn`, `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `rests` AS `Rest` LEFT JOIN `blds` AS `Bld` ON (`Rest`.`bld_id` = `Bld`.`id`) LEFT JOIN `btses` AS `Bts` ON (`Rest`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Rest`.`mrt_id` = `Mrt`.`id`) WHERE `Rest`.`id` IN (2157, 1737, 2314, 2314, 2043, 2043, 2500, 2500, 489, 489, 2058, 3044, 3045, 2058) | | 9 | 9 | 0 |
90 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 7 | | 1 | 1 | 0 |
91 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 9 | | 1 | 1 | 0 |
92 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | | 1 | 1 | 0 |
93 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 184 | | 1 | 1 | 0 |
94 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 13 | | 1 | 1 | 0 |
95 | SELECT `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 13 | | 1 | 1 | 0 |
96 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | | 1 | 1 | 0 |
97 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 5 | | 1 | 1 | 0 |
98 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 9 | | 1 | 1 | 0 |
99 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | | 1 | 1 | 0 |
100 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 5 | | 1 | 1 | 0 |
101 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 9 | | 1 | 1 | 0 |
102 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | | 1 | 1 | 0 |
103 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 8 | | 1 | 1 | 0 |
104 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 9 | | 1 | 1 | 0 |
105 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | | 1 | 1 | 0 |
106 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 1951 | | 1 | 1 | 0 |
107 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 1 | | 1 | 1 | 0 |
108 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 21 | | 1 | 1 | 0 |
109 | SELECT `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 9 | | 1 | 1 | 0 |
110 | SELECT `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 16 | | 1 | 1 | 0 |
111 | SELECT `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 9 | | 1 | 1 | 0 |
112 | SELECT `Bts`.`id`, `Bts`.`nameEn` FROM `btses` AS `Bts` WHERE 1 = 1 ORDER BY `id` ASC | | 30 | 30 | 0 |
113 | SELECT `Mrt`.`id`, `Mrt`.`nameEn` FROM `mrts` AS `Mrt` WHERE 1 = 1 ORDER BY `id` ASC | | 18 | 18 | 0 |
ได้คูปองลดราคามาเลยมาลองครับ ห้องคาราโอเกะบวกอาหาร อาหารที่นี่รสชาติดีมาก เป็นแนว
อาหารไทยที่แปลกๆ ไม่เหมือนร้านอื่นนิดนึง เช่น กุ้งเมืองลับแล ส้มตำยอดมะพร้าวหมูกรอบ อาหาร
ส่วนมากอร่อยประทับใจดีคับ ราคาก็อยู่ที่ประมาณจานลt100 กว่าถึง 300คับ (300 จะเป็นพวกปลา
เป็นตัวๆ ซะมาก)
อาหารที่เค้าแนะนำในเมนู เท่าที่สั่งมาก็อร่อยทุกอย่างเลยนะคับ
แต่ส่วนห้องคาราโอเกะ ระบบผมว่ามันยังไม่ค่อยถูกใจเท่าไหร่ ไม่มีรีโมทใช้เลือกเพลง ต้องไปกดจอ
สัมผัสเอา และไมค์ก็เสียงเบา และบางทีหอนไปหน่อย เลยขอหักคะแนนบรรยากาศลง 1 ดาวคับ
ส่วนบรรยากาศในส่วนร้านอาหารนอกห้องคาราโอเกะ ผมว่าสวยดูดีเลยทีเดียว ออกแนวทางเหนือๆ
หน่อย แล้วก็มีวงดนตรีเล่นด้วย (แต่ไม่ได้ฟังเลย นั่งร้องเกะในห้องอย่างเดียว - -')
สรุปคือ ประทับใจอาหาร ส่วนห้องเกะยังเฉยๆ แต่ก็ไม่ถึงขั้นแย่ เรียกว่ากลางๆคับ
การเดินทาง ถ้าเข้าห้าง Esplanade ร้านจะอยู่หลังห้างเลยคับ เดินออกประตูหลังห้างก็เจอเลย
หรือถ้าขับรถ จะมีซอยที่อยู่ก่อนตัวถึง Esplanade คับ มีป้ายอยู่เลี้ยวเข้าไปเลย มีลานจอดรถกว้างดี