products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_2AQZ6E9A2FM0"
This data as json, CSV (advanced)
Suggested facets: listed_at (date), on_sale_at (date)
| id ▼ | content_id | series_id | parent_content_id | level | content_type | product_type | title | alt_titles | subtitle | display_title | display_title_short | description | description_short | image_id | display_order | listed_at | label_id | geoblock_id | display_name | copyright | on_presale_at | on_sale_at | off_sale_at | add_on | add_on_campaign_only |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRD_0PBQZPK3M200 | CNT_2D4YENX9G1VG | Guardian: Zhen Hun CNT_2AQZ6E9A2FM0 | CNT_2AQZ6E9A2FM0 | 2 | 2 | 1 | Volume 1 | [] | Guardian: Zhen Hun Vol. 1 | Zhao Yunlan heads up a covert division of the Ministry of Public Security that deals with the strange and unusual, blurring the line between the mortal realm and the Netherworld. His cocky, casual attitude conceals both a sharp mind and an arsenal of mystical tools and arcane knowledge. While investigating a gruesome death at a local university, Zhao Yunlan crosses paths with the reserved Professor Shen Wei. Zhao Yunlan is immediately intrigued by Shen Wei's good looks and intense gaze, and the attraction between them is immediate and powerful, even as Shen Wei tries to keep his distance. Shen Wei and his secrets are a puzzle Zhao Yunlan feels compelled to solve as mysterious circumstances throw them together, and their connection becomes impossible to deny. | Investigations in the Dark | 01KH3EPM2CSXD2YRWVA9EQ3KDX | 1.0 | 2023-07-20T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1NT691A6VGSG | Guardian: Zhen Hun Vol. 1 | Priest, English edition copyright 2023 Seven Seas Entertainment, Inc. | 2023-08-29T07:00:00.000Z | 0 | 0 | ||||
| PRD_1Q3AMXSQV850 | CNT_2RS4QVB8EVCG | Guardian: Zhen Hun CNT_2AQZ6E9A2FM0 | CNT_2AQZ6E9A2FM0 | 2 | 2 | 1 | Volume 3 | [] | Guardian: Zhen Hun Vol. 3 | When a mysterious illness knocks Zhao Yunlan off his feet, he enjoys being doted on by Shen Wei--until he discovers a grim secret that threatens to tear them apart. However, it's not just their domestic bliss that's on the verge of collapse. The Great Seal is cracking, order itself is about to break down and extinguish all life, and their only hope to stop the destruction is the final Hallowed Artifact: the Soul-Guarding Lamp. But even as the world threatens to crumble around them, Zhao Yunlan searches for the truth and a way to keep Shen Wei by his side, this time for all eternity. | WILL YOU CHOOSE TO DIE WITH ME AND RETURN TO CHAOS FOR ALL ETERNITY? | 01KGBA2B1DQEESTF22AYW6GVMT | 3.0 | 2024-05-16T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1NT691A6VGSG | Guardian: Zhen Hun Vol. 3 | © Priest, English edition copyright © 2024 Seven Seas Entertainment, Inc. | 2024-08-13T07:00:00.000Z | 0 | 0 | ||||
| PRD_2MFPRCBJPFGG | CNT_3Q0P51CJ8YB0 | Guardian: Zhen Hun CNT_2AQZ6E9A2FM0 | CNT_2AQZ6E9A2FM0 | 2 | 2 | 1 | Volume 2 | [] | Guardian: Zhen Hun Vol. 2 | As snow quietly covers Dragon City in the final days of the lunar year, patients writhing in pain flock to the hospital. Baffled doctors call upon Zhao Yunlan and his team for help. As the case unfolds, Shen Wei and Zhao Yunlan discover that one of the Four Hallowed Artifacts, the Merit Brush, has appeared in the Mortal Realm. In the wrong hands, its power can be transformative. While each step toward the artifact only pulls the pair deeper into a vortex of mysteries, Zhao Yunlan keeps stumbling upon a name: Kunlun. Who is Kunlun, and what is his connection to the Merit Brush? As Zhao Yunlan closes in on the answer, will he also uncover the truth behind Shen Wei's knowing gaze? | THE SLEEPING GOD STIRS | 01KG9PTA76A05JY7J3A1GACGTA | 2.0 | 2024-02-19T08:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1NT691A6VGSG | Guardian: Zhen Hun Vol. 2 | Priest, English edition copyright 2024 Seven Seas Entertainment, Inc. | 2024-03-26T07:00:00.000Z | 0 | 0 |
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);