database: products: 14 rows where series_id = "CNT

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

14 rows where series_id = "CNT_3HH35SX54060"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_06SMGVEMA7Z0	CNT_3QSQ64KQMV1G	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 7	[]	Back When You Called Us Devils 7	The bond between brother and sister, something they thought was stronger than anything else in their lives, is now straining, fraying, and threatening to rot away. To escape his staggering responsibility, Aoshi had no recourse but women and drink. As Yusuke Saito watches him destroy himself, another pursuer appears to reveal his own past crimes. Now multiple cases are intertwining with each other...and only the truth remains hidden, frozen in time.	01KG9HCN3JER2X2WS6N7NGX318	7.0	2021-11-04T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 7	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-11-23T08:00:00.000Z
PRD_0DT167RG2KH0	CNT_1WJB8VA8FXDG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 3	[]	Back When You Called Us Devils 3	In order to protect his closest relations from those seeking revenge against him, Yusuke puts on the mask of a devil once more...even though there's no longer a single remnant of the devil in him. Stricken by despair, he's taken by a girl back to a seaside town...and there, he finds what he was looking for. Now the memories come flowing back, more vividly than ever...	01KG9FQ02R273KD9JQBX16EWDX	3.0	2021-07-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 3	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-07-27T07:00:00.000Z
PRD_0J02GYD0SRG0	CNT_0N7JN7YGBWK0	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 8	[]	Back When You Called Us Devils 8	Now the police are on the move...and Aoshi is taking the heat for murdering his stepfather. The detectives hit the streets in pursuit of Yusuke, searching for the truth behind the dead couple in the dam--but then a malicious hand approaches Onda, the reporter. Soon, an ending there'll be no recovering from awaits them all, as the evil in people's hearts expands beyond all control...	01KGADY6QGHKPH8HGDWHSNWPCB	8.0	2021-12-15T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 8	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-12-28T08:00:00.000Z
PRD_12NN94687Q4G	CNT_3FKANS74AWFG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 9	[]	Back When You Called Us Devils 9	Nobody needs to be unhappy any longer. Striving to live up to his credo, Detective Shibasaki makes contact with Yusuke, a certain theory in his mind. Soon he learns the truth behind the two bodies found by the dam. As the story heads toward ultimate destruction, another life finds itself reaching its wretched, vain end...as another so-called "devil" enters the scene.	01KGAEDPYYW10GKQ0PZX4BJEJE	9.0	2022-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 9	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-01-25T08:00:00.000Z
PRD_1BCNQ2CYCYE0	CNT_35K1CMQ3K1FG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 13	[]	Back When You Called Us Devils 13	Twenty years on from the nightmare that visited the Morikawa family, a woman appears at a certain seaside town. She's been traveling around, gathering information about Yusuke Saito's story—and she's introducing herself as Yusuke's daughter. Now Sumire Okazaki has reached out to Akari Ichinose, telling her about a five-year gap in Yusuke's life that nobody knows about. But who really was the devil this whole time, and what was the crime committed?	01KGAGKEPEEM1NEZQ385HE9BCN	13.0	2022-05-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 13	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-05-24T07:00:00.000Z
PRD_1G26XH9NP22G	CNT_05JTT0ZBP4T0	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 14	[]	Back When You Called Us Devils 14	The crimes of the past spread across town, eating into everyone's peaceful lives. The townspeople are transformed, disfigured by justice run amok. But amid the unfair persecution, Yusuke Saito continues facing up to his sins. And as Sumire Okazaki reveals the final pieces of the puzzle, one question remains: Who was the real devil all along? The modern tale of crime and punishment reaches its suspenseful end!	01KGAHN82PWRC0CV6MJRHBWQVE	14.0	2022-06-09T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 14	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-06-28T07:00:00.000Z
PRD_1PS0N4ZERVW0	CNT_2YM11BSC2ZCG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 6	[]	Back When You Called Us Devils 6	In a mountainside village, Aoshi Fujimori lives with his sisters as they cower at the violence of their stepfather. To protect their lives and futures, the three of them begin living with a man they know nothing about. Their strange arrangement gives them solace for now...but in time, small cracks begin to form. Ten years after he disappeared, Yusuke Saito is still alive.	01KG9H7BBM2RV27N2KSM1QW6KB	6.0	2021-10-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 6	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-10-26T07:00:00.000Z
PRD_1R6DWMWD3M1G	CNT_3ZPP54YJ3S2G	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 10	[]	Back When You Called Us Devils 10	The truth finally reveals itself...and it's an ugly sight. But the horrible tragedy is far from over. As the twin devils attempt to outfox each other, the past comes back to life in the form of Akari Ichinose. With her on the scene, events slowly but surely roll towards their thrilling climax.	01KGAEQKJ6574E9F3HB90TZCJJ	10.0	2022-02-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 10	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-02-22T08:00:00.000Z
PRD_1ZHJCWE3D63G	CNT_0B5214NGZ0J0	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 1	[]	Back When You Called Us Devils 1	Yusuke Saito is a normal high school kid...well, normal enough, except that he can't remember anything from his life except the last six months. But when he starts to get confronted by people who insist they're from his past, who allege that he did horrible things to them...suddenly Yusuke's missing memories become crucial to remember. Otherwise, the skeletons in his closet may just make him a skeleton, too...	01KG9E6JQ6ZQ0SZX4BBMF000NH	1.0	2021-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 1	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-05-25T07:00:00.000Z
PRD_2Z7AGJ6PP5M0	CNT_2ZB0J1MKDS4G	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 4	[]	Back When You Called Us Devils 4	Tracing the remaining fragments of his memory, Yusuke visits the seaside town he lived in with Akari Ichinose, the girl he hurt so badly. Then everything is revealed--his life with Akari, his memories of murder, and the facts behind his disappearance. The truth weighs heavily upon Yusuke, who thought he was detached from his own past...but there is no escaping the crimes he committed.	01KG9GJXT39CBBHRZ2EN3AR3AY	4.0	2021-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 4	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-08-24T07:00:00.000Z
PRD_3C6NF4BMS440	CNT_0CTZDS077ETG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 2	[]	Back When You Called Us Devils 2	Yusuke Saito, with his former partner in crime Aizawa, has begun to delve into his own memories. It's not long before the past is revealed to him—a past where he treated people like toys, thrilling to every human life he tormented. And at the end of all this nauseating behavior, Yusuke discovers the truth...and a dead body.	01KG9FK563ENMQ3NZ6FP4BXA3T	2.0	2021-06-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 2	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-06-22T07:00:00.000Z
PRD_3DG4P6WP1A2G	CNT_1XFM0E57EGB0	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 12	[]	Back When You Called Us Devils 12	All things must come to an end--even a crime as cruelly twisted and tangled as this one; even a tragedy that continues to draw more and more people in...and even a soul-crushing life. That night, in a snowy ruin, Aoshi Fujimori makes his move as the devils around him bare their fangs. When the deceiving is done, who will emerge alive? Who is trusted, who is betrayed...and who will be the one that kills me?	01KGAG465R5KF18WP3909MXH2N	12.0	2022-04-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 12	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-04-26T07:00:00.000Z
PRD_3N709BP4YZQG	CNT_1EVF1Q8T4JR0	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 5	[]	Back When You Called Us Devils 5	On a roof overlooking the city lights, Yusuke Saito—his memories now fully revived—confronts Akari Ichinose. She's tormented by a curse that echoes deep within the night...and death seems like the most attractive way to escape it. The couple spent years loving, and killing, each other—perhaps this end was fated all along. But still, despite it all, they manage to find value in their lives...	01KG9GY79V98WSQ3P4C8MSF7MF	5.0	2021-09-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 5	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2021-09-28T07:00:00.000Z
PRD_3R7HAYQ2WKA0	CNT_2XWADEVJYSWG	Back When You Called Us Devils CNT_3HH35SX54060	CNT_3HH35SX54060	2	1	1	Volume 11	[]	Back When You Called Us Devils 11	The snow was too impatient to wait for the end to come. In pursuit of Onda, Yusuke has returned to Tokyo for the first time in ten years...only to be battered by the weight of the truth. Between Aizawa's scheming, his mother's betrayal, an unintended reunion with Tamaki, and Ichinose's struggles, the devil does his business behind the scenes. Faced with stark betrayals and his own wounded mind and body, there's no more wiping away the fatigue. But there's people who need to be saved.	01KGAEWYEQ3V050A9BCWH0B9WA	11.0	2022-03-03T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Back When You Called Us Devils 11	Back When You Called Us Devils Takashi Sano/Kodansha Ltd.	2022-03-22T07:00:00.000Z

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);