database: products: 2 rows where series_id = "CNT

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

2 rows where series_id = "CNT_0MDTH1SHY9K0"

descending

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_06WJC3D22BP0	CNT_112CY5G34TNG	The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment CNT_0MDTH1SHY9K0	CNT_0MDTH1SHY9K0	2	2	1	Volume 1	[]		The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment Volume 1		After a cruel and calculated reign, Kai Lekius, the Sanguinary King, brought stability and peace to his once fragmented land. Thus began his deathlike slumber as he awaited the rise of magic, leaving the rest in the capable hands of his brother. Three hundred years later, he wakes as a True Blood, an immortal vampire of immense power. However, even after all that time, magic hasn't progressed at all! A nobility system, which he has no recollection of establishing, tyrannizes the weak and weary of the new world. Though it displeases him greatly, Kai must once again postpone his studies and save his people once and for all!	After bringing stability and peace to his land, Kai Lekius, the Sanguinary King, fell into a deathlike slumber. Three hundred years later, he wakes with great anticipation of the world that awaits him. But it seems that hope has been misplaced...	01KH3EJSPT3T6KCXVW0FEPGNX2	1.0	2023-06-23T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment Volume 1	Copyright © Matsue Fukuyama, Genyaky 2023		2023-08-23T07:00:00.000Z		0	0
PRD_0DCMG86F0BFG	CNT_3SBBEP1XN6CG	The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment CNT_0MDTH1SHY9K0	CNT_0MDTH1SHY9K0	2	2	1	Volume 2	[]		The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment Volume 2		With Arkus in his grasp, Kai Lekius wastes no time in setting out on his next conquest—Runalog Province, a religious territory that stands between him and the imperial capital. His new army, the Army of the Night, a force of fearsome golems and five thousand men, proves unequaled, but the citizens of Runalog would rather take their own lives than surrender to the likes of a vampire! After learning this the hard way, Kai and his army are forced to a halt and must redirect their efforts into capturing the people's hearts. But once Kai sets his sights on winning over Runalog's revered Azure Maiden, how will he fare when a divine knight and an imperial assassin stand in his way?	With Arkus in his grasp, Kai Lekius sets out to conquer Runalog Province, but the citizens would rather take their own lives than surrender to a vampire! Kai must instead win over their revered Azure Maiden, but more formidable foes stand in his way!	01KH3G59K0FVBKAV51TAB2X3KE	2.0	2023-08-21T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Greatest Magician's Ultimate Quest: I Woke from a 300 Year Slumber to a World of Disappointment Volume 2	Copyright © Matsue Fukuyama, Genyaky 2023		2023-11-10T08: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);