products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
13 rows where series_id = "CNT_3PA3WWRDKB5G"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_0AAH607PY610 | CNT_0D5B4ASMS9V0 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 8 | [] | [Oshi No Ko], Vol. 8 | After a major revelation, the flames of vengeance have died down in Aqua’s heart. At the same time, B Komachi is set to have their first music video (and boost their YouTube channel). Aqua is also headed to a vacation with the cast of the 2.5D play, and it's near where Aqua and Ruby died in their previous lives! | 01KGBAYSAF1B0AAB38GGJ4NBAD | 8.0 | 2024-06-18T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 8 | 2024-11-19T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0DTGNKRKEWP0 | CNT_1TZ60F92W450 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 13 | [] | [Oshi No Ko], Vol. 13 | “I’m more convinced than anyone that Ruby can make it to the top.”Production of The 15 Year Lie has begun! After winning against Akane Kurokawa and Frill Shiranui in a private audition, Ruby is cast to play her own mom, Ai Hoshino. Now, on top of her red-hot idol and TV talent careers, she’s entering the world of acting with fiery determination. But inner turmoil over how she sees her mothers—in her past life and the present—leaves Ruby with a mental block that she’s struggling to overcome alone! | 01KP0B2FB9BVW5HFE7JPFFHQD4 | 13.0 | 2025-10-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 13 | 2026-04-28T00:00:00.000Z | 0 | 0 | ||||||
| PRD_115VRCC9W73G | CNT_2KSAA63G96R0 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 7 | [] | [Oshi No Ko], Vol. 7 | “To me, acting is revenge.”The stage is set for Kana and Akane to put on a performance that will prove who is the superior actor. But while Akane boldly steps into the spotlight, Kana draws back, letting her rival shine even brighter. Years in the industry have taught Kana to survive, not to strive—but that’s not the Kana-chan who Akane wants to face! With a packed house and all eyes on them, can Aqua help Kana reclaim the sparkle that made her a star? | 01KGAZNJBAJGVE5TAAD362E0NG | 7.0 | 2024-02-27T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 7 | 2024-08-27T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1FA0D93EA6HG | CNT_0XP0F048AJXG | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 2 | [] | [Oshi No Ko], Vol. 2 | Ten years after the murder of pop idol Ai Hoshino, her young (and unusually mature) twins are now poised to enter high school. While her death has had a profound effect on the children, it’s manifested in polar-opposite ways. Ruby is determined to follow in her mother’s footsteps and become an idol, but Aqua has no desire to stand in the spotlight. Instead, he works behind the scenes in the entertainment industry, all while harboring an ulterior motive: discover the identity of the accomplice in his mother’s untimely death! | 01KGB4FHZCG7AJRCG8V8TBS6SR | 2.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 2 | 2023-05-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1SSFX8MF6JSG | CNT_1GHFB8Z734KG | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 3 | [] | [Oshi No Ko], Vol. 3 | Hoping to glean more information about his father, Aqua agrees to join the dating reality show We’re About to Fall in Love for Real ! Most of the production’s teenage-celeb cast members are in it for the exposure, but not all publicity is good publicity. When the footage can be edited for maximum drama, “reality” becomes whatever the director wants it to be—even if that means leaving someone’s reputation on the cutting room floor... | 01KGB6180VEHMFXJKJG0RFZMZK | 3.0 | 2023-03-14T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 3 | 2023-08-22T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2623R4E04SZ0 | CNT_3D2S7P7NGD0G | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 10 | [] | [Oshi No Ko], Vol. 10 | “How much of this was you? …No, how far back did you start pulling the strings?”When the TV show Dig Deep!! faces online backlash, Ruby manages to swing the controversy in her favor to boost her own rising popularity. Sensing someone else’s influence in Ruby’s sudden attitude shift, Aqua seeks out Ichigo Saitou, missing president of Ichigo Production. Ichigo has his own reasons for wanting to avenge Ai, and to Aqua’s dismay, the young actor learns that his own quest for retribution may not yet be resolved… | 01KGBNBPQEHQTDDK9T8QBMX5C9 | 10.0 | 2025-04-11T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 10 | 2025-05-27T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2C8PZST79V40 | CNT_35HYY6NX4670 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 5 | [] | [Oshi No Ko], Vol. 5 | “In show business, lies are a weapon.” Tensions are running high on the set of the Tokyo Blade theatrical adaptation—though not in the way anyone expected! Surprisingly, Kana and Akane are managing to keep their longstanding rivalry purely professional; in fact, the amount of talent onstage is motivating all the actors to do their very best. But there’s someone who isn’t thrilled with the direction things are headed, and she’s the one person whose opinion matters most: the original manga creator! | 01KH3GZYJR38FH5TENQ3MTW9R8 | 5.0 | 2023-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 5 | 2024-02-20T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2F1ZPPN3PFY0 | CNT_1RHT6VS2RYXG | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 4 | [] | [Oshi No Ko], Vol. 4 | As filming wraps on Love for Real, Mem-cho confesses that despite her online success, she’s always dreamed of becoming an idol. How convenient—Aqua happens to know a group that’s recruiting! Now three members strong, the new B Komachi can start working on their routine…but will they get their act together in time for Japan Idol Fest?! | 01KH3EXJM57HYXW3FXSRE3MK1Q | 4.0 | 2023-05-31T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 4 | 2023-11-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2F9DB7R3MD80 | CNT_11FT7NAKB9C0 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 1 | [] | [Oshi No Ko], Vol. 1 | Gorou is an ob-gyn with a life far removed from the glitz and glamour of the entertainment industry—the world of his favorite idol, rising star Ai Hoshino. But when the two are unexpectedly brought together, their fates become intertwined in ways that defy all reason. For the good doctor, it’s time to stan(d) and deliver! | 01KGB2ZB5NC8ZFTMANFN95DNK4 | 1.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 1 | 2023-01-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2HQ27K4Q8RH0 | CNT_3XCSNXD3ZQPG | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 11 | [] | [Oshi No Ko], Vol. 11 | “The hearts and lives of those children get broken by this ever-moving industry.”When the chance to network with a popular film director turns into an overnight stay at his “studio,” Kana is faced with a dilemma. How far is she willing to go to land her next acting gig? Whatever did (or didn’t) happen behind closed doors, the paparazzi photos of her leaving the director’s apartment building the next morning could destroy her career…and threaten the future of B Komachi! | 01KG9R0DFP0VH51GJSVSPEAKXC | 11.0 | 2025-03-06T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 11 | 2025-08-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2SRSQHWD1DE0 | CNT_3YEHYZPBWFW0 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 9 | [] | [Oshi No Ko], Vol. 9 | While in the legend-filled town of Takachiho for B Komachi’s music video shoot, Ruby learned that the murder of Ai didn’t fall on just one culprit. Someone is still out there, living a carefree life—and she just can’t let that be. Act 7 of Oshi no Ko begins! | 01KGBCHKCWMFE3E5RWEXF8B2C5 | 9.0 | 2024-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 9 | 2025-02-18T08:00:00.000Z | 0 | 0 | ||||||
| PRD_31AB5EDW3QFG | CNT_18K48EAY27ZG | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 6 | [] | [Oshi No Ko], Vol. 6 | The 2.5D Play Arc draws closer to the main event! The original creator of the Tokyo Blade manga, Abiko Samejima, rejected all the theatrical scripts by the writer, GOA. But they’ve finally reached an agreement—and the result is a script sharply focused on the actors’ performances?! Aqua Hoshino, who had been seeking out “emotional acting,” will have to face his deep trauma surrounding Ai... | 01KG9PG83A4W34W66WY8N10G61 | 6.0 | 2023-12-21T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | [Oshi No Ko], Vol. 6 | 2024-05-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3WY000ZZNHM0 | CNT_08G3EWE773D0 | [Oshi No Ko] CNT_3PA3WWRDKB5G | CNT_3PA3WWRDKB5G | 2 | 1 | 1 | Volume 12 | [] | [Oshi No Ko], Vol. 12 | “Ruby, what does ‘lying’ mean to you?”Production begins on The 15 Year Lie, Aqua’s retelling of his mother’s life designed to expose her true killer. Producer Kaburagi and Director Gotanda must juggle the expectations of distributors, investors, and whoever else they need to get their movie into theaters…And everyone has a different opinion on who should play Ai. Frill’s popularity, Akane’s skill, or Ruby’s passion—who has what it takes to carry the film’s leading role? | 01KGBS5ZB8NR9EHT68XA7TWJJW | 12.0 | 2025-07-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | [Oshi No Ko], Vol. 12 | 2025-12-16T08: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);