products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_2BMYAZDJQJJG"
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_0SNF9JFN8SK0 | CNT_0XK1VEW9JX50 | Fiance of the Wizard CNT_2BMYAZDJQJJG | CNT_2BMYAZDJQJJG | 2 | 1 | 1 | Volume 2 | [] | Fiancée of the Wizard, Vol. 2 | An ordinary story with an extraordinary love... With Egiedeyrus’s time at school behind him, he’s quickly appointed as the prestigious Chief Enchanter to the Court. Though Filimena hopes their nuptials will soon follow, Edy’s busy work schedule continues to obstruct their time together. Despite setbacks, Filimena is content to wait, but the evolution of her new life takes an ominous turn with news of the Lord of Darkness’s resurrection...The worst is still yet to come, however, as Edy must join the Hero’s party on a quest to save the kingdom! | 01KG9DJQBZNSPEFNDFBD1K5W0Z | 2.0 | 2020-11-26T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Fiancée of the Wizard, Vol. 2 | 2021-01-26T08:00:00.000Z | 0 | 0 | ||||||
| PRD_1SPY4BYJNHC0 | CNT_24GTKNG8E640 | Fiance of the Wizard CNT_2BMYAZDJQJJG | CNT_2BMYAZDJQJJG | 2 | 1 | 1 | Volume 3 | [] | Fiancée of the Wizard, Vol. 3 | AS THE HONEYMOON GLOW SUBSIDES, NEW TROUBLES DARKEN THE HORIZON... After the defeat of the Lord of Darkness who threatened the kingdom, peace has returned to the land. Filimena has, at last, wed her surly wizard, the powerful chief enchanter, Egiedeyrus, but their marriage remains a secret. Despite this, their life together is a happy one-until dark nightmares begin to steal Filimena's sleep... | 01KG9DZGGJ6BPW58R72G8P7XAF | 3.0 | 2021-01-27T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Fiancée of the Wizard, Vol. 3 | 2021-03-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2QSCW12Y35R0 | CNT_3N8RZVP84S0G | Fiance of the Wizard CNT_2BMYAZDJQJJG | CNT_2BMYAZDJQJJG | 2 | 1 | 1 | Volume 4 | [] | Fiancée of the Wizard, Vol. 4 | Will Love Be Enough to Overcome This Final Battle...? Despite being a newlywed, things are far from rosy and carefree for Filimena, as she’s continually plagued by dark nightmares of the person she used to be in her previous life. And no matter how powerful Egiedeyrus is, even he’s struggling to break the curse…and time is running out. Filimena must figure out a way to confront the ghost of her past before it tears her away from Edy-forever! | 01KG9HDN1M1D30XA0HSPCZWS0R | 4.0 | 2021-11-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Fiancée of the Wizard, Vol. 4 | 2021-12-28T08:00:00.000Z | 0 | 0 | ||||||
| PRD_348SWA6242TG | CNT_357QFPC6NPS0 | Fiance of the Wizard CNT_2BMYAZDJQJJG | CNT_2BMYAZDJQJJG | 2 | 1 | 1 | Volume 1 | [] | Fiancée of the Wizard, Vol. 1 | Went looking for magic but found love instead...Filimena via Adina, daughter of nobility, awakens one day with the realization that she had actually been reborn into a world of sorcery and given a second chance at life. In her new country full of heroes, she expects this means she’s a chosen one, yet her lot is not as she dreamed—instead, her path crosses with the improbably powerful stepson of a wizard, and as a young noble lady, her place is at his side...as his fiancée! But perhaps a quest for love is exactly the adventure she was looking for... | 01KG9CAX31ABAW8TS865C9Z5AV | 1.0 | 2020-07-31T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Fiancée of the Wizard, Vol. 1 | 2020-08-25T07: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);