products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
1 row where series_id = "CNT_1AH44P16YGE0"
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_0RTNBCJCKMM0 | CNT_0CEERQ3QQK40 | Apple Black Origins: The Spectrum and the Spectre CNT_1AH44P16YGE0 | CNT_1AH44P16YGE0 | 2 | 1 | 1 | Volume 1 | [] | Apple Black Origins: The Spectrum and the Spectre | "In this light-novel prequel to the Apple Black series, Willow and Gideon together take on the evils that riddle Eden in their adventure to find gold. Many years ago, humans acquired "Black" fruits from a tree that descended from the skies, turning humans into sorcerers. Although all of Black is now extinct, humans still have sorcery inherited from their ancestors. In this fantastical world of wands and sorcerers, The Ebony Peak wars led to the new regime of Eden, but its policy left behind many stricken and near-extinct tribes who've now formed rebellions against the new rule. In Apple Black Origins, a pivotal origin story about the fantastical world of Apple Black, Willow, a wild young sorceress with mysterious vitiligo, looks to end the discrimination towards her tribe and others by finding all the legendary Golden Wands, like the one she got from her father, to help balance the scales. She enlists the help of a powerful rogue sorcerer, Gideon Banburi, to find salvation, though he may be more trouble than she anticipates. Gideon and Willow are hunted by Rebels, secret organizations, and the new regime to find a wand using a map that was hidden within it. In time, it's revealed that Willow's vitiligo is actually the map that leads them to the wands—but not before treachery repeatedly crosses their path. Apple Black Origins is rated T for Teen, recommended for ages 13 and up. Saturday AM, the world's most diverse manga-inspired comics, are now presented in a new format! Introducing Saturday AM TANKS, the new graphic novel format similar to Japanese Tankobons where we collect the global heroes and artists of Saturday AM. These handsome volumes have select color pages, revised artwork, and innovative post-credit scenes that help bring new life to our popular BIPOC, LGBTQ, and/or culturally diverse characters." | 01KGBNWKF92SAQANF9DTNCHNK1 | 1.0 | 2024-08-23T07:00:00.000Z | Saturday AM LAB_3ZNR3TE0ZDZ0 | GEO_1PQM5BDYSMG0 | APPLE BLACK ORIGINS : THE SPECTRUM AND THE SPECTRE, APPLE BLACK ORIGINS : THE SPECTRUM AND THE SPECTRE | (C) 2024 Odunze Oguguo, Stephanie Williams, Saturday AM | 2025-06-04T07: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);