database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_36G2YE3T4VE0"

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_000V5Q84K0R0	CNT_1W2HB90K4AVG	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 8	[]	The Record of a Fallen Vampire, Vol. 8	Despite a solemn promise never to do so, Adelheid decides she must reveal who really killed Stella. The revelation is a shock, but not to Strauss, who found out long ago not only who the murderer was but what had prompted such a heinous act. But can any of this really matter with Earth facing an imminent alien invasion?	01KG95MQ7APEXY54WEKSHT5D0F	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 8	2016-06-30T15:00:00.000Z
PRD_04HBQAAEZFZ0	CNT_3ZDEAMPVKA4G	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 6	[]	The Record of a Fallen Vampire, Vol. 6	Recollections of the past come to an end just as the terrors of the present are unleashed! The survival of humans and dhampires alike depends on Strauss, but does he dare take action and thus reveal one of his most closely guarded secrets?	01KG95MNXSGCMC8TGE6FAFP7CD	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 6	2016-06-30T15:00:00.000Z
PRD_0B7T2X7GVEY0	CNT_1YQVA6B3Y95G	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 4	[]	The Record of a Fallen Vampire, Vol. 4	With aliens poised to take over Earth, Akabara forges a tentative alliance with the humans to help fight off the invasion. But can everyone on the team be trusted, especially since the Black Swan's ultimate mission is to kill Akabara?	01KG95MMETE3KFWZETQQKX4MS9	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 4	2016-06-30T15:00:00.000Z
PRD_0FMNDG1V7DX0	CNT_3Y28NG1CD86G	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 2	[]	The Record of a Fallen Vampire, Vol. 2	Akabara is heavily injured during his battle against Kayuki, the newest incarnation of the Black Swan. Kayuki remains shrouded in mystery--not only does she bear a striking resemblance to the previous Black Swan, but she also offers Akabara a temporary truce! Why does she need to keep the Vampire King alive?	01KG95MHYG6XE2C6EVFW0R0WAS	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 2	2016-06-30T15:00:00.000Z
PRD_1SYQ7XRKQ910	CNT_3KBWMARE142G	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 1	[]	The Record of a Fallen Vampire, Vol. 1	Thousands of years ago, Vampire King Akabara "Red Rose" Strauss lost both his kingdom and his queen. Since humans were unable to kill the queen, they sealed her away, erecting thousands of fake seals so that the king would never find her true location. Despite being pursued by relentless dhampires, Akabara continues to search for his queen to this day... Akabara's quest takes a sinister turn when an entity called the Black Swan appears. The Black Swan inhabits the body of a young human girl every 50 years, giving her the power to destroy the Vampire King and his queen. With each incarnation the Black Swan grows stronger--will the 49th Black Swan mean the end of Akabara?	01KG6ZG0KRD134RH8SYCBGCEK9	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 1	2016-06-30T15:00:00.000Z
PRD_23VGKES7N08G	CNT_0WDTV05EZVA0	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 9	[]	The Record of a Fallen Vampire, Vol. 9	Final Volume! Now that she knows the truth about Stella and the Black Swan, Kayuki is faced with a fateful decision concerning the conflict between her and Strauss. Strauss and Adelheid, meanwhile, prepare to deal with the looming alien invasion, knowing that the future of vampires, dhampires and humans depends on overcoming seemingly insurmountable odds!	01KG95MRAGP4JX51W5X58ZTT72	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 9	2016-06-30T15:00:00.000Z
PRD_2683Y1V9HFFG	CNT_2ZQQTKVQATB0	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 7	[]	The Record of a Fallen Vampire, Vol. 7	Long ago, Strauss tried to bring peace to his realm by exposing himself to sunlight, only to have that very sunlight betray him. Now, with his queen freed from her imprisonment, Strauss reveals that her far more bitter betrayal, the cause of his thousand-year quest for revenge, was never what it seemed!	01KG95MPJH69S68PHN1VHWTXD5	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 7	2016-06-30T15:00:00.000Z
PRD_29F2V7PNSDDG	CNT_2YCHTF684RN0	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 3	[]	The Record of a Fallen Vampire, Vol. 3	Dhampire leader Bridget delivers a shocking revelation about Akabara and his queen, Adelheid! The mystery of Akabara's dark past continues to unwind, but can the truth Bridget divulges be trusted?	01KG95MJP5R59ZAM79ZA3MG4D6	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 3	2016-06-30T15:00:00.000Z
PRD_2AYJ9MMKXEEG	CNT_0Z24TXHZSSM0	The Record of a Fallen Vampire CNT_36G2YE3T4VE0	CNT_36G2YE3T4VE0	2	1	1	Volume 5	[]	The Record of a Fallen Vampire, Vol. 5	More, much more, is revealed about the events of one thousand years ago, starting with the unusual circumstances of Bridget's birth and leading into the dark and deadly political struggles of that bygone era!	01KG95MN1AZ4KMM79VGHP6M0ZS	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Record of a Fallen Vampire, Vol. 5	2016-06-30T15: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);