products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_395J0122FDM0"
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_035DT20H95GG | CNT_34TB5FAYV0MG | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 7 | [] | Hinowa ga CRUSH!, Vol. 7 | Having vowed to take up the mantle of kingship, Hinowa needs an expert strategist—but her number one candidate, the wise sage Rugyou, is more interested in living as an author! Meanwhile, Akame sets out on her own in search of an old friend, not realizing she may uncover more than she bargained for. Will these encounters and farewells bode well or ill…? | 01KGB2QNR8SGZZGNK84CXHX568 | 7.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Hinowa ga CRUSH!, Vol. 7 | 2023-02-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_05WPRFQXYAQ0 | CNT_2YB35X8C107G | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 6 | [] | Hinowa ga CRUSH!, Vol. 6 | <P>The Soukai Nation is cornered as Nagisa Castle falls, and King Zuou seeks to capture Princess Rinzu and make her his newest wife. Akame, regaining her strength, attempts to turn it around by taking Zuou’s head, but an unexpected face awaits her…! In their hour of greatest despair, can Hinowa and her friends keep the light of hope alive ?</P> | 01KGAEZF45JFHVKD4E97YC4GRS | 6.0 | 2022-03-30T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Hinowa ga CRUSH!, Vol. 6 | 2022-04-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_090CZY4ZA73G | CNT_0HJ2QYDXY1J0 | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 5 | [] | Hinowa ga CRUSH!, Vol. 5 | Hisame, after climbing in rank to general and then commander, has finally achieved his greatest wish-the hand of his beloved Princess Rinzu. But even as they celebrate in the Soukai Nation, Tenrou’s mighty armies are on the move, led by King Zuou himself. With Shiranui Fortress falling to enemies within, is there anything left to stop the Tenrou Nation’s Ten Stars from sacking all of Soukai? As heads fly left and right, Hinowa and her friends prepare for a desperate battle…! | 01KG9F61R0QZ12XHX8G0RYX6HC | 5.0 | 2021-04-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Hinowa ga CRUSH!, Vol. 5 | 2021-06-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0W6NZGQ8RB3G | CNT_1RGJ8P41EG00 | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 4 | [] | Hinowa ga CRUSH!, Vol. 4 | The Tenrou Nation’s Ten Stars have gathered, and the territory-hungry nation is keen to advance on Soukai. As armies begin to move, those in Soukai have other concerns—the idolized Princess Rinzu is set to take a groom! Hisame is determined to have the princess as his wife, but first he must win her hand in a trial determined by the king of Soukai…Will Hisame succeed and prove himself worthy, or will the dirty tactics of the other bridegroom challengers ruin his chance at love? | 01KG9CX6YBR9GS221M0H5ZSVFQ | 4.0 | 2020-07-31T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Hinowa ga CRUSH!, Vol. 4 | 2020-08-18T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1YSM8CZP4MAG | CNT_25K1PAXF6GB0 | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 2 | [] | Hinowa ga CRUSH!, Vol. 2 | In the midst of her first battle, Hinowa challenges Yomihime, the woman who killed her mother. After a fierce standoff, Hinowa and her friends barely scrape by, and that’s only with the help of Akame. But when a new and crazed general from the Tenrou Nation launches an attack, will they be able to survive the merciless battlefield once again…? | 01KGA5QA498A6J1KC8MP7N9MHZ | 2.0 | 2019-05-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Hinowa ga CRUSH!, Vol. 2 | 2019-05-21T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1ZE7DN0AYYPG | CNT_1SMY90DC5FN0 | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 3 | [] | Hinowa ga CRUSH!, Vol. 3 | The unhinged Commander of Tenrou Nation, Kyoukotsu, has laid siege to Shiranui Fortress. Hinowa and friends are on high alert, determined to hold the fortress no matter what comes their way. But what Kyoukotsu schemes is beyond their comprehension, and it will take all their combined efforts to impede the infamous Commander. Meanwhile, plans are stirring in the Tenrou Nation, and an unexpected face makes an appearance... | 01KG9BHB6E68HADQ5PQC8YRRF2 | 3.0 | 2019-12-17T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Hinowa ga CRUSH!, Vol. 3 | 2020-02-11T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2Q2R9XWMADF0 | CNT_13DG1FZA9JB0 | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 1 | [] | Hinowa ga CRUSH!, Vol. 1 | On the island of Wakoku, the civil war offers anyone the chance of becoming a hero -- from fishing women to bastard children, any can make a name for themselves by working through the rigorous ranks of the army. Hinowa, a young woman with extraordinary skills, is determined to do just that, but soon learns things may not always go to plan...More than ten years after a disastrous battle, the war is still ongoing, and a girl with black hair and black markings washes up on shore... From the writer behind Akame ga KILL! comes a brand new series! | 01KGA3QKV6TWBW3KEGC6YSSNG5 | 1.0 | 2018-09-25T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Hinowa ga CRUSH!, Vol. 1 | 2018-09-25T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3HAJ34X97TV0 | CNT_36BVPNT6Z9GG | Hinowa ga CRUSH! CNT_395J0122FDM0 | CNT_395J0122FDM0 | 2 | 1 | 1 | Volume 8 | [] | Hinowa ga CRUSH!, Vol. 8 | Hinowa is determined to conquer the Tsutsuji Nation, but fierce enemies stand in her way. As she and the others follow Rugyou’s strategy of capturing the hearts of the nation’s people and winning allies from within, the Tsutsujiking, Jinkai, is making plans of his own—to wed Hinowa to his son…!! Catch the conclusion to Hinowa ga CRUSH! in this final volume! | 01KGB6GPS9WESZTVE3W0VQSPZ4 | 8.0 | 2023-05-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Hinowa ga CRUSH!, Vol. 8 | 2023-07-18T00: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);