products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where series_id = "CNT_2WRAYREY2QPG"
This data as json, CSV (advanced)
Suggested facets: level, description, display_order, listed_at, label_id, geoblock_id, copyright, on_sale_at, 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_0CNVXTX11TFG | CNT_2AMCRJXTQJWG | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The Third Chapter | [] | Clover The Third Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGC09ZSTYJP4RCKVQ81TSXXJ | 3.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The Third Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1FPPM59MA2PG | CNT_00HJ5E06DA5G | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The Fourth Chapter | [] | Clover The Fourth Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGBZGAQXE3AHNGP3XT64KSKP | 4.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The Fourth Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1XCM2SP3T6JG | CNT_0F8DTN94SDSG | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The Fifth Chapter | [] | Clover The Fifth Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGC09SA6X96QTV5454P00E88 | 5.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The Fifth Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1YY5Q6MSY7KG | CNT_2FXGVBMWAERG | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The First Chapter | [] | Clover The First Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGC09T9ERWXRY32Q1W5BQ5PS | 1.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The First Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07:00:00.000Z | 0 | 0 | ||||||
| PRD_30NHTY9DV1D0 | CNT_1NJ15EAP06QG | CLOVER CNT_2WRAYREY2QPG | CNT_2WRAYREY2QPG | 2 | 1 | 1 | Volume 1 | [] | CLOVER 1 | The sci-fi classic from the creators of xxxHOLiC and Cardcaptor Sakura returns, in a remastered, hardcover edition, featuring the entire CLOVER series. One of CLAMP's most ambitious works — part AKIRA, part Metropolis — CLOVER features nearly 500 pages of manga. Su was born into a bleak future, where the military keeps tight control over the few children born with magical abilities — known as ""Clovers."" The Clovers are forcibly tattooed with a symbol that indicates their potential power, and Su is the only four-leaf Clover in the world. Kept locked away in isolation her whole life, Su longs to find happiness in the outside world. An agent named Kazuhiko appears to help grant Su's wish, but he soon realizes that there is more to the mysterious girl than meets the eye... CLAMP's most daring science-fiction work, CLOVER's art-deco cyberpunk aesthetic is just as fresh and exciting today as it was twenty years ago. Featuring the entire story in a newly-revised translation; remastered art and lettering; a striking cover; and over 20 pages of color art, this is a great collectible for CLAMP fans, and the perfect way to get to know CLOVER for the first time. | 01KG9C83JSYSXGFHPNBWV99DA7 | 1.0 | 2020-06-30T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CLOVER 1 | CLAMP / Kodansha Ltd. | 2020-07-01T07:00:00.000Z | 0 | 0 | |||||
| PRD_33H3K2SNNQWG | CNT_3KCKJ32DCZFG | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The Sixth Chapter | [] | Clover The Sixth Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGC0AEW9HMV9673P1FRZPMAQ | 6.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The Sixth Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3Z7C8F7YW630 | CNT_3FJQBCE0GY80 | CLOVER CNT_2WRAYREY2QPG | 3 | 1 | 1 | The Second Chapter | [] | Clover The Second Chapter | England, late 19th century. Detective Andrew Drake has the ability to see visions. With the help of his ability and his medical student roommate Seth he's tracking down a serial murderer who's been slaughtering beautiful women in London. Now he's afraid that a young lady called Evangeline might be the next victim... but she's harboring a terrible secret. | 01KGC09SRP436KB8PDWEAT08A0 | 2.0 | 2025-10-16T07:00:00.000Z | Shusuisha LAB_0B1J4FVE44N0 | GEO_1PQM5BDYSMG0 | Clover The Second Chapter | ©Meguru Toujou/ShusuishaPOP | 2025-10-16T07: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);