products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_1Z5KZZZZM92G"
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_03DQ9WYCWJZ0 | CNT_1X8VRVWR3FFG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 1 | [] | No Longer Heroine, Vol. 1 | Enter: Hatori Matsuzaki, the heroine of this love story. And her hero? Rita Terasaka, an infamous hottie with a (hidden) heart of gold. Sure, he might be a notorious playboy, but she’s got nothing to worry about—after all, he’s never serious about any of his paramours. Besides, she knows him better, has been by his side longer, and loves him so much more than anyone else possibly could. Okay, so she might not be dating him just this second, but what’s the rush when destiny is on her side…right? | 01KGAK0PH07BW092TSPGPRQ5C3 | 1.0 | 2022-09-01T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 1 | 2022-09-13T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0G5JX1X65XRG | CNT_179B6ZY51QQG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 6 | [] | No Longer Heroine, Vol. 6 | Hatori’s finally gotten the happiness she’d been longing for! Though it’s not with the guy she thought it’d be with, all’s well that ends well, right? Having come to terms with his own feelings, Rita resolves to follow his heart-but what does that mean for Hatori? | 01KGAT22BJ4FF90SVEEZSBQXQA | 6.0 | 2023-10-30T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 6 | 2024-04-16T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0H7W8QH4FQJ0 | CNT_0Z0QJHNRP2A0 | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 2 | [] | No Longer Heroine, Vol. 2 | Hatori may still have a long way to go until she cements her spot as Rita’s heroine, but now that she’s finally confessed (and he’s agreed to stop avoiding her), she’s back on the playing field! ...Except, hello, who’s the hot guy who looks exactly like her favorite pop idol? And more importantly, what does he think he’s doing, brazenly hitting on a girl right in front of her potential boyfriend-to-be?! | 01KGB2Q6680TR8ES4AMD3GH837 | 2.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 2 | 2023-01-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0J8SKZAY8BWG | CNT_023BKC8T1DQG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 9 | [] | No Longer Heroine, Vol. 9 | Hatori’s furious when she finds out that Runa and Hiromitsu kissed, and that he even tried to hide it from her! To top it off, she sees the two together again right after she’s decided to let it go, and things take a turn for the worse. With Hatori and Hiromitsu’s relationship in dire straits, Rita may have a fighting chance—except his ex-girlfriend Adachi is back! She’s nothing like the upstanding, earnest girl she was before, and Rita can’t help but be concerned by her drastic change of heart… | 01KGBG1D39PQVDD19PZRR8E9WG | 9.0 | 2024-10-23T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | No Longer Heroine, Vol. 9 | 2025-06-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_140M83ZPZ9E0 | CNT_3FGNM9QW1PG0 | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 3 | [] | No Longer Heroine, Vol. 3 | Hatori decides to follow her rival-in-love’s example and become a kind and proper heroine, and Hiromitsu’s cousin Moe has offered her services to help Hatori get the guy…Well, that was the plan, at least, until Moe also falls for Rita’s charms! With Moe using every weapon in her arsenal to seduce Rita, Hatori must decide whether to take her cues from the ever-dignified Adachi or to follow her instincts and cut Moe down to size! | 01KGB4GF8Q41PR21PMYDVMEXTQ | 3.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 3 | 2023-06-20T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1VPD4ZF38AK0 | CNT_3YPTRFB85SV0 | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 7 | [] | No Longer Heroine, Vol. 7 | Hiromitsu unexpectedly gives Hatori handmade gloves for Christmas! Hatori realizes what a mess she’s made of their day together, but now she’s even more resolved—Hiromitsu is the one she wants. Luckily, Moe suggests they all go snowboarding over winter break, giving Hatori the perfect chance to push Nakajima and Rita together. After all, it’s totally fine with her if they date, and that way Rita’s out of the picture—but can Hatori handle a trip alongside her boyfriend and her old, longtime crush...? | 01KG9PNXEE03CASYX5ACZ1A3CE | 7.0 | 2024-01-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 7 | 2024-07-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1YKJJEECZDDG | CNT_20XAVJM5HHFG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 8 | [] | No Longer Heroine, Vol. 8 | Refusing to give up on Hatori, Rita’s decided he’s fine being the bad guy—and goes to show it by forcibly kissing her! Hiromitsu arrives just in time to confront him, but the conflict only deepens. Hatori can’t get what happened out of her head, and the whole situation has thrown Hiromitsu off his game. Hatori resolves to cut Rita out of her life for good, but it won’t be easy when he’s dead set on staying! And what about that cute girl working with Hiromitsu…? | 01KGBBVRWJB0RMK64RD1HA591N | 8.0 | 2024-07-12T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | No Longer Heroine, Vol. 8 | 2024-12-10T08:00:00.000Z | 0 | 0 | ||||||
| PRD_35MCBY7T8FSG | CNT_0PSQFDZFEHKG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 4 | [] | No Longer Heroine, Vol. 4 | Hatori is flying high after Rita kisses her at the fireworks show, and even Adachi’s early return can’t bring her down—after all, Rita seems to be seriously torn, which surely means that Hatori has a fighting chance! But when the saintlike Adachi catches wind of their affair and is forced to confront the possibility of losing Rita for good, will she be able to practice what she preached and let him go with a smile? | 01KGB6D1JPJ7C7R7JEJB5SJY70 | 4.0 | 2023-04-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 4 | 2023-09-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3FYW69G6NQW0 | CNT_1MJRBC5E1HZ0 | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 5 | [] | No Longer Heroine, Vol. 5 | Hatori finally has a bona fide boyfriend, and it’s like the heavens are rewarding her for all the pain they put her through! Fun? Check. Hot? Double-check. Loves her and only her? She’s still wor king on that one, but now that Hiromitsu is actually committed to this relationship, it’s only a matter of time. Plus, everyone around her is super-happy for her—everyone, that is, except Rita. Confronted by the reality that Hatori is moving on, Rita is forced to take a good, hard look at his own feelings—whether he’s ready to admit them or not! | 01KH3G5H3P8V2Y53N56JRJEHF0 | 5.0 | 2023-08-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | No Longer Heroine, Vol. 5 | 2024-01-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3XYMN777H640 | CNT_2GXBHTKT9ABG | No Longer Heroine CNT_1Z5KZZZZM92G | CNT_1Z5KZZZZM92G | 2 | 1 | 1 | Volume 10 | [] | No Longer Heroine, Vol. 10 | Is it finally Hatori’s time to shine as a true heroine?!After all the drama over Runa, Hatori and Hiromitsu have split up—which means Rita should be over the moon! But since he still blames himself for what happened to Adachi, he won’t make a move. And so, the once-blissful Hatori remains totally alone…until Hiromitsu visits her to ask for a second chance! Will he be the prince to give her the happily ever after she’s been dreaming of, or will Hatori’s heart lead her elsewhere? | 01KGBN079H3GNK559PG6FV1VKE | 10.0 | 2025-04-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | No Longer Heroine, Vol. 10 | 2025-09-23T07: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);