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

SPECIAL FEATURE特別取材

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

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

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

(default) 45 queries took 174 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `world_topics`58582
2DESCRIBE `world_topic_tags`223
3DESCRIBE `world_topics_world_topic_tags`223
4DESCRIBE `world_topic_ranks`552
5DESCRIBE `admins`553
6DESCRIBE `passport_admins`444
7DESCRIBE `users`32323
8DESCRIBE `settlements`22223
9DESCRIBE `passport_users`443
10DESCRIBE `news`41414
11DESCRIBE `drink_planet_books`37372
12DESCRIBE `drink_planet_blogs`662
13DESCRIBE `event_informations`11113
14DESCRIBE `bars`1191193
15DESCRIBE `bartenders`1151153
16DESCRIBE `cocktail_todays`1071073
17DESCRIBE `shops`15153
18DESCRIBE `shop_tags`222
19DESCRIBE `shops_shoptags`223
20DESCRIBE `cocktail_today_tags`332
21DESCRIBE `cocktail_todays_cocktail_today_tags`222
22DESCRIBE `cocktail_today_ranks`553
23DESCRIBE `special_reports`3823824
24DESCRIBE `drink_planet_new_faces`1041043
25DESCRIBE `competitions`14143
26DESCRIBE `competition_details`40402
27DESCRIBE `site_settings`1711714
28DESCRIBE `favorite_items`993
29DESCRIBE `jobs`13133
30SELECT `Admin`.`id`, `Admin`.`account`, `Admin`.`password`, `Admin`.`old_password`, `Admin`.`level` FROM `admins` AS `Admin` WHERE `Admin`.`id` IS NULL LIMIT 1003
31SELECT `CocktailTodayTags`.`id`, `CocktailTodayTags`.`tag` FROM `cocktail_today_tags` AS `CocktailTodayTags` WHERE 1 = 1 ORDER BY `CocktailTodayTags`.`id` ASC 81812
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 45645611
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 3333
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 1114
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 1114
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 1114
37SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`main_image_01` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = (NULL) ORDER BY `SpecialReport`.`id` desc 004
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 116
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 8, 4443
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 4445
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 ('GERMANY', 'クラシックカクテル', 'ニューヨーク', 'ナイトクラブ', 'アメリカンカクテル', '禁酒法', 'ダイキリ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'グラスホッパー', 'マイタイ', 'トロピカルカクテル', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') AND `WorldTopic`.`open_date` <= '2024-12-19' GROUP BY `WorldTopic`.`id`777710
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 ('GERMANY', 'クラシックカクテル', 'ニューヨーク', 'ナイトクラブ', 'アメリカンカクテル', '禁酒法', 'ダイキリ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'グラスホッパー', 'マイタイ', 'トロピカルカクテル', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') 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 18, 90017
43SELECT `WorldTopicTag`.`id`, `WorldTopicTag`.`tag` FROM `world_topic_tags` AS `WorldTopicTag` WHERE 1 = 1 140814083
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 ('GERMANY', 'クラシックカクテル', 'ニューヨーク', 'ナイトクラブ', 'アメリカンカクテル', '禁酒法', 'ダイキリ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'ネグローニ', 'グラスホッパー', 'マイタイ', 'トロピカルカクテル', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') 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 009
45DESCRIBE `secret_of_brands`27273