database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_1R7CQ5Y022FG"

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	copyright	on_sale_at
PRD_192XQBXR3Y10	CNT_29WNMH8ZNS2G	Kämpfer CNT_1R7CQ5Y022FG	CNT_1R7CQ5Y022FG	2	1	1	Volume 3	[]	Kämpfer Vol. 3	Natsuru Seno is your standard teenager that goes to an all-boy's school... except when he (through no control or will of his own) transforms into a Kampfer, a female warrior tasked with taking down those like herself. Now he- or she- must entroll in the all-girl's sister school, but when a newspaper article calls her ""The Yuri Girl of Seitetsu Campus,"" she now is forced with dodging love confessions and idol meet-and-greets alongside the bullets of an unknown Kampfer looking to taking out the new idol of the school. Can Natsuru survive all this and still get those pictures he promised a friend?	01K5GA9Y6JXVGDEBHB7FX8NYYV	3.0	2015-03-30T15:00:00.000Z	DMP LAB_1CTNJZHP92M0	GEO_1PQM5BDYSMG0	Kämpfer Vol. 3	(C)Yu Tatibana (C)Toshihiko Tsukiji. English language translation rights reserved by DIGITAL MANGA, Inc.	2015-03-30T15:00:00.000Z
PRD_25ZY47P9WXMG	CNT_1A2H9J0CK7Y0	Kämpfer CNT_1R7CQ5Y022FG	CNT_1R7CQ5Y022FG	2	1	1	Volume 1	[]	Kämpfer Vol. 1	High school life has rarely been an easy thing to endure for the typical teenager. Even more so for Natsuru Seno, an average teenage boy who one day finds himself transformed into a teenage girl. His transformation was caused by his being chosen to become a KÄMPFER (female fighters destined to battle each other). He has no idea how or even why he’s been thrust into such a predicament. Natsuru’s situation only grows more complicated when he realizes that attacks from other KÄMPFER can happen anywhere, and at any time. With potential dangers lying in wait around every corner, how will Natsuru maintain normalcy in his life? How can a teenage boy be normal with a newly acquired, randomly appearing, and greatly endowed female form?!	01K5FVR6S9864J9T3NNDV0GE3Z	1.0	2014-12-03T15:00:00.000Z	DMP LAB_1CTNJZHP92M0	GEO_1PQM5BDYSMG0	Kämpfer Vol. 1	(C) Yu Tatibana 2008 (C) Toshihiko Tsukiji 2008. English language translation rights reserved by DIGITAL MANGA, Inc.	2014-12-03T15:00:00.000Z
PRD_3JMJ6HN02MJG	CNT_094SEKW8M6HG	Kämpfer CNT_1R7CQ5Y022FG	CNT_1R7CQ5Y022FG	2	1	1	Volume 4	[]	Kämpfer Vol. 4	Natsuru’s ordinary life lay in ruins the moment he became a Kampfer, a female warrior destined to fight other Kampfer. Thankfully, he’s starting to get used to this split life he’s now forced to lead (one male, one female). If things stayed calm like this, he’d definitely get this all figured out. But where’s the fun in that? With the school festival fast approaching, everyone’s riled up and things start to get a little crazy. And when his newfound female self’s popularity reaches a fever pitch, there’s no telling what’s going to happen to this unwilling heroine. But more importantly, why is Kaede wearing a wedding dress?!	01KG986RBJ1R6KP0ZSR8XEZ1BC	4.0	2016-08-23T15:00:00.000Z	DMP LAB_1CTNJZHP92M0	GEO_1PQM5BDYSMG0	Kämpfer Vol. 4	(C) Yu Tachibana (C) Toshihiko Tsukiji. English language translation rights reserved by DIGITAL MANGA, Inc.	2016-08-23T15:00:00.000Z
PRD_3QC8EFZPDMFG	CNT_0J90VTA91FB0	Kämpfer CNT_1R7CQ5Y022FG	CNT_1R7CQ5Y022FG	2	1	1	Volume 2	[]	Kämpfer Vol. 2	Ordinary high school boy Natsuru Seno woke up one day to find that he had somehow changed into a girl. Now he's been dragged into the conflict between battle-driven beings called KAMPFER. With student council president shizuku sango standing in his way, can he safely rescue the kidnapped Kaede Sakura? Here’s volume 2 of this romantic school-based action comedy, loaded with beautiful girls!	01K5GAAPNKJMYF9QRSYMP6N9CG	2.0	2015-03-30T15:00:00.000Z	DMP LAB_1CTNJZHP92M0	GEO_1PQM5BDYSMG0	Kämpfer Vol. 2	(C)Yu Tatibana (C)Toshihiko Tsukiji. English language translation rights reserved by DIGITAL MANGA, Inc.	2015-03-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);