database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_0PPQDMNVJTQG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_03AK6V5Q7FZ0	CNT_2EAETYG8GK90	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 5	[]	Banner of the Stars: Volume 5	The Three Nations Alliance springs a surprise attack, leading to the fall of the imperial capital. Meanwhile, Lafier's brother is stranded behind enemy lines.		01KG9DFV5Z0Y470XJ9E1BW9JRT	5.0	2020-11-18T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 5	Copyright (C) 2013 Hiroyuki Morioka Illustrations Copyright (C) 2013 Takami Akai	2021-02-06T08:00:00.000Z
PRD_061EVMNWQBS0	CNT_23Y74P0TZCKG	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 1	[]	Banner of the Stars: Volume 1	You journeyed with Jint and Lafier through three volumes of interplanetary-scale action and intrigue in CREST OF THE STARS. Through pain and companionship, they forged their way through an impossible ordeal unscathed. But that adventure, though grand, was just the introduction to a larger, decades-spanning chronicle of galactic war. Join our two heroes, now bona fide starpilots appointed to a warship in an Abh Empire fleet, as they participate in their very first official military operation. They are tasked with helping defend a strategically crucial star system from the Three Nations Alliance. Complications arise, however, when they learn that their commanding officer is none other than the sister of the Abh baron they killed three years prior!	If you read Crest of the Stars, you'll love the ongoing continuation and ""story proper,"" Banner of the Stars. Jint and Lafier must help defend a territory, but their superiors range from the proudly insane, to the sister of a man they killed!	01KG9BN7PQJ5Y4NR148761TW1P	1.0	2019-10-30T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 1	Copyright (C) 1996 Hiroyuki Morioka Illustrations Copyright (C) 1996 Toshihiro Ono	2019-12-17T08:00:00.000Z
PRD_08D460H7DZ6G	CNT_2M9GA2CGB4D0	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 4	[]	Banner of the Stars: Volume 4	Lafier is now the captain of a state-of-the-art raid ship, and her brother, Duhier (who is still wrestling with his inferiority complex) has finally enlisted in the Star Forces. Meanwhile, the galactic war is reaching a turning point, as the Hania Federation asks to join the Abh Empire. Will the Empress accept their offer? And might Hania have ulterior motives?	Lafier is now the captain of a state-of-the-art raid ship, and her brother, Duhier (who is still wrestling with his inferiority complex) has finally enlisted in the Star Forces. Meanwhile, the galactic war is reaching a turning point, as the Hania Federation asks to join the Abh Empire. Will the Empress accept their offer? And might Hania have u...	01KG9D60XMJVPE2CN7EHF59ZDK	4.0	2020-09-23T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 4	Copyright (C) 2004 Hiroyuki Morioka Illustrations Copyright (C) 2004 Toshihiro Ono	2020-11-29T08:00:00.000Z
PRD_10XCQ2SYVYW0	CNT_39A4G8GWPZRG	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 2	[]	Banner of the Stars: Volume 2	Lafier has been appointed the interim liege of yet another newly conquered star system, with Jint her ill-defined adjunct. Only the planet of Rohbnahss is by far the most vexing of the Empire's latest acquisitions—because it's a giant prison on the verge of a world-scale uprising! Can the iconic duo form a working government there? What will become of them and their bond once the enemy's offensive and her Abliar obligations force Lafier to abandon Jint on a powderkeg ready to blow? Find out in this, the second exciting installment of Banner of the Stars!	Tasked with forming a working government on a prison planet, Lafier and Jint must deal with a dangerous inmate rebellion on top of the enemy's newest military maneuvers.	01KGA8FR8BBG9PV4W0YZY2TKBM	2.0	2020-01-20T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 2	Copyright (C) 1998 Hiroyuki Morioka Illustrations Copyright (C) 1998 Toshihiro Ono	2020-02-22T08:00:00.000Z
PRD_2Q7B9CX8E5GG	CNT_1NSV50PTJ90G	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 6	[]	Banner of the Stars: Volume 6	Around a decade has passed since the Fall of Lahkfacar, and the Empire is now split into two distinct regions. Crown Princess and fleet commander Lafier is tasked with the operation to annex the People's Sovereign Stellar Union and reunite the Empire while at the same time facing supply shortages and crew inexperience — and she might need to flout orders to get it done.	About a decade has passed since the Fall of Lahkfacar, and the Empire is split in two. Lafier leads the operation to annex the PSSU and reunite the Empire.	01KG9EK60DNC5GMFT6R2W380VG	6.0	2021-01-29T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 6	Copyright (C) 2018 Hiroyuki Morioka Illustrations Copyright (C) 2018 Takami Akai	2021-04-12T07:00:00.000Z
PRD_2QVE4K5NNWM0	CNT_0AN8C7PQ4XGG	Banner of the Stars CNT_0PPQDMNVJTQG	CNT_0PPQDMNVJTQG	2	2	1	Volume 3	[]	Banner of the Stars: Volume 3	The Countdom of Hyde, Jint’s star system of birth, has been freed from enemy occupation. The Empire must now reestablish its dominion there, with Jint as its liege by birthright. Yet the self-sufficient planet Martin is as fiercely and hostilely anti-imperial as ever. Moreover, he has to negotiate with the planet’s heads of state... his own foster parents! While he may have Lafier and more former comrades of his to help him in his struggles, only he can ultimately decide where his true loyalties lie - with Martin, or with the Empire.	Lafier accompanies Jint to his home planet, in his countdom, where he must negotiate with the fiercely anti-imperial populace... and with his foster parents, the heads of state!	01KGA8WMM382H2FWY3KR5X1NN4	3.0	2020-03-27T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Banner of the Stars: Volume 3	Copyright (C) 2001 Hiroyuki MoriokaIllustrations Copyright (C) 2001 Toshihiro Ono	2020-05-18T07: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);