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

SPECIAL FEATURE特別取材

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

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

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

(default) 45 queries took 3384 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `world_topics`58583
2DESCRIBE `world_topic_tags`223
3DESCRIBE `world_topics_world_topic_tags`222
4DESCRIBE `world_topic_ranks`552
5DESCRIBE `admins`552
6DESCRIBE `passport_admins`442
7DESCRIBE `users`32322
8DESCRIBE `settlements`22222
9DESCRIBE `passport_users`442
10DESCRIBE `news`41412
11DESCRIBE `drink_planet_books`37373
12DESCRIBE `drink_planet_blogs`662
13DESCRIBE `event_informations`11112
14DESCRIBE `bars`119119122
15DESCRIBE `bartenders`1151155
16DESCRIBE `cocktail_todays`107107525
17DESCRIBE `shops`15153
18DESCRIBE `shop_tags`226
19DESCRIBE `shops_shoptags`224
20DESCRIBE `cocktail_today_tags`332
21DESCRIBE `cocktail_todays_cocktail_today_tags`222
22DESCRIBE `cocktail_today_ranks`552
23DESCRIBE `special_reports`382382517
24DESCRIBE `drink_planet_new_faces`104104528
25DESCRIBE `competitions`14143
26DESCRIBE `competition_details`40404
27DESCRIBE `site_settings`171171524
28DESCRIBE `favorite_items`992
29DESCRIBE `jobs`13132
30SELECT `Admin`.`id`, `Admin`.`account`, `Admin`.`password`, `Admin`.`old_password`, `Admin`.`level` FROM `admins` AS `Admin` WHERE `Admin`.`id` IS NULL LIMIT 1005
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 456456568
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 3332
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 1112
37SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`main_image_01` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = (NULL) ORDER BY `SpecialReport`.`id` desc 002
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 1183
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, 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 4444
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 ('CHINA', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'ダイキリ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'ネグローニ', 'マイタイ', 'ピニャコラーダ', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') AND `WorldTopic`.`open_date` <= '2024-12-19' GROUP BY `WorldTopic`.`id`6464179
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 ('CHINA', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'ダイキリ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'ネグローニ', 'マイタイ', 'ピニャコラーダ', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') 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, 900132
43SELECT `WorldTopicTag`.`id`, `WorldTopicTag`.`tag` FROM `world_topic_tags` AS `WorldTopicTag` WHERE 1 = 1 140814087
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 ('CHINA', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', '禁酒法', 'ダイキリ', 'マンハッタン', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'ネグローニ', 'マイタイ', 'ピニャコラーダ', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') 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 00104
45DESCRIBE `secret_of_brands`27276