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

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_049MDSDDP8PG	CNT_0ZBZ0MJKP29G	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 5	[]	COLORLESS Vol. 5	In a world almost entirely stripped of color, the rare scraps of pigment that remain hold tantalizing power. A secretive cult known as the Order would use that power to see color returned to the world through the advent of their chromatic god...but the birth of a god requires bloody sacrifice. An eldritch creature rises, bathing a grey city in angry red. Avidia stands alone against a monster born from his best friend's death!	THE WORLD DYED RED	01KGASX22FJCH9PAJBV22ZDJPC	5.0	2023-10-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 5	KENT 2021	2023-12-12T08:00:00.000Z
PRD_0BJ4ZPQXQ78G	CNT_06TYF9PW3730	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 6	[]	COLORLESS Vol. 6	In a world where all humanity has mutated into strange new forms, Chie is the odd one out. She looks exactly like the humans of ages past. It's because she's an android--but who made her, and why? The answers to those questions might finally be in her grasp, hidden somewhere in the deserted city of Chuudoh. But the Order still has plans for Chie and Avidia, as they prepare another offering, this time to create a deity of cold and bitter blue...	MEMORIES IN CRYSTAL BLUE	01KG9PSPMJ8TC2MD48XAVR7RMW	6.0	2024-02-19T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 6	KENT 2022	2024-03-12T07:00:00.000Z
PRD_0E1PBZZBWY3G	CNT_319Y9AHKK0SG	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 4	[]	COLORLESS Vol. 4	A cosmic disaster erased almost all color from the world, and now the mutated descendants of humanity live in a moody, noir cityscape draped with shades of grey. There is great power hidden in what little color remains, and a secretive cult known as the Order hopes to use that power to awaken their mysterious gods. Standing against them is Avidia, a gun-toting investigator and scientist who works outside the law. If he's to prevail, he'll need more power--which means surviving an incredibly dangerous new experiment, even as the Order moves ahead with the consummation of all their schemes!	THE ADVENT OF THE DIVINE CHROMA	01KGB5YAX2EF3ZD1Y2ETTKHKJT	4.0	2023-03-03T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 4	KENT 2021	2023-05-09T07:00:00.000Z
PRD_0ZRBK3BGK2X0	CNT_3C0V1D6YSDZ0	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 2	[]	COLORLESS Vol. 2	A cosmic disaster stripped color from the Earth, leaving behind a mutated humanity that lives in a world of moody black and grey. Most of the technology and history of the old world is forgotten, but there is tantalizing promise in the dangerous new field of chromadynamics. A rogue scientist named Avidia is on the hunt for the world's last remaining scraps of color, but he's not the only one. A mysterious cult has found a way to turn pigment into fearsome power, and they'll kill anyone who challenges their authority. Armed with his wits and peerless gun, it'll take everything Adivia has to stay one step ahead!	GUNS ROAR IN A WORLD WITHOUT COLOR	01KGB295FKE5Y74E9VRFX7QDMH	2.0	2022-10-24T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 2	KENT 2020	2022-11-15T08:00:00.000Z
PRD_2CFNCVRKG2CG	CNT_3FZ66GATXRS0	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 1	[]	COLORLESS Vol. 1	A cosmic disaster changed the Earth forever, stripping away every last drop of color from the world. Mankind also changed: the familiar human face is almost forgotten in a world now populated wholly by mutants. Against the backdrop of a moody urban landscape, a lone-wolf investigator named Avidia relies on both his wits and extraordinary gun to hunt down the world's last hidden scraps of color. He soon crosses paths with a very special girl--one who just might hold the key to bringing back what the world has lost.	A stylish noir-punk thriller set in a world stripped of its color and humanity!	01KGAGXY92GGKG7FJFAYWPN485	1.0	2022-04-20T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 1	KENT 2019	2022-05-17T07:00:00.000Z
PRD_2TMJF5972AJG	CNT_3WF1M7YHPDAG	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 7	[]	COLORLESS Vol. 7	The first Mercy Pulse robbed the world of color, leaving humanity mutated in its wake. Now, using the power of their "Divine Chroma," the Iodopsy Order are on the verge of engineering a second Mercy Pulse. Driven by the madness of their faith, they don't care what the consequences might be for the human race. Avidia narrowly prevailed against the Order's sapphire-tinted god, but now he's grievously wounded and cut off from all his friends. To rescue Chie, he's ready to launch an all-out war against the Order, before calamity descends upon the world!	THE EPIC CONCLUSION TO THE STYLISH TALE OF A WORLD BEREFT OF COLOR!	01KGBBX0RX25Z391V724H8JK8T	7.0	2024-07-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 7	© KENT 2023	2024-07-23T07:00:00.000Z
PRD_3STNEM2JHPQ0	CNT_0DTFP45C11N0	COLORLESS CNT_28KWCF4NJTY0	CNT_28KWCF4NJTY0	2	1	1	Volume 3	[]	COLORLESS Vol. 3	A massive solar flare erased nearly all color from the surface of the Earth, and the mutated descendants of the human race exist in a state of slow decline. What little color remains now holds a strange and seductive power. Some people, like the lone-wolf professor Avidia, try and understand it. Others, including the cult-like Iodopsy Order, use it for power and control. When an Order assassin draws innocent bystanders into their rivalry, it'll take everything Avidia has to save their lives...and his own!	THE POWER OF COLOR	01KGB3W7N5N6T1R3EE70CXVJVV	3.0	2022-12-02T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	COLORLESS Vol. 3	KENT 2020	2022-12-20T08: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);