database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_302NXB3ZBD1G"

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_0J9EREN00DZ0	CNT_24GY1SNJP8X0	The Bride of Demise CNT_302NXB3ZBD1G	CNT_302NXB3ZBD1G	2	2	1	Volume 2	[]	The Bride of Demise, Vol. 2	A mysterious new threat... <BR /><BR /> After taking a kihei as his Bride and overcoming the massive invasion known as the Gloaming, Kou Kaguro has finally earned some peace for himself and his friends. But as they take in the festival commemorating this hard-won victory, the unthinkable happens—Kou is murdered. It happens over and over, no matter how many times he turns back the clock. As if that weren’t enough, Pandemonium faces a whole new threat in the form of the strongest class in Combat, the Puppets. Who really wants Kou dead, and why…?	01KGB2CFQTNSS7GZQWVP4FQQ1Y	2.0	2022-11-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Bride of Demise, Vol. 2	2022-11-08T00:00:00.000Z
PRD_20QEPQ2WQJQ0	CNT_2ZXJTT9ZS4PG	The Bride of Demise CNT_302NXB3ZBD1G	CNT_302NXB3ZBD1G	2	2	1	Volume 1	[]	The Bride of Demise, Vol. 1	<P> A VOW THAT CANNOT BE BROKEN!<BR /> It’s been years since the kihei appeared without warning and overran the earth. To combat this threat, humanity established the Twilight Academy to train students as soldiers, though most die before graduation. During a mission, Kou Kaguro’s squad is attacked, and he must face his fate as yet another student casualty…or so he thought. A girl in white appears during his final moments and swears to protect him, filling a hole in his heart and setting them both on a path of love and despair. </P>	01KGAH44M33QGPHDGPH6TXJZ3T	1.0	2022-08-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Bride of Demise, Vol. 1	2022-08-16T00:00:00.000Z
PRD_2T4JWNDA2HBG	CNT_2S1WJ2AWCD1G	The Bride of Demise CNT_302NXB3ZBD1G	CNT_302NXB3ZBD1G	2	2	1	Volume 3	[]	The Bride of Demise, Vol. 3	We’ll be together forever, even if the world should end...<BR /><BR /> After narrowly avoiding a terrible fate at the school festival, Kou renews his friendship with his old classmates from Research, Asagiri and Isumi. As they pass the time in peace, Asagiri decides to confess her love for Kou. However, the very next day, Isumi informs Kou that Asagiri has disappeared in the kihei-infested ruins! As he searches for her, a new threat arises, which may shed light on the true nature of the kihei. For the sake of his beloved Brides, Kou must make a choice.	01KGB3X7205BGA4XSM29MM356S	3.0	2022-12-07T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Bride of Demise, Vol. 3	2023-02-21T00: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);