products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_09FN4PATQJBG"
This data as json, CSV (advanced)
Suggested facets: description, listed_at, copyright, on_sale_at, 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_0T8TZ1BBSRMG | CNT_1CCT4QCA3290 | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 4 | [] | Ossan Idol! Volume 4 | A new friendship blossoms between Miroku and a fan, and MiYoShi's popularity blossoms both onstage and behind the scenes. Meanwhile, Fumi discovers Miroku was her mysterious hero, after all! Does this mean that a sweet romance between a brand-new idol and his manager is also about to bloom? | 01KG9FG3MFA6QJ65VG8EE5YTP2 | 4.0 | 2021-05-20T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol! Volume 4 | ｺﾋﾟｰﾗｲﾄなし | 2021-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_1A5XEZFTD200 | CNT_25G9F2KR4Q30 | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 6 | [] | Ossan Idol!, Volume 6 | Miroku Osaki is 36 years old, unemployed, and unhappy. Having been bullied in his childhood and even into his adult life, he became a shut-in after being unfairly laid off. For a long time, the only thing that brought him joy was online gaming. Then, he tried the popular "Let's Try Dancing!" karaoke style. It was addicting... and transformative! Inspired by his new hobby, Miroku decides to turn his life around. He begins singing karaoke and going to the gym, where he meets Yoichi, the director of an entertainment company who encourages Miroku to pursue his dreams. Miroku only wanted to be good at the game he loves, but when he accidentally uploads a clip of himself singing and dancing, it goes viral! Can he really become an idol, even at his age? Suddenly, it doesn't seem so impossible! | 01KGAER1E0SFKWGRE6T4MM1S60 | 6.0 | 2022-02-07T08:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol!, Volume 6 | 2022-02-23T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2JWK9JWTKT70 | CNT_0A2SNH6N0MZG | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 3 | [] | Ossan Idol! Volume 3 | Miroku Osaki is 36 years old, unemployed, and unhappy. Having been bullied in his childhood and even into his adult life, he became a shut-in after being unfairly laid off. For a long time, the only thing that brought him joy was online gaming. Then, he tried the popular idol game called "Let's Try Dancing!" It was addicting... and transformative! Inspired by the game, Miroku decides to turn his life around. He begins singing karaoke and going to the gym, where he meets Yoichi, the director of an entertainment company who encourages Miroku to pursue his dreams. Miroku only wanted to be good at the game he loves, but when he accidentally uploads a clip of himself singing and dancing, it goes completely viral! Can he really become an idol, even at his age?! Suddenly, it doesn't seem so impossible! | 01KG9FG7BA4FS5ZCN4PBCPKQ4X | 3.0 | 2021-05-20T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol! Volume 3 | ｺﾋﾟｰﾗｲﾄなし | 2021-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_2RG2GBT94740 | CNT_2C1GMR7E9HTG | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 2 | [] | Ossan Idol! Volume 2 | With the help of producer extraordinaire Kamo Lavender, three (almost) middle-aged men are about to take Japan by storm as a group of Ossan Idols! When Miroku (age 36) accidentally uploaded a video of himself singing and dancing, it quickly went viral. Inspired by his talent and immediate popularity, his friends Yoichi (age 40) and Shiju (age 40) teamed up with him to perform in a competition, where they were discovered by the famous producer himself. Now, the three suddenly have their own radio show, song lyrics, devoted fans, and a debut live performance in a prominent shopping district. Things are really starting to heat up for the unlikely idol group! | 01KG9FG34MF8FE038CP142NPW3 | 2.0 | 2021-05-20T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol! Volume 2 | ｺﾋﾟｰﾗｲﾄなし | 2021-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_32J7JG50BXWG | CNT_1S2J6DBBWH30 | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 5 | [] | Ossan Idol! Volume 5 | Much younger rivals have appeared before the ossan idols! MiYoShi have signed a commercial deal, and their popularity is on the rise! One day, an offer comes for the group to appear on a music TV show that's a big hit nationwide! There, they meet the idol group TENKA, a super popular idol group of guys in their teens. For some reason, Kira, the most popular idol in the group, views Miroku as his enemy! Things are getting fired up in this fifth volume, which includes an original light novel chapter from the series creator, Mochiko Mochida! | 01KG9FRT4CGCGV4SBW28F5V1V8 | 5.0 | 2021-08-10T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol! Volume 5 | ｺﾋﾟｰﾗｲﾄなし | 2021-08-16T07:00:00.000Z | 0 | 0 | |||||
| PRD_3CQ8Q8DNNVQG | CNT_3AD2T8BGT5E0 | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 1 | [] | Ossan Idol! Volume 1 | Miroku Osaki is 36 years old, unemployed, and unhappy. Having been bullied in his childhood and even into his adult life, he became a shut-in after being unfairly laid off. For a long time, the only thing that brought him joy was online gaming. Then, he tried the popular "Let's Try Dancing!" karaoke style. It was addicting... and transformative! Inspired by his new hobby, Miroku decides to turn his life around. He begins singing karaoke and going to the gym, where he meets Yoichi, the director of an entertainment company who encourages Miroku to pursue his dreams. Miroku only wanted to be good at the game he loves, but when he accidentally uploads a clip of himself singing and dancing, it goes viral! Can he really become an idol, even at his age? Suddenly, it doesn't seem so impossible! | 01KG9E86M30A8X1RRJ8T868PCZ | 1.0 | 2021-05-20T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol! Volume 1 | ｺﾋﾟｰﾗｲﾄなし | 2021-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_3DQPXHYXA0C0 | CNT_1D3YWQEGP0FG | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 7 | [] | Ossan Idol!, Volume 7 | Miroku lets loose during an overseas photoshoot. Will he and Fumi finally be able to...?! Things are going well for the ossan idol group MiYoShi. But a new job offer happens to involve them working as hosts! Former host Shiju should have the home advantage, but things are thrown into chaos when the men realize their customers... are crossdressing men! There's also a tantalizing photoshoot in the southern islands, overseas! Will the ossans' hearts burn passionately in the romantic mood? | 01KH3FAHGBZ1D2JKJG1D6YTQ3R | 7.0 | 2023-06-26T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol!, Volume 7 | 2023-06-27T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3XYXX62046ZG | CNT_3455MB7Z6GGG | Ossan Idol! CNT_09FN4PATQJBG | CNT_09FN4PATQJBG | 2 | 1 | 1 | Volume 8 | [] | Ossan Idol!, Volume 8 | Miroku Osaki is 36 years old, unemployed, and unhappy. Having been bullied in his childhood and even into his adult life, he became a shut-in after being unfairly laid off. For a long time, the only thing that brought him joy was online gaming. Then, he tried the popular "Let's Try Dancing!" karaoke style. It was addicting... and transformative! Inspired by his new hobby, Miroku decides to turn his life around. He begins singing karaoke and going to the gym, where he meets Yoichi, the director of an entertainment company who encourages Miroku to pursue his dreams. Miroku only wanted to be good at the game he loves, but when he accidentally uploads a clip of himself singing and dancing, it goes viral! Can he really become an idol, even at his age? Suddenly, it doesn't seem so impossible! | 01KGAT90G4JQMNPH5T9T3QB5VZ | 8.0 | 2023-11-17T08:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Ossan Idol!, Volume 8 | ©2021 | 2023-12-18T08: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);