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_0G3Z197RA2FG"

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_09T7DJACYEVG	CNT_2GAZSJWVZZG0	Kobold King CNT_0G3Z197RA2FG	CNT_0G3Z197RA2FG	2	2	1	Volume 2	[]		Kobold King: Volume 2		Gaius Beldarus has been crowned the regent of the Kobold Kingdom, and his first act is to ensure the livelihood of these peaceful forest-dwellers. Wyatt, knight of House Zigan, vowed vengeance on Gaius for having thwarted his assault against the kobolds by the Ryburgh Adventurers' Guild. Worse yet, Gaius's mere presence throws a spanner in the works of the nobles whose machinations may yet determine the future rulers of the Southern Kingdoms. Wyatt has rounded up an army of the worst mercenary thugs money can buy, murderers, thieves, and butchers all; in short, ""adventurers."" With these heartless fighters at his back, and armed with dangerous magics, he is determined that the second attack on the kobold village will leave no survivors. Vastly outnumbered, the kobolds can only turn to their new King and his small coterie of devoted followers to lead their people through the oncoming war against them. Blood, sweat, blood, tears, and more blood will be shed in this war for survival.	Gaius has been crowned King! His first order of business is to ensure the survival of those he is responsible for, the peaceful forest-dwelling kobolds, in a war against the forces of the Ryburgh Adventurers' Guild and their ambitious leader, Wyatt.	01KGA8T304AT110HAZDJAXH5G1	2.0	2020-03-03T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Kobold King: Volume 2	Copyright (C) 2019 Syousa. Illustrations by sime		2020-04-20T07:00:00.000Z		0	0
PRD_1ZJHNPBP5CM0	CNT_2N5F13F7MDGG	Kobold King CNT_0G3Z197RA2FG	CNT_0G3Z197RA2FG	2	2	1	Volume 1	[]		Kobold King: Volume 1		Gaius Balderus has led a storied life. From humble beginnings, he made a name for himself as fearsome warrior, a renowned general, adviser to kings and paramour to princesses. Gaius's very presence commands respect and fear, so much so that everyone is too afraid of him to allow him to reveal his softer side. Gaius gives up everything and finds a chance to start again on the frontier of human civilization, where humans and monsters alike scrabble for existence in a hostile forest. When he runs into a tribe of kobolds, small furry creatures who are fleeing from human aggression, they immediately distrust him and everything about him. Can this gentle giant of a man come to peace with his past and win the friendship of the adorable kobolds?	Fearsome warrior Gaius must give up everything he knows and return to his roots on the frontier. His hometown is in ruins, but he discovers a tribe of adorable forest dwellers. Can he win their trust while coming to terms with his own past?	01KG9BNHGXY48F8DJWG6TF8W31	1.0	2019-12-03T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Kobold King: Volume 1	Copyright (C) 2019 Syousa. Illustrations Copyright (C) 2019 sime		2020-01-18T08: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);