products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where series_id = "CNT_0H3Q3R1YE3QG"
This data as json, CSV (advanced)
Suggested facets: copyright, listed_at (date), on_sale_at (date)
| id ▼ | content_id | series_id | parent_content_id | level | content_type | product_type | title | alt_titles | subtitle | display_title | display_title_short | description | description_short | image_id | display_order | listed_at | label_id | geoblock_id | display_name | copyright | on_presale_at | on_sale_at | off_sale_at | add_on | add_on_campaign_only |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRD_0M5KCRN9KWJ0 | CNT_04SFV8PE04W0 | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 6 | [] | Bless 6 | Aia and Jun have each scored themselves a spot in the U21 contest, but since models and makeup artists are matched by lottery, their opportunity to work together is far from guaranteed. With intimidating new rivals coming out of the woodwork, will both of them have what it takes to win it all? As Jun contemplates her dreams and goals for the future, Aia contends with his colleagues' old acquaintances and their own formidable strengths. An opportunity to do makeup for dozens of new adults on Coming of Age Day turns into a chance to reaffirm what makeup means to him and regain his confidence. The stage is set for the U21 showdown! | 01KG78NT9ZH3J3Q0884KD97ZA8 | 6.0 | 2025-12-05T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 6 | Yukino Sonoyama/KODANSHA LTD. | 2025-12-23T08:00:00.000Z | 0 | 0 | |||||
| PRD_13AQWTAZXTNG | CNT_1VFG5C9WQ70G | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 7 | [] | Bless 7 | A new day brings fresh hope and a promise of dreams come true. Aia and Jun are fearless as they embark on an adventure that could change their lives forever. They're brimming with confidence, ready to challenge the world, even knowing that it's always darkest before the dawn. It's the morning of the highly anticipated U21 competition, and everyone is exploding with nerves. The aspiring makeup artists have their assignments and are paired up with their models. With the contest underway, Aia takes the slow and steady route, while his seemingly seasoned rivals are suddenly going frantic. As one of the models, Jun also is also feeling the pressure. After all the blood, sweat, and tears, who will emerge as the next rising star? | 01KH57K24G7QG881A6SK43M3ZN | 7.0 | 2026-01-23T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 7 | Yukino Sonoyama/KODANSHA LTD. | 2026-02-10T08:00:00.000Z | 0 | 0 | |||||
| PRD_17JX24PXM9TG | CNT_0GJEE938G86G | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 5 | [] | Bless 5 | No path to stardom is without bumps and rough patches. Just when Aia and Jun begin to make headways towards their dreams, they find themselves lost in their journeys. Luckily, the two friends are committed to supporting each other unconditionally at every step. Under the tutelage of the best professional makeup artists, the pressure is on Aia as his every move is scrutinized by faculty and fellow students. When the instructors at MIRROR propose a challenge with a highly coveted career-making prize, friendly rivalry turns into cutthroat competition. Aia focuses on his own vision, avoiding the toxic environment around him. However, jealousy is impossible to ignore when the celebrity makeup artist Daiya is playing favorites. Can Aia and Jun's loyalty survive Daiya's mind games? | 01KGBR2ZYASP3QB7Y5H6VX69VC | 5.0 | 2025-06-05T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 5 | Yukino Sonoyama/KODANSHA LTD. | 2025-06-24T07:00:00.000Z | 0 | 0 | |||||
| PRD_188PBFCMKJF0 | CNT_2WQJH9ETWNAG | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 2 | [] | Bless 2 | Now that Aia is committed to pursuing his dream of becoming a makeup artist, he'll have to step outside of his comfort zone in order to upskill. His friend and muse, Jun, is also on the road to her goal of becoming a model. Sky's the limit as they shoot for the stars. In the cutthroat world of the beauty industry, Aia knows he can't rest on his laurels. When he is summoned to MIRROR, an exclusive school for aspiring makeup artists, it's a revelation to be surrounded by peers-and rivals. Meanwhile, Jun drums up the courage to enter the ultra-competitive modeling casting circuit, thanks to a new portfolio created with Aia's help. The two are determined to succeed while staying true to their visions. Can the dynamic duo thrive in a world where success often seems preordained? | 01KGBA21WJR82YSSRCADF6W7D3 | 2.0 | 2024-06-11T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 2 | Yukino Sonoyama/Kodansha Ltd. | 2024-07-02T07:00:00.000Z | 0 | 0 | |||||
| PRD_1V921H7WYYVG | CNT_1PRHV2YZYDG0 | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 1 | [] | Bless 1 | At a young age, Aia Utagawa was scouted as a model, but his real ambition is to become a makeup artist. But, even as the end of high school approaches, it's a dream he hides inside, afraid of stepping outside his prescribed role as a pretty face. Then, one day, he meets Jun, a quiet classmate who hunches because she's ashamed of her face, covered in freckles. He convinces her to enter a school runway fashion contest together-with him doing her makeup. They make an incredible team, with Jun discovering a confidence she never knew she could show and Aia finally learning that, while it may be tough to open yourself up to failing at the one thing you care about, the difficulties can be worth facing. | 01KGB0107AB2PEME4CFS9ZGKH0 | 1.0 | 2024-03-12T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 1 | Yukino Sonoyama/Kodansha Ltd. | 2024-04-02T07:00:00.000Z | 0 | 0 | |||||
| PRD_3QATHKTR7WWG | CNT_1E5C979KKBT0 | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 4 | [] | Bless 4 | Determined to prove they belong with the pros, Aia and Jun strive to be the very best in their field. Recognition from their peers is validating, but achieving personal milestones also calls for celebration. Both are radiating with confidence, ready to step into the spotlight. It takes a village to nurture talent, and Jun's mother is proud to see her daughter take flight. Aia's support system comes from MIRROR where he gets on-the-job experience along with a heavy dose of tough love. With every moment devoted to pursuing their passion, Jun and Aia reflect on what it takes to make it in the fashion and beauty world. Every star has an origin story leading to success. Is it time for Jun and Aia to shine, or will the pressure burn them out? | 01KG9Q9ZWSQXAJMNHYXE958SP1 | 4.0 | 2025-03-04T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 4 | Yukino Sonoyama/Kodansha Ltd. | 2025-03-05T08:00:00.000Z | 0 | 0 | |||||
| PRD_3T10P6FBJWMG | CNT_255W3A4VWZGG | Bless CNT_0H3Q3R1YE3QG | CNT_0H3Q3R1YE3QG | 2 | 1 | 1 | Volume 3 | [] | Bless 3 | Surrounded by a circle of like-minded talent, Aia finally feels free to pursue becoming a makeup artist. His friend Jun makes her own breakthrough toward a seemingly impossible modeling career. Despite the challenges ahead, their determination to succeed is unstoppable. Competition in the beauty world often gets ugly. To get an advantage, Aia asks his rival Ginga for guidance and on-the-job experience. Meanwhile, Jun is at a crucial modeling casting, under the glare of the industry's harshest judges. Just as she's about to crack, a celebrity insider lends a helping hand-a move that might seal the deal. Aia and Jun grow more confident, but they also grapple with the reality that there's always someone better. Could that struggle be what drives them to rise above the rest? | 01KGBC75KBPR8G6FR2Q38D2G9N | 3.0 | 2024-09-10T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Bless 3 | Yukino Sonoyama/Kodansha Ltd. | 2024-10-01T07:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE products (
id TEXT PRIMARY KEY,
content_id TEXT NOT NULL,
series_id TEXT NOT NULL,
parent_content_id TEXT,
level INTEGER NOT NULL,
content_type INTEGER NOT NULL,
product_type INTEGER NOT NULL,
title TEXT NOT NULL,
alt_titles TEXT NOT NULL,
subtitle TEXT NOT NULL,
display_title TEXT NOT NULL,
display_title_short TEXT NOT NULL,
description TEXT NOT NULL,
description_short TEXT NOT NULL,
image_id TEXT NOT NULL,
display_order REAL NOT NULL,
listed_at TEXT NOT NULL,
label_id TEXT NOT NULL,
geoblock_id TEXT,
display_name TEXT NOT NULL,
copyright TEXT,
on_presale_at TEXT,
on_sale_at TEXT NOT NULL,
off_sale_at TEXT,
add_on INTEGER NOT NULL,
add_on_campaign_only INTEGER NOT NULL,
FOREIGN KEY (series_id) REFERENCES series(id),
FOREIGN KEY (label_id) REFERENCES labels(id),
FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
);
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);