CONTENTS
"DENMARK"のトピックス "クラシックカクテル"のトピックス "ニューヨーク"のトピックス "サンフランシスコ"のトピックス "ナイトクラブ"のトピックス "サゼラック"のトピックス "禁酒法"のトピックス "マティーニ"のトピックス "マンハッタン"のトピックス "リキュール"のトピックス "ハーブ"のトピックス "スパイス"のトピックス "ベリーニ"のトピックス "コスモポリタン"のトピックス "ネグローニ"のトピックス "ティキ"のトピックス "マイタイ"のトピックス "ピニャコラーダ"のトピックス "ウオッカ"のトピックス "テキーラ"のトピックス "ハリーズ・バー"のトピックス

SPECIAL FEATURE特別取材

歴代Angel's Share チームが東京に大集合！ iichiko Design Week 2024を祝福。
[vol.1] -

第1回チリピスコカクテルコンペティション特別レポート
[vol.2] - 総合優勝は「BAR CROSSING」の村上雄基さん！

総合優勝は「BAR CROSSING」の村上雄基さん！総合優勝は「BAR CROSSING」の村上雄基さん！

(default) 45 queries took 163 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `world_topics`58582
2DESCRIBE `world_topic_tags`221
3DESCRIBE `world_topics_world_topic_tags`221
4DESCRIBE `world_topic_ranks`551
5DESCRIBE `admins`551
6DESCRIBE `passport_admins`4416
7DESCRIBE `users`32323
8DESCRIBE `settlements`22222
9DESCRIBE `passport_users`441
10DESCRIBE `news`41412
11DESCRIBE `drink_planet_books`37371
12DESCRIBE `drink_planet_blogs`662
13DESCRIBE `event_informations`11113
14DESCRIBE `bars`1191192
15DESCRIBE `bartenders`1151155
16DESCRIBE `cocktail_todays`1071074
17DESCRIBE `shops`15152
18DESCRIBE `shop_tags`221
19DESCRIBE `shops_shoptags`221
20DESCRIBE `cocktail_today_tags`332
21DESCRIBE `cocktail_todays_cocktail_today_tags`222
22DESCRIBE `cocktail_today_ranks`552
23DESCRIBE `special_reports`3823823
24DESCRIBE `drink_planet_new_faces`1041042
25DESCRIBE `competitions`14141
26DESCRIBE `competition_details`40402
27DESCRIBE `site_settings`1711714
28DESCRIBE `favorite_items`992
29DESCRIBE `jobs`13134
30SELECT `Admin`.`id`, `Admin`.`account`, `Admin`.`password`, `Admin`.`old_password`, `Admin`.`level` FROM `admins` AS `Admin` WHERE `Admin`.`id` IS NULL LIMIT 1008
31SELECT `CocktailTodayTags`.`id`, `CocktailTodayTags`.`tag` FROM `cocktail_today_tags` AS `CocktailTodayTags` WHERE 1 = 1 ORDER BY `CocktailTodayTags`.`id` ASC 81813
32SELECT DISTINCT `CocktailToday`.`bartender_name` FROM `cocktail_todays` AS `CocktailToday` LEFT JOIN `bars` AS `Bar` ON (`CocktailToday`.`bar_id` = `Bar`.`id`) WHERE (NOT (`CocktailToday`.`bartender_name` IS NULL) AND NOT (`CocktailToday`.`bartender_name` = '')) ORDER BY `CocktailToday`.`bartender_name` ASC 45645617
33SELECT `DrinkPlanetBlog`.`id`, `DrinkPlanetBlog`.`title`, `DrinkPlanetBlog`.`blog_member_id`, `DrinkPlanetBlog`.`img`, `DrinkPlanetBlog`.`body`, `DrinkPlanetBlog`.`regist_date` FROM `drink_planet_blogs` AS `DrinkPlanetBlog` WHERE 1 = 1 ORDER BY `DrinkPlanetBlog`.`id` DESC LIMIT 3331
34SELECT `SiteSetting`.`id`, `SiteSetting`.`special_report_order`, `SiteSetting`.`special_report1_id`, `SiteSetting`.`special_report1_vol`, `SiteSetting`.`special_report1_img1`, `SiteSetting`.`special_report1_img2`, `SiteSetting`.`special_report1_publish`, `SiteSetting`.`special_report1_date`, `SiteSetting`.`special_report2_id`, `SiteSetting`.`special_report2_vol`, `SiteSetting`.`special_report2_img1`, `SiteSetting`.`special_report2_img2`, `SiteSetting`.`special_report2_publish`, `SiteSetting`.`special_report2_date`, `SiteSetting`.`side_report`, `SiteSetting`.`slider_publish1`, `SiteSetting`.`slider_date1`, `SiteSetting`.`slider_title1`, `SiteSetting`.`slider_url1`, `SiteSetting`.`slider_img1`, `SiteSetting`.`slider_order1`, `SiteSetting`.`slider_publish2`, `SiteSetting`.`slider_date2`, `SiteSetting`.`slider_title2`, `SiteSetting`.`slider_url2`, `SiteSetting`.`slider_img2`, `SiteSetting`.`slider_order2`, `SiteSetting`.`slider_publish3`, `SiteSetting`.`slider_date3`, `SiteSetting`.`slider_title3`, `SiteSetting`.`slider_url3`, `SiteSetting`.`slider_img3`, `SiteSetting`.`slider_order3`, `SiteSetting`.`slider_publish4`, `SiteSetting`.`slider_date4`, `SiteSetting`.`slider_title4`, `SiteSetting`.`slider_url4`, `SiteSetting`.`slider_img4`, `SiteSetting`.`slider_order4`, `SiteSetting`.`slider_publish5`, `SiteSetting`.`slider_date5`, `SiteSetting`.`slider_title5`, `SiteSetting`.`slider_url5`, `SiteSetting`.`slider_img5`, `SiteSetting`.`slider_order5`, `SiteSetting`.`slider_publish6`, `SiteSetting`.`slider_date6`, `SiteSetting`.`slider_title6`, `SiteSetting`.`slider_url6`, `SiteSetting`.`slider_img6`, `SiteSetting`.`slider_order6`, `SiteSetting`.`slider_publish7`, `SiteSetting`.`slider_date7`, `SiteSetting`.`slider_title7`, `SiteSetting`.`slider_url7`, `SiteSetting`.`slider_img7`, `SiteSetting`.`slider_order7`, `SiteSetting`.`slider_publish8`, `SiteSetting`.`slider_date8`, `SiteSetting`.`slider_title8`, `SiteSetting`.`slider_url8`, `SiteSetting`.`slider_img8`, `SiteSetting`.`slider_order8`, `SiteSetting`.`banner_publish1`, `SiteSetting`.`banner_date1`, `SiteSetting`.`banner_title1`, `SiteSetting`.`banner_url1`, `SiteSetting`.`banner_img1`, `SiteSetting`.`banner_order1`, `SiteSetting`.`banner_publish2`, `SiteSetting`.`banner_date2`, `SiteSetting`.`banner_title2`, `SiteSetting`.`banner_url2`, `SiteSetting`.`banner_img2`, `SiteSetting`.`banner_order2`, `SiteSetting`.`banner_publish3`, `SiteSetting`.`banner_date3`, `SiteSetting`.`banner_title3`, `SiteSetting`.`banner_url3`, `SiteSetting`.`banner_img3`, `SiteSetting`.`banner_order3`, `SiteSetting`.`banner_publish4`, `SiteSetting`.`banner_date4`, `SiteSetting`.`banner_title4`, `SiteSetting`.`banner_url4`, `SiteSetting`.`banner_img4`, `SiteSetting`.`banner_order4`, `SiteSetting`.`banner_publish5`, `SiteSetting`.`banner_date5`, `SiteSetting`.`banner_title5`, `SiteSetting`.`banner_url5`, `SiteSetting`.`banner_img5`, `SiteSetting`.`banner_order5`, `SiteSetting`.`banner_publish6`, `SiteSetting`.`banner_date6`, `SiteSetting`.`banner_title6`, `SiteSetting`.`banner_url6`, `SiteSetting`.`banner_img6`, `SiteSetting`.`banner_order6`, `SiteSetting`.`banner_publish7`, `SiteSetting`.`banner_date7`, `SiteSetting`.`banner_title7`, `SiteSetting`.`banner_url7`, `SiteSetting`.`banner_img7`, `SiteSetting`.`banner_order7`, `SiteSetting`.`banner_publish8`, `SiteSetting`.`banner_date8`, `SiteSetting`.`banner_title8`, `SiteSetting`.`banner_url8`, `SiteSetting`.`banner_img8`, `SiteSetting`.`banner_order8`, `SiteSetting`.`banner_publish9`, `SiteSetting`.`banner_date9`, `SiteSetting`.`banner_title9`, `SiteSetting`.`banner_url9`, `SiteSetting`.`banner_img9`, `SiteSetting`.`banner_order9`, `SiteSetting`.`banner_publish10`, `SiteSetting`.`banner_date10`, `SiteSetting`.`banner_title10`, `SiteSetting`.`banner_url10`, `SiteSetting`.`banner_img10`, `SiteSetting`.`banner_order10`, `SiteSetting`.`slider_eng_publish1`, `SiteSetting`.`slider_eng_date1`, `SiteSetting`.`slider_eng_title1`, `SiteSetting`.`slider_eng_url1`, `SiteSetting`.`slider_eng_img1`, `SiteSetting`.`slider_eng_order1`, `SiteSetting`.`slider_eng_publish2`, `SiteSetting`.`slider_eng_date2`, `SiteSetting`.`slider_eng_title2`, `SiteSetting`.`slider_eng_url2`, `SiteSetting`.`slider_eng_img2`, `SiteSetting`.`slider_eng_order2`, `SiteSetting`.`slider_eng_publish3`, `SiteSetting`.`slider_eng_date3`, `SiteSetting`.`slider_eng_title3`, `SiteSetting`.`slider_eng_url3`, `SiteSetting`.`slider_eng_img3`, `SiteSetting`.`slider_eng_order3`, `SiteSetting`.`slider_eng_publish4`, `SiteSetting`.`slider_eng_date4`, `SiteSetting`.`slider_eng_title4`, `SiteSetting`.`slider_eng_url4`, `SiteSetting`.`slider_eng_img4`, `SiteSetting`.`slider_eng_order4`, `SiteSetting`.`slider_eng_publish5`, `SiteSetting`.`slider_eng_date5`, `SiteSetting`.`slider_eng_title5`, `SiteSetting`.`slider_eng_url5`, `SiteSetting`.`slider_eng_img5`, `SiteSetting`.`slider_eng_order5`, `SiteSetting`.`slider_eng_publish6`, `SiteSetting`.`slider_eng_date6`, `SiteSetting`.`slider_eng_title6`, `SiteSetting`.`slider_eng_url6`, `SiteSetting`.`slider_eng_img6`, `SiteSetting`.`slider_eng_order6`, `SiteSetting`.`slider_eng_publish7`, `SiteSetting`.`slider_eng_date7`, `SiteSetting`.`slider_eng_title7`, `SiteSetting`.`slider_eng_url7`, `SiteSetting`.`slider_eng_img7`, `SiteSetting`.`slider_eng_order7`, `SiteSetting`.`slider_eng_publish8`, `SiteSetting`.`slider_eng_date8`, `SiteSetting`.`slider_eng_title8`, `SiteSetting`.`slider_eng_url8`, `SiteSetting`.`slider_eng_img8`, `SiteSetting`.`slider_eng_order8` FROM `site_settings` AS `SiteSetting` WHERE 1 = 1 ORDER BY `SiteSetting`.`id` asc LIMIT 1112
35SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`active_flag_01`, `SpecialReport`.`active_flag_02`, `SpecialReport`.`public_date_01`, `SpecialReport`.`public_date_02`, `SpecialReport`.`title_01`, `SpecialReport`.`title_02`, `SpecialReport`.`title_03`, `SpecialReport`.`title_04`, `SpecialReport`.`title_05`, `SpecialReport`.`title_06`, `SpecialReport`.`title_07`, `SpecialReport`.`title_08`, `SpecialReport`.`title_09`, `SpecialReport`.`title_10`, `SpecialReport`.`title_11`, `SpecialReport`.`title_12` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = 116 LIMIT 1112
36SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`active_flag_01`, `SpecialReport`.`active_flag_02`, `SpecialReport`.`public_date_01`, `SpecialReport`.`public_date_02`, `SpecialReport`.`title_01`, `SpecialReport`.`title_02`, `SpecialReport`.`title_03`, `SpecialReport`.`title_04`, `SpecialReport`.`title_05`, `SpecialReport`.`title_06`, `SpecialReport`.`title_07`, `SpecialReport`.`title_08`, `SpecialReport`.`title_09`, `SpecialReport`.`title_10`, `SpecialReport`.`title_11`, `SpecialReport`.`title_12` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = 117 LIMIT 1111
37SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`main_image_01` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = (NULL) ORDER BY `SpecialReport`.`id` desc 001
38SELECT COUNT(*) AS `count` FROM `cocktail_today_ranks` AS `CocktailTodayRank` LEFT JOIN `cocktail_todays` AS `CocktailToday` ON (`CocktailTodayRank`.`cocktail_today_id` = `CocktailToday`.`id`) WHERE 1 = 1 1112
39SELECT `CocktailTodayRank`.`id`, `CocktailTodayRank`.`count`, `CocktailTodayRank`.`year_no`, `CocktailTodayRank`.`week_no`, `CocktailTodayRank`.`cocktail_today_id`, `CocktailToday`.`id`, `CocktailToday`.`category`, `CocktailToday`.`title`, `CocktailToday`.`bar_id`, `CocktailToday`.`is_latter`, `CocktailToday`.`caption`, `CocktailToday`.`caption_eng`, `CocktailToday`.`img`, `CocktailToday`.`name_jp`, `CocktailToday`.`name_en`, `CocktailToday`.`bar_name`, `CocktailToday`.`bartender_name`, `CocktailToday`.`bartender_img`, `CocktailToday`.`body`, `CocktailToday`.`body_eng`, `CocktailToday`.`materials1`, `CocktailToday`.`materials1_eng`, `CocktailToday`.`materials2`, `CocktailToday`.`materials2_eng`, `CocktailToday`.`materials3`, `CocktailToday`.`materials3_eng`, `CocktailToday`.`materials4`, `CocktailToday`.`materials4_eng`, `CocktailToday`.`materials5`, `CocktailToday`.`materials5_eng`, `CocktailToday`.`materials6`, `CocktailToday`.`materials6_eng`, `CocktailToday`.`materials7`, `CocktailToday`.`materials7_eng`, `CocktailToday`.`materials8`, `CocktailToday`.`materials8_eng`, `CocktailToday`.`materials9`, `CocktailToday`.`materials9_eng`, `CocktailToday`.`materials10`, `CocktailToday`.`materials10_eng`, `CocktailToday`.`materials11`, `CocktailToday`.`materials11_eng`, `CocktailToday`.`materials12`, `CocktailToday`.`materials12_eng`, `CocktailToday`.`materials13`, `CocktailToday`.`materials13_eng`, `CocktailToday`.`materials14`, `CocktailToday`.`materials14_eng`, `CocktailToday`.`materials15`, `CocktailToday`.`materials15_eng`, `CocktailToday`.`quantity1`, `CocktailToday`.`quantity2`, `CocktailToday`.`quantity3`, `CocktailToday`.`quantity4`, `CocktailToday`.`quantity5`, `CocktailToday`.`quantity6`, `CocktailToday`.`quantity7`, `CocktailToday`.`quantity8`, `CocktailToday`.`quantity9`, `CocktailToday`.`quantity10`, `CocktailToday`.`quantity11`, `CocktailToday`.`quantity12`, `CocktailToday`.`quantity13`, `CocktailToday`.`quantity14`, `CocktailToday`.`quantity15`, `CocktailToday`.`recipe1`, `CocktailToday`.`recipe1_eng`, `CocktailToday`.`recipe2`, `CocktailToday`.`recipe2_eng`, `CocktailToday`.`recipe3`, `CocktailToday`.`recipe3_eng`, `CocktailToday`.`recipe4`, `CocktailToday`.`recipe4_eng`, `CocktailToday`.`recipe5`, `CocktailToday`.`recipe5_eng`, `CocktailToday`.`recipe6`, `CocktailToday`.`recipe6_eng`, `CocktailToday`.`recipe7`, `CocktailToday`.`recipe7_eng`, `CocktailToday`.`recipe8`, `CocktailToday`.`recipe8_eng`, `CocktailToday`.`recipe9`, `CocktailToday`.`recipe9_eng`, `CocktailToday`.`recipe10`, `CocktailToday`.`recipe10_eng`, `CocktailToday`.`recipe11`, `CocktailToday`.`recipe11_eng`, `CocktailToday`.`recipe12`, `CocktailToday`.`recipe12_eng`, `CocktailToday`.`recipe13`, `CocktailToday`.`recipe13_eng`, `CocktailToday`.`recipe14`, `CocktailToday`.`recipe14_eng`, `CocktailToday`.`recipe15`, `CocktailToday`.`recipe15_eng`, `CocktailToday`.`movie_url`, `CocktailToday`.`regist_date`, `CocktailToday`.`open_date`, `CocktailToday`.`update_date`, `CocktailToday`.`base_alcohol`, `CocktailToday`.`cocktail_method`, `CocktailToday`.`cocktail_style`, `CocktailToday`.`secret_of_brand_id`, `CocktailToday`.`secret_of_brand_eng`, `CocktailToday`.`secret_of_brand_quantity`, `CocktailToday`.`secret_of_brand_id2`, `CocktailToday`.`secret_of_brand2_eng`, `CocktailToday`.`secret_of_brand_quantity2`, `CocktailToday`.`competition_shop`, `CocktailToday`.`competition_shop_eng`, `CocktailToday`.`preview`, `CocktailToday`.`eng_content` FROM `cocktail_today_ranks` AS `CocktailTodayRank` LEFT JOIN `cocktail_todays` AS `CocktailToday` ON (`CocktailTodayRank`.`cocktail_today_id` = `CocktailToday`.`id`) WHERE 1 = 1 ORDER BY `CocktailTodayRank`.`year_no` DESC, `CocktailTodayRank`.`week_no` DESC, `CocktailTodayRank`.`count` DESC LIMIT 12, 4442
40SELECT `WorldTopicRank`.`id`, `WorldTopicRank`.`count`, `WorldTopicRank`.`year_no`, `WorldTopicRank`.`week_no`, `WorldTopicRank`.`world_topic_id`, `WorldTopic`.`id`, `WorldTopic`.`title`, `WorldTopic`.`caption`, `WorldTopic`.`interviewer`, `WorldTopic`.`img_main`, `WorldTopic`.`body_main`, `WorldTopic`.`img01`, `WorldTopic`.`img01_caption`, `WorldTopic`.`h3_01`, `WorldTopic`.`h4_01`, `WorldTopic`.`body01`, `WorldTopic`.`img02`, `WorldTopic`.`img02_caption`, `WorldTopic`.`h3_02`, `WorldTopic`.`h4_02`, `WorldTopic`.`body02`, `WorldTopic`.`img03`, `WorldTopic`.`img03_caption`, `WorldTopic`.`h3_03`, `WorldTopic`.`h4_03`, `WorldTopic`.`body03`, `WorldTopic`.`img04`, `WorldTopic`.`img04_caption`, `WorldTopic`.`h3_04`, `WorldTopic`.`h4_04`, `WorldTopic`.`body04`, `WorldTopic`.`img05`, `WorldTopic`.`img05_caption`, `WorldTopic`.`h3_05`, `WorldTopic`.`h4_05`, `WorldTopic`.`body05`, `WorldTopic`.`regist_date`, `WorldTopic`.`open_date`, `WorldTopic`.`update_date`, `WorldTopic`.`preview`, `WorldTopic`.`eng_content`, `WorldTopic`.`title_eng`, `WorldTopic`.`caption_eng`, `WorldTopic`.`img01_caption_eng`, `WorldTopic`.`h3_01_eng`, `WorldTopic`.`h4_01_eng`, `WorldTopic`.`body01_eng`, `WorldTopic`.`img02_caption_eng`, `WorldTopic`.`h3_02_eng`, `WorldTopic`.`h4_02_eng`, `WorldTopic`.`body02_eng`, `WorldTopic`.`img03_caption_eng`, `WorldTopic`.`h3_03_eng`, `WorldTopic`.`h4_03_eng`, `WorldTopic`.`body03_eng`, `WorldTopic`.`img04_caption_eng`, `WorldTopic`.`h3_04_eng`, `WorldTopic`.`h4_04_eng`, `WorldTopic`.`body04_eng`, `WorldTopic`.`img05_caption_eng`, `WorldTopic`.`h3_05_eng`, `WorldTopic`.`h4_05_eng`, `WorldTopic`.`body05_eng` FROM `world_topic_ranks` AS `WorldTopicRank` LEFT JOIN `world_topics` AS `WorldTopic` ON (`WorldTopicRank`.`world_topic_id` = `WorldTopic`.`id`) WHERE ((`WorldTopic`.`open_date` <= '2024-12-19') AND (`WorldTopic`.`open_date` <= '2024-11-19')) ORDER BY `WorldTopicRank`.`year_no` DESC, `WorldTopicRank`.`week_no` DESC, `WorldTopicRank`.`count` DESC LIMIT 4443
41SELECT WorldTopic.id FROM world_topics AS `WorldTopic` INNER JOIN world_topics_world_topic_tags AS `WorldTopicsWorldTopicTag` ON (`WorldTopicsWorldTopicTag`.`world_topic_id` = `WorldTopic`.`id`) INNER JOIN world_topic_tags AS `WorldTopicTag` ON (`WorldTopicTag`.`id` = `WorldTopicsWorldTopicTag`.`world_topic_tag_id`) WHERE `WorldTopicTag`.`tag` IN ('DENMARK', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'マティーニ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'ティキ', 'マイタイ', 'ピニャコラーダ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー') AND `WorldTopic`.`open_date` <= '2024-12-19' GROUP BY `WorldTopic`.`id`56568
42SELECT *, COUNT(DISTINCT `WorldTopicTag`.`id`) AS uniques FROM `world_topics` AS `WorldTopic` INNER JOIN world_topics_world_topic_tags AS `WorldTopicsWorldTopicTags` ON (`WorldTopicsWorldTopicTags`.`world_topic_id` = `WorldTopic`.`id`) INNER JOIN world_topic_tags AS `WorldTopicTag` ON (`WorldTopicTag`.`id` = `WorldTopicsWorldTopicTags`.`world_topic_tag_id`) WHERE `WorldTopicTag`.`tag` IN ('DENMARK', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'マティーニ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'ティキ', 'マイタイ', 'ピニャコラーダ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー') AND `WorldTopic`.`open_date` <= '2024-12-19' GROUP BY `WorldTopic`.`id` HAVING uniques = 21 ORDER BY `WorldTopic`.`open_date` DESC, `WorldTopic`.`regist_date` DESC, `WorldTopic`.`id` DESC LIMIT 27, 90013
43SELECT `WorldTopicTag`.`id`, `WorldTopicTag`.`tag` FROM `world_topic_tags` AS `WorldTopicTag` WHERE 1 = 1 140814082
44SELECT `WorldTopic`.`id`, COUNT(DISTINCT `WorldTopicTag`.`id`) AS uniques FROM `world_topics` AS `WorldTopic` INNER JOIN world_topics_world_topic_tags AS `WorldTopicsWorldTopicTags` ON (`WorldTopicsWorldTopicTags`.`world_topic_id` = `WorldTopic`.`id`) INNER JOIN world_topic_tags AS `WorldTopicTag` ON (`WorldTopicTag`.`id` = `WorldTopicsWorldTopicTags`.`world_topic_tag_id`) WHERE `WorldTopicTag`.`tag` IN ('DENMARK', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'マティーニ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'ティキ', 'マイタイ', 'ピニャコラーダ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー') AND `WorldTopic`.`open_date` <= '2024-12-19' GROUP BY `WorldTopic`.`id` HAVING uniques = 21 ORDER BY `WorldTopic`.`open_date` DESC, `WorldTopic`.`regist_date` DESC, `WorldTopic`.`id` DESC 0011
45DESCRIBE `secret_of_brands`27272