products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where series_id = "CNT_026TA5GZ57P0"
This data as json, CSV (advanced)
Suggested facets: description_short, 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_0RVVN0DHQBQ0 | CNT_0J2A943EQFK0 | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 7 | [] | Until Your Bones Rot Volume 7 | The truth comes to light at last. One after another, the lies come undone, laying bare the core of the mystery in their tatters. To kill another is an unbearable sin--and thus this tale of murder draws to a close. Though my sins should never be repaid, though my spirit should groan with every breath I draw, I would bear it all for you. So please, listen to my only plea. Stay with me. Now and forevermore... | 01KGA4Z4DVRT1J04JP2FP86H7V | 7.0 | 2018-07-20T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 7 | (C) Yae Utsumi / Kodansha Ltd. | 2018-07-24T07:00:00.000Z | 0 | 0 | |||||
| PRD_0SX1869PVAQG | CNT_20Y4XTB2B5GG | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 6 | [] | Until Your Bones Rot Volume 6 | The blackmailer they chased already dead, freedom at last from the lady of the park provides little solace as the four friends find themselves on thin ice. Sealing up darkness with darkness, painting over lies with lies. Now one overlooked reaches out for their tangled web. They cannot efface the crime, and so they can at least finish this with their own hands… Holding the light of the truth against the dark of the culprit, in place of an apology, I will find you. | The dead cannot speak. | 01KGA47C30WNDYKHMD9HDZZXFP | 6.0 | 2018-04-23T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 6 | (C) Yae Utsumi / Kodansha Ltd. | 2018-05-01T07:00:00.000Z | 0 | 0 | ||||
| PRD_0TFSC39G0FX0 | CNT_0NJ372JPVQ0G | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 3 | [] | Until Your Bones Rot Volume 3 | They cut up the headless body. If only it were someone else. If only they didn't know his name. Pushed to their psychological limits, the friends return to the cave where everything began, and peer into each other's faces. Among them is a liar. A nighttime disappearance. A journey to the sea. A life-risking scheme. Just when they think they can breathe again, their hard-won peace is torn apart. | 01KGA18F7YN5XRB7NAYSP2QWCJ | 3.0 | 2017-12-05T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 3 | (C) Yae Utsumi / Kodansha Ltd. | 2017-12-19T08:00:00.000Z | 0 | 0 | |||||
| PRD_1HCG8RKHTDSG | CNT_2CYHPFDC1PMG | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 1 | [] | Until Your Bones Rot Volume 1 | The summer they were eleven, they killed a man and buried his body in a cave. Since then, every year, one summer night has marked a ritual: a ritual never to forget, and never to betray. Five years have passed. Their sixteenth summer. The body, now a skeleton. Unraveled lies. A faceless blackmailer. The phone rings, and a life is torn apart. The bones, like their crime: never rotting, never fading away. Now, a living hell begins. | 01KG9VFA4MEAM96DCWG4A5NJ20 | 1.0 | 2017-10-16T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 1 | (C) Yae Utsumi / Kodansha Ltd. | 2017-10-17T07:00:00.000Z | 0 | 0 | |||||
| PRD_2QMCCD78A1CG | CNT_2FH4TN6ZDDBG | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 5 | [] | Until Your Bones Rot Volume 5 | A crime, and a deepening mystery: the answer becomes apparent as the four friends line up the pieces of the truth. They have lost time, and a lot of it. Beneath the moon's light, they finally see the crime incarnate - but the road back has been buried beneath a flurry of ever more mistakes. Dark voices begin ringing in the depths of the night. Resentment. Curses. Laments. Together, these voices announce the end. At the end of a long road lined with sacrifices, will they finally encounter the source of it all...? | 01KGA3AP1GHTJB283VM81E7D9H | 5.0 | 2018-03-19T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 5 | (C) Yae Utsumi / Kodansha Ltd. | 2018-03-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_2S4RN2J6J9FG | CNT_2036RPMQR58G | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 4 | [] | Until Your Bones Rot Volume 4 | Betrayed by what they had believed in, they commit one new crime after the other. The shards of the truth that begin to appear cut into their skin, deeper than anything before....And anyway... when did this case begin? | 01KGA2JK881RNP6JH3PJXEVDBD | 4.0 | 2018-01-22T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 4 | (C) Yae Utsumi / Kodansha Ltd. | 2018-01-30T08:00:00.000Z | 0 | 0 | |||||
| PRD_2Z9EZR8FBDMG | CNT_2BRSC15BQP9G | Until Your Bones Rot CNT_026TA5GZ57P0 | CNT_026TA5GZ57P0 | 2 | 1 | 1 | Volume 2 | [] | Until Your Bones Rot Volume 2 | Five friends killed a man and buried the body. Five years later, the body is stolen. The thief: unknown. His hostage: a corpse. There is nowhere to run, only the mystery blackmailer's cruel, repulsive “instructions.” And so occurs a tragedy, under the sun, in the woods. The indelible scent of blood. Friendship and peaceful days, gone. Exposed skin and stolen dignity. What is crime? And what is punishment? Unable to answer, they plunge, head first, through the gates of hell. | 01KG9VW614TKCGFMQNB86Y6XNF | 2.0 | 2017-11-13T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Until Your Bones Rot Volume 2 | (C) Yae Utsumi / Kodansha Ltd. | 2017-11-20T15: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);