database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_1H9Y4GRAHPS0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_09RW17MG4C4G	CNT_1B1GR1S4KHF0	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 5	[]	APOSIMZ 5	Kajiwan's overreaching ambition ended in failure, and the weather-regulating satellite Ume crashed out of orbit. Etherow, who had held on to a sliver of hope that he could defeat Emperor Nichiko Suou, was badly injured and left barely clinging to life when Ume crashed to the surface. In the aftermath of Ume's crash, the Northern Composite Slab Region grows ever colder, and a new energy begins to rise...		01KG9CKRK0F951Y4YA9R32WD3Q	5.0	2020-06-12T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 5	Tsutomu Nihei / Kodansha Ltd.	2020-06-23T07:00:00.000Z
PRD_0MBYJ07HXHY0	CNT_036Z6G5V1650	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 8	[]	APOSIMZ 8	As Etherow, Titania, Keisha, and Wasabu, in disguise as civilians, continue to make their way towards the center of the Rebedoan Empire, they come across Rutohmero, a city on the outskirts that has been decimated by Frame disease. As the illness blights the Empire via airborne contaminant, the execution squad resurfaces, and Wasabu's fate hangs in the balance...		01KGADA9DW19HP7PEH6RADM28Q	8.0	2022-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 8	APOSIMZ Tsutomu Nihei/Kodansha Ltd.	2022-01-18T08:00:00.000Z
PRD_0T1FRVWKBZFG	CNT_2TVPCK456HC0	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 4	[]	APOSIMZ 4	While their fight against the Empire continues, Titania uses her sensing abilities to track King Kajiwan as he heads toward the forbidden place known as the Gosabyo. During their pursuit of Kajiwan, Titania and her allies encounter strange phenomenon and notice the Rebedoan army behaving in mysterious ways. The culprit turns out to be the terrifying power wielded by Emperor Nichiko Suou...		01KGA8JZSZ2R9Q8N3TK2A8P0XN	4.0	2020-02-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 4	Tsutomu Nihei / Kodansha Ltd.	2020-02-11T08:00:00.000Z
PRD_2KZVZ2YY4ZKG	CNT_0RN6THTWKK5G	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 6	[]	APOSIMZ 6	Keisha and Titania continue to hunt down Regular Frames in order to speed along Etherow's recovery. As Kajiwan creates Regenerateds from those afflicted with Frame Disease, the Empire deploys new weapons in its fight against both Titania's party and the True Core Church. When the Emperor himself makes a surprise appearance, Titania takes a chance that alters the future...		01KG9DX3NMFFKRKC99Q724TF10	6.0	2021-01-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 6	Tsutomu Nihei / Kodansha Ltd.	2021-01-19T08:00:00.000Z
PRD_2REQH4FG9ZZ0	CNT_3THCWNZ9F0XG	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 3	[]	APOSIMZ 3	The artificial celestial body Aposimz measures 120,000 km in diameter. Most of its volume is its core space, which is covered by a superstructural shell. Fifty centuries ago, the people who lost the war against the core lost their right to reside legitimately on Aposimz, and were stranded on the frigid surface. They face rampant Frame Disease and aggressive automatons which appear frequently on the Ruins Level. Yet even so, somehow the people survive.		01KG9BJQZ245GHKRW9JN1B5RQT	3.0	2020-02-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 3	Tsutomu Nihei / Kodansha Ltd.	2020-02-11T08:00:00.000Z
PRD_31C1BGPM7C90	CNT_31HMYKDJAH90	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 1	[]	APOSIMZ 1	Eo, Biko and Etherow, residents of the White Diamond Beam, are in the middle of combat training when suddenly a girl appears, Rebedoan Empire soldiers in hot pursuit. The girl asks for their help in keeping safe a “code” and seven mysterious “bullets.” This chance encounter marks a major shift in the fate of the entire planet...	This story takes place on the frigid, massive artificial planet known as Aposimz.	01KGA3RW84YZGBM0ZAS9DVTR0M	1.0	2018-10-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 1	(C) Tsutomu Nihei / Kodansha Ltd.	2018-10-31T07:00:00.000Z
PRD_37TYF6SFF5GG	CNT_027JT6GD6ZD0	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 7	[]	APOSIMZ 7	As the Rebedoan Empire continues to increase its ranks of Regular Frames, Etherow and his companions disguise themselves and sneak into Rebedoa proper. Emperor Nichiko Suou has the ability to see the future, making him a formidable opponent. But Etherow realizes that every time an AMB is fired, the future itself is altered. Does this mean he has a chance to take down the Emperor...?		01KG9G56P2K8AC3SZRVXJWXHRT	7.0	2021-06-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 7	Tsutomu Nihei / Kodansha Ltd.	2021-07-06T07:00:00.000Z
PRD_3TPKGCB674E0	CNT_0XHD5XB19QFG	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 9	[]	APOSIMZ 9	The population of Frame Disease sufferers continues to explode, and the Empire finds itself on the brink of collapse. As the conflict between Etherow's party and the Execution Squad takes a very dark turn, the stage for the final, intense battle is set. In this final volume, the secrets of the planet Aposimz and the truth behind the folklore about the Core world are revealed...		01KGAGSYKVNSGSC5GPYQFSSFK0	9.0	2022-06-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 9	APOSIMZ Tsutomu Nihei/Kodansha Ltd.	2022-07-05T07:00:00.000Z
PRD_3V2PQ5F6CX10	CNT_2M0E6MBS4SDG	APOSIMZ CNT_1H9Y4GRAHPS0	CNT_1H9Y4GRAHPS0	2	1	1	Volume 2	[]	APOSIMZ 2	The artificial celestial body Aposimz measures 120,000 km in diameter. Most of its volume is its core space, which is covered by a superstructural shell. Fifty centuries ago, the people who lost the war against the core lost their right to reside legitimately on Aposimz, and were stranded on the frigid surface. They face rampant Frame Disease and aggressive automatons which appear frequently on the Ruins Level. Yet even so, somehow the people survive.		01KGA5Q22BD56B2Q1Q1B1F1Z05	2.0	2019-04-19T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	APOSIMZ 2	(C) Tsutomu Nihei / Kodansha Ltd.	2019-04-30T07: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);