products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_2PFTSSVAKR80"
This data as json, CSV (advanced)
Suggested facets: listed_at, 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_0B8SFM46XV5G | CNT_1ZSWYKH51B60 | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 6 | [] | Usotoki Rhetoric Volume 6 | The first year of Showa, 1926. Kanoko, a girl who can hear lies, meets an impoverished detective, Iwai Soma. Since then, she's been at his side. Until one day, he is framed for a murder, and put in jail! Will his plucky assistant Kanoko be able to save him in time? | 01KGAZGEE4GNECT95NT4ATX1VE | 6.0 | 2024-02-20T08:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 6 | 2024-03-12T07:00:00.000Z | 0 | 0 | ||||||
| PRD_13SWF9Z11FWG | CNT_27FAM32TMHRG | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 2 | [] | Usotoki Rhetoric Volume 2 | Soma and Kanoko get wrapped up in a fight between the waitress Lily and her partner, Kanji, and find themselves infiltrating a haunted house, chasing after the key to a murder case! | 01KGB7CHWYQCKYEERYH9DT0V9H | 2.0 | 2023-04-13T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 2 | 2023-04-14T07:00:00.000Z | 0 | 0 | ||||||
| PRD_16ECTWSBDE3G | CNT_06S7MEQ33GSG | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 3 | [] | Usotoki Rhetoric Volume 3 | Poverty-ridden detective Soma and his assistant Kanoko are on the run in the dead of night, and their destination? A house where a doll was murdered! | 01KGB7CG2RQ8SM72ZKYKR8ZB0W | 3.0 | 2023-04-13T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 3 | 2023-06-13T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1ZBDXPXZ50XG | CNT_044XMHCJ9JZG | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 1 | [] | Usotoki Rhetoric Volume 1 | It is 1926, the first year of the Showa era. Urabe Kanoko has left her hometown after it turns against her for having the ability to hear lies when spoken. She collapses from hunger after arriving in a town called Tsukumoya, where she meets a poverty-stricken detective named Iwai Soma. Is this fate? Or something more? | 01KGB6QVBP24S983WC9DSAPYAV | 1.0 | 2023-04-13T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 1 | 2023-04-14T07:00:00.000Z | 0 | 0 | ||||||
| PRD_253PNBN1ZWP0 | CNT_0W46FAP0RVPG | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 5 | [] | Usotoki Rhetoric Volume 5 | It is 1926, the first year of the Showa era. Kanoko, a girl who can hear lies, and impoverished but cunning detective Soma Iwai venture back to Kanoko's hometown. Kanoko, who was chased out of her town for her ability, now comes face-to-face with her mother. | 01KGAY6SEYT2KDAEP2DE74GQZ7 | 5.0 | 2024-02-20T08:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 5 | 2024-02-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2KKDACSG866G | CNT_0BP1VF7PXH5G | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 4 | [] | Usotoki Rhetoric Volume 4 | It is 1926, the first year of the Showa era. Kanoko, a girlwho can hear lies, and impoverished but cunning detectiveSoma Iwai now face a murder on a solitary island.Meanwhile, Chiyo Fujishima, a big fan of detectives, hasher own case to solve. This volume also includes a specialshort with a retro-modern back-alley tale of mystery! | 01KG9P107AP1E7JKCFW2FDHGFY | 4.0 | 2023-08-10T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 4 | 2023-09-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_34NTVSZJXKS0 | CNT_0QCVC4PGYYH0 | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 7 | [] | Usotoki Rhetoric Volume 7 | Kanoko and Soma spend what little cash they have on a train ticket. From Tsukumoya Town, they travel to where Soma's older brother Atsushi lives. With Kanoko's power to hear lies, they aim to uncover clues as to why Atsushi set that trap for his younger brother Soma. But along the way, they end up hearing a lie about a possible affair happening between Atsushi and his wife?! | 01KH3P9RXCWVGBHGWHTQ5DYS6Z | 7.0 | 2024-04-03T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 7 | 2024-05-28T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3B2CMM0T2Y10 | CNT_046TCKXQCP90 | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 10 | [] | Usotoki Rhetoric Volume 10 | Soma, who pours his heart and soul into pursuing Kanoko after she was kidnapped by Shiro. Kanoko, who see the depths of Soma's warmth and kindness towards Shiro in spite of everything. At last reunited, Kanoko and Soma's feelings for each other have only gotten stronger while they were apart. The closing curtain, wound with deception and lies that only Kanoko can pierce through, is set to finally fall on this beloved historical mystery series. | 01KGBK8MG680VZEN276PVCZ7XP | 10.0 | 2025-01-20T08:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 10 | 2025-02-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3D2DQGCJ8F20 | CNT_1WRTG387XK3G | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 8 | [] | Usotoki Rhetoric Volume 8 | When a beautiful, mysterious woman appears on poverty-ridden detective Iwai Soma's doorstep and decides to stay with them, she asks Kanoko a disturbing question: "What will you do if Mr. Iwai gets married?" | 01KGBEZDN3C3D2DC1PZCADP07B | 8.0 | 2024-09-30T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 8 | 2024-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3EDX4XK8C030 | CNT_3XEDGHKZEM2G | Usotoki Rhetoric CNT_2PFTSSVAKR80 | CNT_2PFTSSVAKR80 | 2 | 1 | 1 | Volume 9 | [] | Usotoki Rhetoric Volume 9 | Kanoko has realized she's in love with Iwai Soma. She becomes conscious of this as they work yet another case. While lost in her fluffy feelings she is kidnapped by Shiro, the notorious criminal they've had to deal with all this time. | 01KGBEZFN31BVRTDPDNQXP7JP8 | 9.0 | 2024-09-30T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1QGP9M2EHTBG | Usotoki Rhetoric Volume 9 | 2024-10-15T07: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);