products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
2 rows where series_id = "CNT_2XE18BXNC670"
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_3W6ENV113Q8G | CNT_2D5PYPYQNSJG | Helena and Mr. Big Bad Wolf CNT_2XE18BXNC670 | CNT_2XE18BXNC670 | 2 | 1 | 1 | Volume 1 | [] | Helena and Mr. Big Bad Wolf, Vol. 1 | Helena has always found her strength through stories. When her father left and didn’t come home one night, and when Arthur, her only brother, got into an accident…reading and creating stories was what kept Helena going. By a stroke of luck, she attends an autograph signing of her favorite author, Mr. Big Bad Wolf, and the two grow closer, bonding over their shared love for storybooks. The cold, reserved man with a wolf head is shrouded in mystery, but perhaps he has a gentler side only Helena can see… | 01KGBD4ZWEGQXQ0M6S7KMB0Q3F | 1.0 | 2024-09-26T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Helena and Mr. Big Bad Wolf, Vol. 1 | 2025-02-25T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3XX1X8EK7M9G | CNT_0CDW9NNNR8N0 | Helena and Mr. Big Bad Wolf CNT_2XE18BXNC670 | CNT_2XE18BXNC670 | 2 | 1 | 1 | Volume 2 | [] | Helena and Mr. Big Bad Wolf, Vol. 2 | When life plunges us into the darkest depths, the light of creation is what guides us forward.Having learned the truth about her brother, Arthur, Helena runs from the orphanage in a fit of despair. When Mr. Big Bad Wolf discovers her—cold, drenched, and all alone on the doorstep of the art gallery—he decides to take her in. In an attempt to understand his troubled friend, he suggests they complete her picture book together. Yet as the two share their ideas, he begins to realize he might need her just as much as she needs him. Connected by their love for creating, perhaps the lonely pair will finally find in each other a place to call home… | 01KG9QG05PPG47TRKWFEXH3KM3 | 2.0 | 2025-04-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Helena and Mr. Big Bad Wolf, Vol. 2 | 2025-08-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);