database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_2AYCDTSDYZ30"

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	on_sale_at
PRD_05TXQ4942YB0	CNT_0RWVW1Y1SH80	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 2	[]	The Betrayal Knows My Name, Vol. 2	Welcomed into the arms of the Giou clan and the Zweilt, Yuki reaches out to his comrades even as he is drawn into their war with the darkness. But the demonic Duras continue to spread their malevolence around Yuki, and the members of his new family are not impervious either, as one of their own vanishes without a trace and yet another is cornered by a sudden ambush. In the Zweilt, Yuki may well have found the long-sought-after place he belongs, but the enemy seems intent on stealing it out of his grasp forever. And when the shadowy figure of "Reiga," the nemesis of the Giou, finally steps into the light, will Yuki find himself utterly alone, crushed by the weight of the truth?	01KG982SCPMP4JH0AANT2JT78P	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 2	2016-06-30T15:00:00.000Z
PRD_0Y5WQCV15FBG	CNT_3JDNNNZ43J8G	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 5	[]	The Betrayal Knows My Name, Vol. 5	Though the Zweilt are together at last, the calm before the inevitable storm of battle lingers. With no sign of activity from the camp of their sworn enemy, Reiga, Yuki and his allies are beguiled into a sense of peace. But even the distraction provided by a retreat to the Hidden Springs of the Giou to rest weary hearts and souls will not prepare Yuki for Sairi's revelations about the brave but terrible end met by the Light of God through the ages...And when Takashiro is called in to investigate a pair of suspicious deaths, the winds of war begin to pick up in a frenzy...	01KG9823MVBNTRG7R6PDZRSM39	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 5	2016-06-30T15:00:00.000Z
PRD_16A27VBS19MG	CNT_3XYRZX87ZKY0	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 1	[]	The Betrayal Knows My Name, Vol. 1	Abandoned as a baby and raised in an orphanage, the kind-hearted high-schooler Yuki Sakuragi is driven by a need to find the reason for his existence. Plagued by mysterious dreams, Yuki also possesses the strange ability to read the deepest, darkest thoughts of anyone he touches. As both the dreams and his powers intensify, there appears before him a beautiful young man named "Zess," whose face tugs on Yuki's memory. He warns Yuki not to venture outside on Walpurgis Night, the eve of the blood-red moon, which invites death. But when Yuki's compassion leads him to disobey Zess's order, has Yuki carelessly thrown his life away before he's even given himself the chance to find out the very reason for it?	01K5G9X1V5HB46HDTSFP1953PV	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 1	2016-06-30T15:00:00.000Z
PRD_1G6N2EH7ZD10	CNT_0TRJ6KAFSS60	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 8	[]	The Betrayal Knows My Name, Vol. 8	Reiga reveals the truth behind the Sunset of the Underworld, the cataclysmic event that led to the interminable conflict between him and the Giou clan more than a thousand years ago. What happened to Yuki, Luka, and Takashiro at the beginning? In this war of betrayals, what fate awaits the soldiers...?	01KGA3BT7Z7V85DZSCBKBVMECV	8.0	2018-04-10T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 8	2018-04-10T07:00:00.000Z
PRD_1P38JH8FS8CG	CNT_29PGPNRYZBQG	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 6	[]	The Betrayal Knows My Name, Vol. 6	When Shuusei and Tooko drop off the radar while on a special mission to Kyoto, concern for their safety reaches a fever pitch at Twilight Hall. While preparing to rush to their rescue, Yuki and company are relieved to hear word that Tooko has been found. Still, with no word from Shuusei, a party heads to Kyoto to locate their ally. But while they're away, the suspicious deaths around the city are confirmed to be the work of the Duras. Will the remaining Zweilt be able to confront the enemy and save the innocent with their forces so severely depleted?!	01KG981V0H1D745QGDFNBNZQYJ	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 6	2016-06-30T15:00:00.000Z
PRD_1XQYVKVSK4E0	CNT_0X23Y8DRRE70	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 7	[]	The Betrayal Knows My Name, Vol. 7	Yuki, having learned the truth of his birth while visiting the Giou main house in Kyoto, returns to Tokyo in search of answers from Takashiro. Meanwhile, on the trail of the serial killer draining corpses of blood and wreaking havoc in Ueno, Kuroto and Senshirou encounter a young man in possession of a grimoire!	01KG98B6TKBT9NN4CVDW8CJNAQ	7.0	2017-07-17T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 7	2017-07-17T15:00:00.000Z
PRD_2D176MQN8WRG	CNT_1V6WF65PRYVG	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 3	[]	The Betrayal Knows My Name, Vol. 3	Despite finally learning more about the "Sunset of the Underworld" a thousand years past, Yuki finds his thoughts returning once more to his former friend and current enemy Kanata . . . But while Yuki may be new to picking sides in a centuries-old war, it is nothing new to the Zweilt. And Kuroto and Senshirou, the new Zweilt pair Yuki has only just encountered, harbor a profound hatred for Opasts, swearing revenge on one in particular. What happened four years ago to inspire such loathing? As Yuki bears witness to the flames of revenge that burn in the hearts of those around him, how will his own heart respond to the betrayal that he cannot forget?	01KG982NAHNKFZKSP3N56Q2C71	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 3	2016-06-30T15:00:00.000Z
PRD_3ZB1R0FDRRWG	CNT_1WG09RWRCV7G	The Betrayal Knows My Name CNT_2AYCDTSDYZ30	CNT_2AYCDTSDYZ30	2	1	1	Volume 4	[]	The Betrayal Knows My Name, Vol. 4	In their war with the Duras, the Zweilt rely almost entirely on the power of the bonds between them and their allies. But with each battle and every passing reincarnation, is there not the danger of cracks developing in the glue that holds these warriors together? When a tense, unexpected battle with an Opast general is cut short, one pair is forced to reconsider their disparate oaths of vengeance and what seeking revenge truly means. And before another battle can get underway, the final Zweilt pair joins the fray at Twilight Hall. But while Yuki seemingly becomes fast friends with one half of this new team, the heart of the other seems vaguely unreachable, clouded by memories of the past...	01KG982F8VXVPB9T7QJBDET00T	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Betrayal Knows My Name, Vol. 4	2016-06-30T15: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);