database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_1NNQ757P2AVG"

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_0C8MSA8QMG60	CNT_15A0X5SQ12M0	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 3	[]	Cipher Academy, Vol. 3	The final round of the class-leading private selection begins with a game of poker! Playing with 53 encrypted cards, Iroha finds himself embroiled in an all-out battle with some of the top students in class, including his rival Kyora Toshusai! Who will take the throne and be crowned class leader?!	01KGBDV6ZZQ3CHPQBA0J0QJ57Y	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 3	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0HW8DJY6M8Y0	CNT_1EQ8GTBKSAC0	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 2	[]	Cipher Academy, Vol. 2	Iroha advances from the first round of the battle to decide who will lead the class. But before the next stage begins, Iroha has the opportunity to stop a small war. However, he's confronted by a member of Toshusai's faction, Yugata, who challenges him to a traumatic code duel!	01KGBDVHWCV5J2J7RKSE3T4R5G	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 2	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_150WTD8Z49T0	CNT_3V2P5285V100	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 5	[]	Cipher Academy, Vol. 5	The race to win the 50 billion morgue prize has finally begun! Iroha and his class A mates are up against class E, which specializes in infiltration and disguise. However, it seems like class E's leader, Shitai Kubinashi, is someone who has a deep connection to the Toshusai faction. As the battle to win the coveted cryptocurrency heats up, Tayu Yugata takes the lead!	01KG9SDRWXMPVAT4SCYRSYZB48	5.0	2025-01-17T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 5	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2025-02-25T08:00:00.000Z
PRD_2DKQA0V4PVH0	CNT_0J9FHKMT8JS0	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 4	[]	Cipher Academy, Vol. 4	The race to win the 50 billion morgue prize has finally begun! Iroha and his class A mates are up against class E, which specializes in infiltration and disguise. However, it seems like class E's leader Shitai Kubinashi is someone who has a deep connection to the Toshusai faction. As the battle to win the coveted cryptocurrency heats up, Tayu Yugata takes the lead!	01KG9RR8F7ZDVEYWXVMNBDBC3J	4.0	2024-12-05T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 4	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2024-12-10T08:00:00.000Z
PRD_2S126ZYRDG5G	CNT_3WPYTWE0HJWG	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 7	[]	Cipher Academy, Vol. 7	Iroha heads for the final floor of the Metaverse with Kasuri and Aki. However, if Iroha wants to move on, he'll have to face the sins of his past on the courtroom floor. Meanwhile, with the 50 billion morgue just around the corner, code soldiers are gathering one after another on the 499th floor, underground... The final code battle begins now!	01KGBQNWBHBF5B1K9A6KQ6WJXV	7.0	2025-07-11T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 7	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2025-08-26T07:00:00.000Z
PRD_2YN1BBGC8A6G	CNT_1175EJG9NT00	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 6	[]	Cipher Academy, Vol. 6	Welcome to the Crypto Academy Metaverse! Iroha and his friends are aiming for the 50 billion morgue that lies deep underground. However, on the 44th basement floor, an unexpected enemy awaits. Is it a code battle or a tabletop game battle? Whoever loses will be immediately logged out of the martial arts mahjong game!	01KG9QFDY9RW58BWKFV9BFMTXF	6.0	2025-04-04T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 6	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2025-05-27T07:00:00.000Z
PRD_3JHWKMVMJGNG	CNT_24Z7DEMV7J5G	Cipher Academy CNT_1NNQ757P2AVG	CNT_1NNQ757P2AVG	2	1	1	Volume 1	[]	Cipher Academy, Vol. 1	Welcome to Cipher Academy, a military academy where cipher soldiers are trained to decipher codes in preparation for coming wars. Iroha Irohazaka enrolls there unwittingly and struggles to keep up in class. Despite the inauspicious start, however, Iroha might very well be the key to ending all wars!	01KGBD436Y28ADVFG0KWHG1GHA	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Cipher Academy, Vol. 1	ANGO GAKUEN NO IROHA © 2022 by NISIOISIN, Yuji Iwasaki/SHUEISHA Inc.	2024-11-26T08: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);