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

(default) 45 queries took 126 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`552
6DESCRIBE `passport_admins`442
7DESCRIBE `users`32321
8DESCRIBE `settlements`22221
9DESCRIBE `passport_users`442
10DESCRIBE `news`41412
11DESCRIBE `drink_planet_books`37372
12DESCRIBE `drink_planet_blogs`661
13DESCRIBE `event_informations`11112
14DESCRIBE `bars`1191192
15DESCRIBE `bartenders`1151152
16DESCRIBE `cocktail_todays`1071072
17DESCRIBE `shops`15152
18DESCRIBE `shop_tags`221
19DESCRIBE `shops_shoptags`221
20DESCRIBE `cocktail_today_tags`332
21DESCRIBE `cocktail_todays_cocktail_today_tags`221
22DESCRIBE `cocktail_today_ranks`551
23DESCRIBE `special_reports`6226225
24DESCRIBE `drink_planet_new_faces`1041042
25DESCRIBE `competitions`14142
26DESCRIBE `competition_details`40402
27DESCRIBE `site_settings`1711712
28DESCRIBE `favorite_items`991
29DESCRIBE `jobs`13131
30SELECT `Admin`.`id`, `Admin`.`account`, `Admin`.`password`, `Admin`.`old_password`, `Admin`.`level` FROM `admins` AS `Admin` WHERE `Admin`.`id` IS NULL LIMIT 1001
31SELECT `CocktailTodayTags`.`id`, `CocktailTodayTags`.`tag` FROM `cocktail_today_tags` AS `CocktailTodayTags` WHERE 1 = 1 ORDER BY `CocktailTodayTags`.`id` ASC 81811
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 46846812
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` = 123 LIMIT 1111
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` = 121 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 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 114
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 1932, 4449
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` <= '2025-05-11') AND (`WorldTopic`.`open_date` <= '2025-04-11')) 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 ('BRASIL', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', 'アメリカンカクテル', '禁酒法', 'マティーニ', 'ダイキリ', 'マンハッタン', 'ミントジュレップ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'グラスホッパー', 'ティキ', 'マイタイ', 'トロピカルカクテル', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') AND `WorldTopic`.`open_date` <= '2025-05-11' GROUP BY `WorldTopic`.`id`55559
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 ('BRASIL', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', 'アメリカンカクテル', '禁酒法', 'マティーニ', 'ダイキリ', 'マンハッタン', 'ミントジュレップ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'グラスホッパー', 'ティキ', 'マイタイ', 'トロピカルカクテル', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') AND `WorldTopic`.`open_date` <= '2025-05-11' GROUP BY `WorldTopic`.`id` HAVING uniques = 27 ORDER BY `WorldTopic`.`open_date` DESC, `WorldTopic`.`regist_date` DESC, `WorldTopic`.`id` DESC LIMIT 54, 90014
43SELECT `WorldTopicTag`.`id`, `WorldTopicTag`.`tag` FROM `world_topic_tags` AS `WorldTopicTag` WHERE 1 = 1 144014403
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 ('BRASIL', 'クラシックカクテル', 'ニューヨーク', 'サンフランシスコ', 'ナイトクラブ', 'サゼラック', 'アメリカンカクテル', '禁酒法', 'マティーニ', 'ダイキリ', 'マンハッタン', 'ミントジュレップ', 'スタンダードカクテル', 'リキュール', 'ハーブ', 'スパイス', 'ベリーニ', 'コスモポリタン', 'グラスホッパー', 'ティキ', 'マイタイ', 'トロピカルカクテル', 'ディスコ', 'ウオッカ', 'テキーラ', 'ハリーズ・バー', 'ブラッディメアリー') AND `WorldTopic`.`open_date` <= '2025-05-11' GROUP BY `WorldTopic`.`id` HAVING uniques = 27 ORDER BY `WorldTopic`.`open_date` DESC, `WorldTopic`.`regist_date` DESC, `WorldTopic`.`id` DESC 0011
45DESCRIBE `secret_of_brands`27272