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

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_1AFF84NJAHXG	CNT_0S5ECVBMFBG0	A School Frozen in Time CNT_1FPXWGBHHW3G	CNT_1FPXWGBHHW3G	2	1	1	Volume 3	[]	A School Frozen in Time 3	First, there were eight, and now there are six. With Mitsuru and Shimizu now missing, everyone is on edge as they try to find a way out of their horrifying circumstances. The remaining students continue to suspect that the person keeping them trapped is among them, but Shimizu also suggested a bizarre, new theory: they may be inside the mind of the person who took their own life at the school festival. Takano thinks he might just know who their tormentor is, but many unanswered questions still remain. Can he get to the bottom of this mystery before his time's up?	01KG9GFTKB794VQC8XAW6TJJQ7	3.0	2021-07-21T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A School Frozen in Time 3	A School Frozen in Time Naoshi Arakawa, Mizuki Tsujimura / Kodansha, Ltd.	2021-08-10T07:00:00.000Z
PRD_1X62VBZYY250	CNT_0A90V84QQCSG	A School Frozen in Time CNT_1FPXWGBHHW3G	CNT_1FPXWGBHHW3G	2	1	1	Volume 2	[]	A School Frozen in Time 2	A regular school day has turned into a chilling horror as Hiroshi, Mizuki, and their friends find themselves confined within the frigid walls of Seinan Gakuin. No one can seem to remember who took their own life at the school festival, but whoever it was is keeping them captive. And to make matters worse, the eight trapped classmates become seven when Mitsuru suddenly disappears with only a trail of blood in his place. Now they have even more reason to solve the mystery of their bizarre circumstances—because if they don't, the only thing they may be leaving is this mortal coil...	01KG9FNME0QCDBXX1S8QBA61CN	2.0	2021-06-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A School Frozen in Time 2	A School Frozen in Time Naoshi Arakawa, Mizuki Tsujimura / Kodansha, Ltd.	2021-06-15T07:00:00.000Z
PRD_2BCMPS76FCX0	CNT_0B00M7ZYY6HG	A School Frozen in Time CNT_1FPXWGBHHW3G	CNT_1FPXWGBHHW3G	2	1	1	Volume 1	[]	A School Frozen in Time 1	On a snowy school day like any other, classmates and childhood friends Hiroshi and Mizuki arrive at school to find the campus eerily empty. Before long, they find themselves trapped inside with six other friends, and even stranger, all the clocks have stopped at a very specific moment–the exact time when a former classmate jumped off the school roof to their death three months earlier. It turns out that this departed friend is their way out of their current predicament and may even be among their group...but no one can remember who it was that took their life on that sad day. The students must face themselves and their past memories to piece together the identity of this suicide victim or risk a similar fate–with their lives lost and forgotten inside these frigid school walls.	01KG9E5PAS3YJ08756478WWX5D	1.0	2021-03-31T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A School Frozen in Time 1	A School Frozen in Time Naoshi Arakawa, Mizuki Tsujimura / Kodansha, Ltd.	2021-04-06T07:00:00.000Z
PRD_38J1604W5KV0	CNT_11R6AXSY875G	A School Frozen in Time CNT_1FPXWGBHHW3G	CNT_1FPXWGBHHW3G	2	1	1	Volume 4	[]	A School Frozen in Time 4	Tick. Tock. As the clock starts again, Takano and his remaining classmates must face their fears and traumas, still trapped within the frigid walls of their school. Takano finds himself back at the origin point of this icy nightmare: the last day of the school festival. There, he finally remembers who it was that took their own life, and the surprising identity of that person begins to uncover the mysteries that have plagued Takano and his friends. But answering the question that's hung dangerously over their heads will reveal one last puzzle to solve—and if they don't act fast, they just might lose another precious friend... Final Volume!	01KG9H6K94MHM5XT31EVZG6G6Y	4.0	2021-09-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	A School Frozen in Time 4	A School Frozen in Time Naoshi Arakawa, Mizuki Tsujimura/Kodansha, Ltd.	2021-11-23T08: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);