database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_1JRJX5FNRMXG"

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_07SX3ZP3BS80	CNT_2NEWE7AZCMBG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 6	[]	Future Diary, 6	Yuno and Yukiteru have disappeared, causing worry among Yukiteru's friends at school. Wit the help of the police, Aru and the others find him in an old abandoned hotel, where he's being held prisoner! But things get worse when Yukiteru learns that the eighth diary holder is sending new attackers to destroy his diary...with a very special delivery method!	01K5FYN638DV2JC8PAPC4E60RK	6.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 6	(C) Sakae ESUNO 2008	2014-10-28T15:00:00.000Z
PRD_0R1PK5H1HE5G	CNT_37YMQX6AMSD0	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 4	[]	Future Diary, 4	Yukiteru gets a fresh start at a new school, only to find out that he's been joined by Hayasaka, a bully from his previous class. Yukiteru just can't get a break! That's how he feels, at least, until his new classmates stand up for him. Maybe Yukiteru can turn over a new leaf, forget about the Diary Games and enjoy a normal life... But will the Diary Games forget about Yukiteru? Not if the mysterious Diary Holder Tenth has anything to say about it!	01KKTXWMKF9CX3BHQ90PNJ71JQ	4.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 4	(C) Sakae ESUNO 2007	2014-10-28T15:00:00.000Z
PRD_19SBGHY2WFN0	CNT_1A1BNSSVW9YG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 1	[]	Future Diary, 1	Yukiteru is a lonely student whose only hobby is the daily diary he keeps on his cell phone. But Yukiteru has a secret that nobody knows about...his cellphone can tell the future! Now a vicious game of survival is about to begin among twelve future diaryholders - with the winner crowned god of the new world! Sakae Esuno's chilling shonen masterpiece is a relentless adventure that will have you questioning the boundaries of time and space - and hoping for the slightest glimmer of hope in a dark, desolate world that may look surprisingly familiar to all of us...	01K5FVG6B5TKVSPDMS10SW5A0E	1.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 1	(C) Sakae ESUNO 2006	2014-10-28T15:00:00.000Z
PRD_1CFT24R4REM0	CNT_3DBRNBE4B8ZG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 5	[]	Future Diary, 5	Thanks to Aru, Yukiteru and Yuno are set up on an unexpected date at a free "wedding trial" program. But Aru's scheme goes awry when Yukiteru and Yuno arrive at Yuno's house to find not corpses, but a giant hole in the ground. And if that wasn't weird enough, Yuno has tampered with her memory and forgotten that Yukiteru ever visited her. Her memory loss couldn't have come at a worse time, as they are both tricked into committing a crime so another Diary owner can track them. With the game stakes becoming deadlier than ever, has Yukiteru sent his last text?	01K5FYC19P2FRA8YJ8V2T4WEWW	5.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 5	(C) Sakae ESUNO 2008	2014-10-28T15:00:00.000Z
PRD_21DR2NZK7CV0	CNT_068N63DZQ6RG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 2	[]	Future Diary, 2	Yukiteru, Yuno, and Kurusu band together to prevent the battle of Future Diaries from getting out of hand. But when Yukiteru discovers a dark secret about Yuno that changes everything, will he still be able to trust her? Now wary of his new "friends," Yukiteru joins them on an investigation of a priestess from a temple who seems to have mysterious powers. As new Diary owners show up, each with their own ambitions, who, in this dark and desolate world, is friend and who is foe?	01KKTXWJ1WH0566MEBENN17K7M	2.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 2	(C) Sakae ESUNO 2006	2014-10-28T15:00:00.000Z
PRD_30EQS0863K20	CNT_2W6T2RGBAY1G	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 3	[]	Future Diary, 3	In the next volume of diary holders and deceit, even the most seemingly innocent can't be trusted. Yukiteru, Yuno, and Kurusu have been attacked by Tsubaki, another diary holder and Priestess, at her temple. Yuno manages to open up an escape route, but they run out of energy and are captured. As Tsubaki orders Yuno to be killed, nothing is less certain for our trio than the one thing they had learned to trust - the future.	01K5FYR0X1SM21Z3DSJN4F9SWG	3.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 3	(C) Sakae ESUNO 2007	2014-10-28T15:00:00.000Z
PRD_31W2SX9GXBM0	CNT_1A47248X65ZG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 8	[]	Future Diary, 8	Determined to bring his deadbeat father to justice for the death of his mother, Yukiteru tracks down his father only to meet with a sickening surprise! Meanwhile, the Eleventh diary owner finally makes his move to seize Eighth's special server diary for his own purposes. Yukiteru's plan to strike back and take both down at once is foiled when Aru Akise returns with a shocking piece of information about Yuno's true identity...	01K5GA4RVM7M7M7NQXM7YSMC18	8.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 8	(C) Sakae ESUNO 2008	2015-01-30T15:00:00.000Z
PRD_3K5HMYMP10H0	CNT_39G601VK7AJG	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 9	[]	Future Diary, 9	In a stunning move, Eleventh, none other than the mayor of Sakurami, arms every cititzen with their own future diaries! But in the midst of this dramatic turnabout, Yuki and Yuno disappear, leaving Minene Uyru, Ninth, alone in her efforts to ake Eleventh down. That is, until officer Nishijima decides that he wants to be on Ninth's side permanently...a promise he backs up with a wedding ring! Will Ninth accept his amourous offer...?	01K5GA5C3YWE28M8TX7JF1G24P	9.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 9	(C) Sakae ESUNO 2009	2015-01-30T15:00:00.000Z
PRD_3KQTM1QBQ8Z0	CNT_0VJS0M31B34G	Future Diary CNT_1JRJX5FNRMXG	CNT_1JRJX5FNRMXG	2	1	1	Volume 7	[]	Future Diary, 7	It's a battle of love between two couples - the madly smitten Marco and Ai, and dysfunctional Yukiteru and Yuno. The power of true love seems to overpower all as Marco and Ai continually foil Yukiteru and Yuno's best plans. Just when things couldn't get any more confusing for Yuki, his long-absent father returns, promising to remarry his mother! But his real goal is far more sinister, and Yukiteru's life is in serious danger...	01KKTXW0BPHZXSKQGXCSPV1CV9	7.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Future Diary, 7	(C) Sakae ESUNO 2008	2014-10-28T15: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);