Notice (8): Undefined index: SecretOfBrand [APP/views/layouts/default.ctp, line 79]
ケテル ワン

Ketel One
ケテル ワン

BRAND DATA
カテゴリー ウオッカ
アルコール度数 40% Vol.
原材料他 北ヨーロッパ産の厳選された小麦
容量 750
ボトルサイズ 高さ:331mm
幅:74mm
奥行:74mm
原産国 オランダ
輸入者 キリンビール株式会社
TASTING NOTE
外観  : 輝きのある無色透明。
香り  : フレッシュで、かすかなシトラス系フルーツや蜂蜜のような香り。
味わい : 口当たりはシルクのようにソフトで柔らかく、味わいはすっきりとキレが良い。
余韻  : 余韻はとても長く、カクテルベースにすると副材料の味わいを引き立てる。
SECRETS OF BRAND
Ketel One は、1691年創業し、325年以上の歴史を誇る「ノレット蒸溜所」(オランダのスキーダム)で造られるこだわりのプレミアムウオッカです。
2017年現在、既に世界90ヵ国で販売され、約250万ケースもの売上を誇っています。また、世界的に権威ある業界紙「ドリンクス・インターナショナル」実施のリサーチ「アニュアルバー レポート」※で、世界のトップクラスのバーに大変高い評価を得ているブランドです。
原料は、北ヨーロッパ産の厳選された小麦を6塔式連続式蒸留器で精製した高品質のウルトラウィートスピリッツです。その一部を伝統ある1号単式蒸留器(オランダ語でケテル ワン)に移動し、更に味わいを磨いていきます。
300年以上にわたって蓄積した蒸溜ノウハウとスキルを用いて作られるこのクラフトスピリッツのハートと、連続式蒸留器の原酒をマリアージュすることで、クリアな味わいと共に絶妙な長い余韻が生まれます。
こうして作られるケテル ワンの味覚の特徴は、The 4F’s と呼ばれています。  
フレグランス(香り)、フレーバー(味わい)、フィール(口当たり)、フィニッシュ(喉ごし)に他のウオッカで感じられないような特徴があり、カクテルベースにすると、副材料の香りと味わいの余韻がぐっと引き立つ点が、最大の特徴です。

GREY GOOSE
グレイグース

Notice (8): Undefined index: bartender_name [APP/views/elements/back_number.ctp, line 98]

GREY GOOSE LA POIRE
グレイグース ラ・ポワール

GREY GOOSE L’ORANGE
グレイグース ル・オランジェ

GREY GOOSE LE CITRON
グレイグース ル・シトロン

Ketel One
ケテル ワン

CIROC
シロック

SPECIAL FEATURE特別取材

(default) 46 queries took 110 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `cocktail_todays`1071072
2DESCRIBE `bars`1191192
3DESCRIBE `shops`15152
4DESCRIBE `shop_tags`222
5DESCRIBE `shops_shoptags`222
6DESCRIBE `cocktail_today_tags`332
7DESCRIBE `cocktail_todays_cocktail_today_tags`222
8DESCRIBE `secret_of_brands`27272
9DESCRIBE `admins`552
10DESCRIBE `passport_admins`442
11DESCRIBE `users`32322
12DESCRIBE `settlements`22222
13DESCRIBE `passport_users`442
14DESCRIBE `news`41412
15DESCRIBE `drink_planet_books`37373
16DESCRIBE `drink_planet_blogs`662
17DESCRIBE `event_informations`11112
18DESCRIBE `bartenders`1151152
19DESCRIBE `cocktail_today_ranks`552
20DESCRIBE `world_topic_ranks`552
21DESCRIBE `world_topics`58582
22DESCRIBE `world_topic_tags`222
23DESCRIBE `world_topics_world_topic_tags`222
24DESCRIBE `special_reports`3823823
25DESCRIBE `drink_planet_new_faces`1041042
26DESCRIBE `competitions`14142
27DESCRIBE `competition_details`40402
28DESCRIBE `site_settings`1711713
29DESCRIBE `favorite_items`992
30DESCRIBE `jobs`13132
31SELECT `Admin`.`id`, `Admin`.`account`, `Admin`.`password`, `Admin`.`old_password`, `Admin`.`level` FROM `admins` AS `Admin` WHERE `Admin`.`id` IS NULL LIMIT 1002
32SELECT `CocktailTodayTags`.`id`, `CocktailTodayTags`.`tag` FROM `cocktail_today_tags` AS `CocktailTodayTags` WHERE 1 = 1 ORDER BY `CocktailTodayTags`.`id` ASC 81812
33SELECT 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 45645612
34SELECT `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
35SELECT `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
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` = 116 LIMIT 1112
37SELECT `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
38SELECT `SpecialReport`.`id`, `SpecialReport`.`main_title`, `SpecialReport`.`main_image_01` FROM `special_reports` AS `SpecialReport` WHERE `SpecialReport`.`id` = (NULL) ORDER BY `SpecialReport`.`id` desc 002
39SELECT 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 113
40SELECT `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 4442
41SELECT `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-22') AND (`WorldTopic`.`open_date` <= '2024-11-22')) ORDER BY `WorldTopicRank`.`year_no` DESC, `WorldTopicRank`.`week_no` DESC, `WorldTopicRank`.`count` DESC LIMIT 4444
42SELECT `SecretOfBrands`.`id`, `SecretOfBrands`.`name_en`, `SecretOfBrands`.`name_jp`, `SecretOfBrands`.`main_img`, `SecretOfBrands`.`category`, `SecretOfBrands`.`abv`, `SecretOfBrands`.`material`, `SecretOfBrands`.`extracted_component`, `SecretOfBrands`.`vintage`, `SecretOfBrands`.`aging`, `SecretOfBrands`.`volume`, `SecretOfBrands`.`bottle_size_height`, `SecretOfBrands`.`bottle_size_width`, `SecretOfBrands`.`bottle_size_depth`, `SecretOfBrands`.`country`, `SecretOfBrands`.`importer`, `SecretOfBrands`.`url`, `SecretOfBrands`.`appearance`, `SecretOfBrands`.`aroma`, `SecretOfBrands`.`taste`, `SecretOfBrands`.`afterglow`, `SecretOfBrands`.`secrets_of_brand`, `SecretOfBrands`.`open_date`, `SecretOfBrands`.`preview`, `SecretOfBrands`.`created`, `SecretOfBrands`.`modified`, `SecretOfBrands`.`public_flg` FROM `secret_of_brands` AS `SecretOfBrands` WHERE `SecretOfBrands`.`id` = 44 AND `SecretOfBrands`.`public_flg` = 1 AND `SecretOfBrands`.`open_date` <= '2024-12-22' LIMIT 1112
43SELECT c.base_alcohol, c.open_date, c.id, c.name_jp, c.name_en, c.bartender_name, c.img AS 'main_img', sh.name FROM cocktail_todays c LEFT JOIN bars b ON c.bar_id=b.id LEFT JOIN shops sh ON b.shop_id=sh.id WHERE c.secret_of_brand_id=44 OR c.secret_of_brand_id2=44 ORDER BY c.name_jp ASC444
44SELECT category FROM secret_of_brands WHERE id=44 ORDER BY id DESC112
45SELECT COUNT(*) AS `count` FROM `secret_of_brands` AS `SecretOfBrands` WHERE `SecretOfBrands`.`open_date` <= '2024-12-22' AND `SecretOfBrands`.`category` = 0 AND `SecretOfBrands`.`public_flg` = 1 112
46SELECT `SecretOfBrands`.`id`, `SecretOfBrands`.`name_en`, `SecretOfBrands`.`name_jp`, `SecretOfBrands`.`main_img`, `SecretOfBrands`.`category`, `SecretOfBrands`.`abv`, `SecretOfBrands`.`material`, `SecretOfBrands`.`extracted_component`, `SecretOfBrands`.`vintage`, `SecretOfBrands`.`aging`, `SecretOfBrands`.`volume`, `SecretOfBrands`.`bottle_size_height`, `SecretOfBrands`.`bottle_size_width`, `SecretOfBrands`.`bottle_size_depth`, `SecretOfBrands`.`country`, `SecretOfBrands`.`importer`, `SecretOfBrands`.`url`, `SecretOfBrands`.`appearance`, `SecretOfBrands`.`aroma`, `SecretOfBrands`.`taste`, `SecretOfBrands`.`afterglow`, `SecretOfBrands`.`secrets_of_brand`, `SecretOfBrands`.`open_date`, `SecretOfBrands`.`preview`, `SecretOfBrands`.`created`, `SecretOfBrands`.`modified`, `SecretOfBrands`.`public_flg` FROM `secret_of_brands` AS `SecretOfBrands` WHERE `SecretOfBrands`.`open_date` <= '2024-12-22' AND `SecretOfBrands`.`category` = 0 AND `SecretOfBrands`.`public_flg` = 1 ORDER BY `SecretOfBrands`.`name_jp` ASC LIMIT 9662