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

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_108TD7XF5JJG	CNT_0BX1HN5WPB3G	A Springtime with Ninjas CNT_3VTSB28XP1S0	CNT_3VTSB28XP1S0	2	1	1	Volume 3	[]	A Springtime with Ninjas Volume 3	The Kasugami heiress Benio and her ninja Tamaki have finally started dating, but now their forbidden love has every lord and ninja in Japan trying to kill them! When Benio's uncle falls into a coma after protecting Benio from an assassination attempt, she has to take his place on the Council of Lords. Unfortunately, no ninja can accompany her into the meeting chamber... A Springtime with Ninjas: the Couple Arc is a rollercoaster ride full of love and battle! Plus, this volume includes a bonus story from the perspective of Naoto and Shizuka.	01KG9Z64J9PN7C014AH4GHAVCN	3.0	2017-06-27T04:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A Springtime with Ninjas Volume 3	Narumi Hasegaki/ Kodansha Ltd.	2017-06-27T04:00:00.000Z
PRD_1HWY37BF15M0	CNT_0XS3B67037Z0	A Springtime with Ninjas CNT_3VTSB28XP1S0	CNT_3VTSB28XP1S0	2	1	1	Volume 2	[]	A Springtime with Ninjas Volume 2	Men may be flocking from all over Japan to try to steal a kiss from the wealthy young Benio，but she has the great ninja Tamaki there to protect her! The two of them don’t always get along，but so far，everything has worked out one way or another. However，when Tamaki’s ex shows up，trouble appears to be on the horizon. The lady and her ninja will get a lot closer in volume two!	01KG9YVGQQHBPKD6DZVKJ0P6D3	2.0	2017-02-13T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A Springtime with Ninjas Volume 2	(C) Narumi Hasegaki / Kodansha Ltd.	2017-03-06T15:00:00.000Z
PRD_1V3SRD6V93T0	CNT_0WEDA3KGX5S0	A Springtime with Ninjas CNT_3VTSB28XP1S0	CNT_3VTSB28XP1S0	2	1	1	Volume 1	[]	A Springtime with Ninjas Volume 1	Benio is the heiress of the richest family in Japan，and tradition holds that she must marry the first person to kiss her. So that she can attend high school，Benio is assigned the ninja Tamaki as a bodyguard，but he turns out to be quite the player. It’s not always easy for a strong-willed rich girl and a smart-alecky ninja to get along in this romantic comedy about a pure young lady and her smoking hot knight.	01KG98K8X00Y7CDQ00CR8KQ9XF	1.0	2017-02-06T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A Springtime with Ninjas Volume 1	(C) Narumi Hasegaki / Kodansha Ltd.	2017-02-13T15:00:00.000Z
PRD_3RWGZQPXZMX0	CNT_39K16GY7QXG0	A Springtime with Ninjas CNT_3VTSB28XP1S0	CNT_3VTSB28XP1S0	2	1	1	Volume 4	[]	A Springtime with Ninjas Volume 4	Tamaki's been cursed to die within a month. Benio can't stand to just sit and watch, and she's not afraid to put her life on the line to save the ninja she loves. But Tamaki tells her something she never thought she would hear him say: He wants to break up... Benio just can't get a break! See her and Tamaki's forbidden love put to the test in this final volume. Plus, get a peek at what happens after the story is over in the bonus comic.	01KG9Z6APA287G0RNPA5HRPEGT	4.0	2017-06-26T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A Springtime with Ninjas Volume 4	Narumi Hasegaki/ Kodansha Ltd.	2017-07-25T04: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);