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

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_02DCZHD4QKK0	CNT_3FBVEYM0CNG0	The Other Side of Secret CNT_287WEB6CH31G	CNT_287WEB6CH31G	2	1	1	Volume 3	[]	The Other Side of Secret Vol. 3	Yuuto opened the forbidden door in search of his missing older sister, Manami, but his actions inadvertently led to Hina's death. Now, Yuuto and the girls are looking for a woman who can help resurrect Hina--who just happens to be Manami! Now that they know what they're looking for, the hunt is on. Will they find her? What's behind Saaya's strange beheavior? What does the horrific scarlet world have in store for everyone in volume 3 of this captivating, otherworldly mystery?	01KG989675Z88M44BWESGG88C8	3.0	2016-12-06T04:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	The Other Side of Secret Vol. 3	(C) Yoshikawa Hideaki 2015	2016-12-06T04:00:00.000Z
PRD_1QBFSCPGKPY0	CNT_013BE89Y7S50	The Other Side of Secret CNT_287WEB6CH31G	CNT_287WEB6CH31G	2	1	1	Volume 2	[]	The Other Side of Secret Vol. 2	Hoping to find his missing sister, Yuuto opened a mysterious door and entered the forbidden world of the other side. But Yuuto's well-meaning action caused another girl's death. Tormented by the blood on his hands, Yuuto decides to go through the door again in the hopes of resurrecting the girl. However, other hunters await him in the bizarre world behind the door.	01KG987VKZ1BM5XPE4WPDKFK3X	2.0	2016-09-13T06:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	The Other Side of Secret Vol. 2	(C) Yoshikawa Hideaki 2011	2016-09-13T06:00:00.000Z
PRD_2X7CMRWATQ80	CNT_2Y44GY1MX2BG	The Other Side of Secret CNT_287WEB6CH31G	CNT_287WEB6CH31G	2	1	1	Volume 1	[]	The Other Side of Secret Vol. 1	See You On The Other Side! Yuuto is a typical teenager who hangs out after school having silly conversations with his friends, but there's something he hasn't told anyone. Seven years ago, his older sister, Manami, disappeared through a mysterious door. Yuuto has searched for her ever since, but hasn't had any luck. One day, the same secret door his sister forbade him to enter appears right before him, and two girls rush out of it! In order to find his missing sister, Yuuto steps into the forbidden world...	01K5G9VVDQP3BFQM8Y6MTZ2JN0	1.0	2016-06-06T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	The Other Side of Secret Vol. 1	(C) Yoshikawa Hideaki 2011	2016-06-06T15:00:00.000Z
PRD_2Y7FAATEHZZG	CNT_0Z4X9H6JA24G	The Other Side of Secret CNT_287WEB6CH31G	CNT_287WEB6CH31G	2	1	1	Volume 4	[]	The Other Side of Secret Vol. 4	Yuuto continues to search for Manami, his sister who disappeared years ago. Along the way, Yuuto makes a shocking discovery about his own origins that only raises more questions. The central mystery remains: where did Manami vanish to? Unravel the final secrets in the thrilling conclusion to this extra-dimensional manga series!	01KG9YXCQHZ4H0YR915P9TNHM9	4.0	2017-03-27T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	The Other Side of Secret Vol. 4	(C) Yoshikawa Hideaki 2011	2017-03-27T15: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);