database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_2PMMGDJZPMPG"

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_079Q8GZ651DG	CNT_140KK05W8WN0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 3	[]	Strike the Blood, Vol. 3	Kojou, having learned both the secret of Itogami Island and Eustach's true goals, agonizes over the right thing to do even as Eustach presses his attack on the keystone gate. Are the lives of the island's citizens more important than this strange new justice? Either way, their fate is in Kojou's hands!	01K5G9X9ENWCCSFQW3374J4N6B	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 3	2016-06-30T15:00:00.000Z
PRD_0DX1C48DYCN0	CNT_17DFYPSPBYY0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 4	[]	Strike the Blood, Vol. 4	At the invitation of Dimitrie Vattler, emissary of the First Primogenitor, Kojou and Yukina attend a yacht party. Dimitrie's guardian has it in for Kojou, and as though that's not bad enough, the festivities turn serious when Kojou and Yukina discover a terrorist plot that threatens Itogami Island itself...	01KG988E5XVJKXYCTEQESV2N9D	4.0	2016-10-03T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 4	2016-10-03T15:00:00.000Z
PRD_0H0RSG9ZAWY0	CNT_2MKG21MA1NQ0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 8	[]	Strike the Blood, Vol. 8	Time is running out for Kanon Kanase. If they can't stop the faux-angel ritual in time, she'll ascend from realm of mankind and become something truly inhuman. Will the Fourth Primogenitor be strong enough to stop this madness before it's too late? The Amphisbaena arc reaches its heart-pounding conclusion!	01KG9VN4XW3CRK6RPB23YZ2E9E	8.0	2017-09-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 8	2017-09-18T15:00:00.000Z
PRD_1634QTR2MDHG	CNT_0JX7F74GXQH0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 2	[]	Strike the Blood, Vol. 2	Yukina is trapped in a pitched battle against Astarte the homunculus, and she's losing--when who should come to her rescue but the very boy she's been assigned to observe, Kojo Akatsuki! Akatsuki tries to end the clash, but Astarte's familiar, the fearsome Rhododactylos, isn't going to let that happen. Is this a fight that only an awakened Fourth Primogenitor can finish?	01K5GB51FJKKW1HBP0EJBBBTWM	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 2	2016-06-30T15:00:00.000Z
PRD_196Q35K8HQSG	CNT_2D1A533YJYV0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 9	[]	Strike the Blood, Vol. 9	Though Kanon Kanase is recovering from her ordeal, her father's research has dangerous implications for the Fourth Primogenitor, and Kojou's hopes of returning to a normal life are premature. The alchemist Amatsuka is after the Wiseman's Blood, a powerful liquid-metal life-form, and he will spare no one in pursuit of his goal. Kojou would never back down from a fight to protect his city and his friends, but this time he will receive help from an unexpected ally...	01KGA17Q00JEB9TAZFNEEZ9F03	9.0	2017-12-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 9	2017-12-19T08:00:00.000Z
PRD_1F7K86P2XYG0	CNT_3MGHMR7ZKGK0	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 5	[]	Strike the Blood, Vol. 5	Asagi, Yukina, and Nagisa have been captured by the Black Death Emperor faction. Kojou and Sayaka go after them, breaking into the island they suspect of being the terrorists' base. But an ancient terror awaits them--the Nalakuvera. A new beast vassal stirs within the Fourth Primogenitor, but will Kojou's power be enough to save his friends?	01KG9YR2XG62467M0TCQSBZQHY	5.0	2016-12-27T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 5	2016-12-27T15:00:00.000Z
PRD_1NQZCCHKB4AG	CNT_1PJHWG9R7Z80	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 1	[]	Strike the Blood, Vol. 1	Kojou Akatsuki lives on the artificial island of Itogami, and he has a secret: He's the "Fourth Primogenitor," the most powerful vampire in the world. He's carefully kept this dark knowledge from his family and friends, but one day, a beautiful girl named Yukina Himeragi appears before him and tells him that she knows who he really is--and that she's been sent to...kill him?!	01KG95J5E0T59R4G7C3P26GKNC	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 1	2016-06-30T15:00:00.000Z
PRD_2GKX3HWRDJTG	CNT_2X56FA5S54SG	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 6	[]	Strike the Blood, Vol. 6	Yukina and Koujou are reunited once more and ready to take on the army of Nalakuvera! Will the strength of his new beast vassal allow the Fourth Primogenitor to reign supreme, or will the Black Death Emperor Front succeed in destroying Itogami City?	01KG9YXGK9NAFF62K8K2N84NHK	6.0	2017-03-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 6	2017-03-20T15:00:00.000Z
PRD_3KSD9462HEHG	CNT_3V3VQAFBK9PG	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 10	[]	Strike the Blood, Vol. 10	It's a battle to the death between the complete human and the strongest vampire! The Wiseman had been using Kou Amatsuka to bring about his own revival. When he attacks a ferry, can Nina Adelard obtain La Folia's cooperation in order to save them?!	01KGA3BVZ85FQBR3HZXN4WQJJF	10.0	2018-04-10T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 10	2018-04-10T07:00:00.000Z
PRD_3V3D7RY9222G	CNT_053HYJ036VKG	Strike the Blood CNT_2PMMGDJZPMPG	CNT_2PMMGDJZPMPG	2	1	1	Volume 7	[]	Strike the Blood, Vol. 7	After partnering with Natsuki Minamiya to capture the Masked and end the destruction in the sky, Kojou and Yukina are shocked to discover one of the winged girls is none other than Yukina's classmate Kanon Kanase! When Kanon disappears, Kojou and Yukina seek out her adoptive father, a researcher at megacorp Magus Craft, Inc. Far from the professional meeting they expected, the two find themselves abandoned on a deserted island! It is deserted...isn't it?!	01KG9Z52R2845C3EXXJZQRJ7SS	7.0	2017-06-19T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Strike the Blood, Vol. 7	2017-06-19T15: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);