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

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_159JSSGX1B20	CNT_3BB2HBF4DY7G	The Crown of Rutile Quartz CNT_1DJKQZH6MEB0	CNT_1DJKQZH6MEB0	2	2	1	Volume 2	[]		The Crown of Rutile Quartz: Volume 2		After his victory against the Great Empire of Galed, Slaine is crowned the King of Hasenvalia. The young monarch spends the early days of his rule in comfort, preparing to marry his aide-turned-lover, Monica—but a shocking betrayal and an empire-backed coup attempt threaten to drag his tiny kingdom back into strife and unrest. If Slaine wishes to hold on to his crown and protect his people, he must devise a cunning plan to dismantle the empire's impregnable Sauerland Fortress from within—and thwart the nefarious Imperial Prince Florenz once and for all. The second installment in the Crown of Rutile Quartz series, a fantasy saga chronicling the cutthroat politics and harrowing battles a clever young king must face in his rise to power. Follow Slaine as he uses his wit and knack for strategy to beat impossible odds.	After his victory against the Galed Empire, Slaine is crowned king—but his reign descends into chaos when Imperial Prince Florenz stokes rebellion within the kingdom. Slaine must devise a plan to bring an end to the empire's schemes once and for all.	01KGB9R9BWVYA853ZR5GVPM6E5	2.0	2024-05-21T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Crown of Rutile Quartz: Volume 2	Copyright © Surume Enoki, ttl 2024		2024-08-22T07:00:00.000Z		0	0
PRD_3VF2YE9N12XG	CNT_2SY20YBCPCYG	The Crown of Rutile Quartz CNT_1DJKQZH6MEB0	CNT_1DJKQZH6MEB0	2	2	1	Volume 1	[]		The Crown of Rutile Quartz: Volume 1		Slaine is a humble, provincial commoner in the small Kingdom of Hasenvalia... Or so he thinks until the day the entire royal family is wiped out in a palace fire and Slaine comes to learn he's really the king's illegitimate son. It now falls on him to succeed the throne. Despite his lack of knowledge and experience, Slaine's natural wits and dedication—plus the support of his aide-de-camp, Monica—allow him to excel against all odds. Between unsupportive nobles at home and hostile rulers abroad, Slaine already has his work cut out for him—and then, on the eve of his coronation, the great Empire of Galed declares war against Hasenvalia. Faced with such a frighteningly powerful foe, Slaine is forced to make a choice between fleeing into political exile or resisting invasion to the bitter end. Caught between the conflicting agendas of neighboring nations, this boy from a backwater town must learn how to grow into his crown. Witness the birth of a king!	After a palace fire wipes out Hasvenvalia's royal family, Slaine discovers he is the king's bastard son—and sole surviving heir. With the support of his aide, Monica, the young boy must use his wits to survive royal intrigue and an impending war.	01KH3G9FNWVWE6FB2M7XKWS94P	1.0	2023-09-01T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Crown of Rutile Quartz: Volume 1	Copyright © Surume Enoki, ttl 2023		2023-12-19T08: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);