database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_07944TGTBDJG"

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_09QRPV2W7FBG	CNT_3M44HTETAQQG	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 4	[]	Snowball Earth, Vol. 4	Who is the mysterious Colonel Sagami, leader of the band of kaiju tamers who call themselves the Light of E-RDE? What role did he have during the final battle against the intergalactic kaiju? These questions linger over the struggle for Mishima Mall as Tetsuo and his newfound friends fight to protect their home. The answers may reveal uncomfortable truths about the kaiju invasion of Earth, and a connection between the colonel and Tetsuo...	01KG9S801FFSA6F223JVGW8HB4	4.0	2024-12-19T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 4	SNOWBALL EARTH ©️ 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2025-01-21T08:00:00.000Z
PRD_0D20JA8TMPD0	CNT_30RYTXBM0N9G	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 8	[]	Snowball Earth, Vol. 8	After Tetsuo and his crew narrowly escape an attack from Gold Coast, one of the strongest kaiju around, they head toward the Australian continent to retrieve the Ultimate Body, said to be the key to saving humankind. There, Tetsuo learns of Hitohira's tragic history as a member of the original TRUE E-RDE. Tetsuo is also reunited with his father after ten long years, but not all reunions are happy...	01KH2WEKNP0XR9Y5FHSPN20ZXN	8.0	2026-01-16T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 8	SNOWBALL EARTH © 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2026-02-17T08:00:00.000Z
PRD_0Q47VP7WDBF0	CNT_0DWM4ABJFKW0	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 7	[]	Snowball Earth, Vol. 7	The vast power source found within Yukio's final form gives humanity a glimmer of hope toward securing Earth's safety. But on their way to a new village, Tetsuo and Yukio encounter a giant robot. What's more, this robot looks exactly like Yukio, but with black hardware! Will this unknown machine prove to be friend or foe? Then, Earth's icy battle heats up as one of the strongest kaiju smashes its way toward Tetsuo's crew from belowground!	01KGBYMB98H0T2X7HR1NT3STYF	7.0	2025-10-09T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 7	SNOWBALL EARTH ©️ 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2025-11-18T08:00:00.000Z
PRD_1SFHPEGMJSMG	CNT_2WXRAFM3ZVFG	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 1	[]	Snowball Earth, Vol. 1	Yukio was destroyed in battle and Tetsuo survived in an escape pod. After eight years in cold sleep, the escape pod finally lands back on Earth. But when Tetsuo emerges he finds a world in ruins, entirely frozen beneath a blanket of ice and snow—snowball Earth! What happened to humanity, how did the planet freeze over, and will Tetsuo be able to keep his last promise to Yukio?	01KGBGMC2SQVMAT2Z87XVC2MSD	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 1	SNOWBALL EARTH ©️ 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_2JNAVNPWH1FG	CNT_0BWBDHJA4SKG	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 3	[]	Snowball Earth, Vol. 3	After meeting the survivors of the icy apocalypse who are holed up in Mishima Mall, Tetsuo makes a few attempts at making friends. His defeat of the kaiju that attacked the mall has made him a hero to the inhabitants, but before he can establish any firm relationships, a new threat appears. Another band of human survivors, led by the mysterious Colonel, wants to seize control of the mall—and they have their own kaiju to do it with!	01KG9RQF6C7Q8Y82RVXXCVR05F	3.0	2024-12-05T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 3	SNOWBALL EARTH ©️ 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2024-12-10T08:00:00.000Z
PRD_381X02FF9YRG	CNT_3G17A13QXDY0	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 5	[]	Snowball Earth, Vol. 5	After the battle with Colonel Sagami and VIERDE, and fearing an attack by the kaiju in Tokyo, the leader of Mishima Mall determines that the settlement must move. Tetsuo volunteers to scout a possible hideout that Nayuta, a member of VIERDE, says he discovered. Can Tetsuo work with people who were his enemies just the day before? With a new paranormal kaiju lurking in the frozen wasteland, he'll need all the allies he can get!	01KG9QB2MWA4BREPRH761GR41B	5.0	2025-03-10T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 5	SNOWBALL EARTH © 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2025-04-15T07:00:00.000Z
PRD_3CPGXR7K60J0	CNT_0R7HQH099210	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 2	[]	Snowball Earth, Vol. 2	Ten years later, Tetsuo has returned to Earth in an escape pod, but finds the planet totally frozen over! To his horror, he discovers that the alien kaiju are also on Earth. After meeting a hardy band of human survivors, Tetsuo learns that Yukio has survived as well, his consciousness downloaded into the escape pod—which is also a battle robot! But the people Tetsuo has found are not the only survivors, and a mysterious humanoid kaiju also lurks among the ruins...	01KGBHK88F0QRFJ185W38WDHMQ	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 2	SNOWBALL EARTH ©️ 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3JEFPHDX5TFG	CNT_3GND7JHJYCTG	Snowball Earth CNT_07944TGTBDJG	CNT_07944TGTBDJG	2	1	1	Volume 6	[]	Snowball Earth, Vol. 6	Femlar, a man-eating kaiju controlled by Nadare, attacks Mishima Mall just before the survivors relocate. With Tetsuo out of the cockpit after a misunderstanding, Nayuta pilots a damaged Yukio to engage Femlar alongside Ao and Land of Men, but the childlike kaiju may be too much for them to handle. When all seems to be lost, a strange beckoning cat may prove to be the key to unlocking Yukio's final form—but at what cost?	01KGBQNGZ3CGWXR4KNH2MX685Q	6.0	2025-07-11T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Snowball Earth, Vol. 6	SNOWBALL EARTH © 2021 Yuuhiro TSUCHITSUGU/SHOGAKUKAN	2025-08-19T07: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);