database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_237S0Y78SMF0"

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_03TTYDXCTG90	CNT_30C6BK11BPXG	The Decagon House Murders CNT_237S0Y78SMF0	CNT_237S0Y78SMF0	2	1	1	Volume 4	[]	The Decagon House Murders 4	The seven members of a college mystery club head to Tsunojima Island, the site of a mysterious murder-homicide and ten-sided house built by the murdered architect Seiji Nakamura. Before long, the students start dying strange deaths, and the survivors find themselves locked in a battle of wits with the murderer... Meanwhile, back on the mainland, former club member Minamikawa visits the grave of Chiori Nakamura, another former club member who died in a boating accident. While there, she finds something that turns the case on its head...	01KGAEY7ZP1X4QM9SNNK9W96W6	4.0	2022-03-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Decagon House Murders 4	The Decagon House Murders Yukito Ayatsuji, Hiro Kiyohara/Kodansha Ltd.	2022-04-05T07:00:00.000Z
PRD_0B0CHNF9R18G	CNT_1GZYCHGGV5Q0	The Decagon House Murders CNT_237S0Y78SMF0	CNT_237S0Y78SMF0	2	1	1	Volume 1	[]	The Decagon House Murders 1	The manga based off the best-selling The Decagon House Murders novel by Yukito Ayatsuji! The members of a particular university's Mystery Club travel to a ten-sided house on a remote island...which just happens to have been the scene of a gristly, and unsolved, mass murder. Armed with details of the murder and keys to the property, they set out to dig deeper...but can they trust the "facts" of the case? And moreover...can they trust each other?	01KG9FXBZ7NS4VJ8V69FQAA90K	1.0	2021-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Decagon House Murders 1	The Decagon House Murders Yukito Ayatsuji, Hiro Kiyohara/Kodansha Ltd.	2021-08-17T07:00:00.000Z
PRD_0GTQ02761TMG	CNT_1VRJR5NNP5GG	The Decagon House Murders CNT_237S0Y78SMF0	CNT_237S0Y78SMF0	2	1	1	Volume 5	[]	The Decagon House Murders 5	A group of mystery-loving college students visit Tsunojima Island, the site of an infamous quadruple homicide, and home to architect Seiji Nakamura's unusual Decagon House. Shortly after their arrival, members of the group start turning up murdered, until the fifth day...when the entire Decagon House goes up in flames. Meanwhile, on the mainland, Kawaminami and Shimada discover the truth behind the Tsunojima Island murders from a year ago. But when they visit the grave of Chiori Nakamura, a former mystery club member and Seiji's daughter, they find something that turns the case upside down, and Kawaminami receives word that all the club members on the island have died... All will be revealed in this final volume!	01KGB2FRX9HS22549YTNBDSBBC	5.0	2022-11-10T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Decagon House Murders 5	Yukito Ayatsuji, Hiro Kiyohara/Kodansha Ltd.	2022-11-29T08:00:00.000Z
PRD_0SAJB0SYHYY0	CNT_32C7M058B22G	The Decagon House Murders CNT_237S0Y78SMF0	CNT_237S0Y78SMF0	2	1	1	Volume 3	[]	The Decagon House Murders 3	After the Mystery Club arrives on Tsunojima Island, they discover mysterious tablets with things like "Detective" and "Murderer" written on them. They initially see it as a tasteless prank, but when the roles written on the tablets start to come true, and the victims begin to pile up, the group realizes their lives will depend on finding the killer... Meanwhile, on the mainland, Kawaminami and Shimada are chasing after the truth behind the "mysterious quadruple homicide"...	01KG9H6DBSP60D3NEE4NHZMRF4	3.0	2021-09-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Decagon House Murders 3	The Decagon House Murders Yukito Ayatsuji, Hiro Kiyohara/Kodansha Ltd.	2021-10-19T07:00:00.000Z
PRD_2QZ1QEV63MCG	CNT_3GMEA6KX4RK0	The Decagon House Murders CNT_237S0Y78SMF0	CNT_237S0Y78SMF0	2	1	1	Volume 2	[]	The Decagon House Murders 2	The manga based off the best-selling The Decagon House Murders novel by Yukito Ayatsuji! The members of a particular university's Mystery Club travel to a ten-sided house on a remote island...which just happens to have been the scene of a gristly, and unsolved, mass murder. Armed with details of the murder and keys to the property, they set out to dig deeper...but can they trust the "facts" of the case? And moreover...can they trust each other? After arriving on the island, the Mystery Club discover mysterious tablets with things like "Detective" and "Murderer" written on them. They initially see it as a tasteless prank, but later that night, the tablet reading "First Victim" ends up on somebody's door, and the group is forced into solving a real mystery... Meanwhile, on the mainland, Kawaminami and Shimada are getting closer to the secret of the island after receiving letters from Seiji Nakamura, who's supposed to be dead...!!	01KG9GX7MCQ5YQXYWNTZZ74M3M	2.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Decagon House Murders 2	The Decagon House Murders Yukito Ayatsuji, Hiro Kiyohara/Kodansha Ltd.	2021-09-21T07: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);