database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_0SWKYGR7XJG0"

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_0FGG3VNB3RG0	CNT_03QAGV69WAM0	Dead Company CNT_0SWKYGR7XJG0	CNT_0SWKYGR7XJG0	2	1	1	Volume 1	[]	Dead Company, Volume 1	A death game where players are forced to kill one another until there's only one person left standing!This is the story of Ryosuke Miyauchi, a young man who survived a real-life battle royale game three years ago, and who has been struggling to live a normal life since then. One day, Ryosuke was scouted by the enormously popular game developer EDC, who asked him, "Why don't you use your special experience to make a game?"	01KGB6MMF0JB7Y89WEBGT7HS1D	1.0	2023-03-20T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Dead Company, Volume 1		2023-04-07T07:00:00.000Z
PRD_0HNRMM1A38GG	CNT_3ZTQJN0ZK2BG	Dead Company CNT_0SWKYGR7XJG0	CNT_0SWKYGR7XJG0	2	1	1	Volume 3	[]	Dead Company, Volume 3	Ryosuke Miyauchi may have survived a real-life death game three years ago, but that brush with death is only the first of many to come. When he's recruited by major game developer EDC on the basis of his prior 'experience,' he soon realizes that they're the ones responsible for his trauma, all while they grow profits and slaughter innocents as they run other death games all around the world. Now, his late girlfriend's sister Kyo has joined a death game of her own accord, and Ryosuke dedicates himself to keeping her safe — no matter the cost. But when he's offered a chance to strike back against the company that took everything away from him, Ryosuke finds himself torn. Can he trust the people who claim they want to take EDC down? As everything begins to fall apart, will he be able to protect Kyo while knowing that her goal is to avenge her sister's killer?Ryosuke readies to risk it all in this thrilling final volume of Dead Company!	01KG9P16KFSAHMQKSBQAB1WXMT	3.0	2023-08-17T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Dead Company, Volume 3	©2024	2023-09-02T07:00:00.000Z
PRD_2ZCKX4EP14JG	CNT_2581TQ0H3E9G	Dead Company CNT_0SWKYGR7XJG0	CNT_0SWKYGR7XJG0	2	1	1	Volume 2	[]	Dead Company, Volume 2	Ryosuke Miyauchi may have survived a real-life death game three years ago, but the lingering trauma and guilt from having his girlfriend's blood on his hands has left him an empty man with an empty life. When he's recruited by major game developer EDC on the basis of his prior 'experience,' he soon realizes that his first-hand brush with murder is exactly why they offered him the job...Now he's left with no choice but to take part in running death games similar to the one that cost him everything. But what will he do when he finds out that Kyo, his late girlfriend's younger sister, is one of the players in this dangerous game?Knowing that his hands are already stained with innocent blood, Ryosuke makes his decision to risk it all...!	01KH3FY06RHSJZVYQZPNRV0DVQ	2.0	2023-07-21T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Dead Company, Volume 2	©2021	2023-07-22T07: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);