products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where series_id = "CNT_39E69THA691G"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_1NAA8362S7W0 | CNT_23ZZMQ0904AG | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 1 | [] | Unnamed Memory, Vol. 1 | <P> Once upon a time in a faraway land, a beautiful witch lived atop a tall tower with no intention of descending. Instead, she awaited the brave knight who would overcome many perils to meet her. Should someone triumph over her many traps, she would grant them any one wish. One day, such a courageous prince did arrive, and he asked her to rid him of the curse preventing him from siring an heir. But the curse of another witch cannot be so easily lifted, and the only way to save his bloodline... is to become his bride?!  </P> | 01KGAK2FR01E123C5RJTACQMGY | 1.0 | 2022-09-28T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Unnamed Memory, Vol. 1 | 2022-10-04T00:00:00.000Z | 0 | 0 | ||||||
| PRD_21NK3D3D00B0 | CNT_3FG35E9T2C10 | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 2 | [] | Unnamed Memory, Vol. 2 | To lift the curse on his bloodline, Prince Oscar climbed the perilous Azure Tower and brought the beautiful witch Tinasha to live with him in his castle, but still, he is no closer to a solution. His only hope is making Tinasha his bride, and while whispers about their relationship can be heard throughout the castle, she remains unresponsive to his romantic overtures. However, one night when they secretly meet, Oscar accidentally ingests an aphrodisiac in front of Tinasha… | 01KGB2NSK20MWJHVPBJAQVMWZE | 2.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Unnamed Memory, Vol. 2 | 2023-02-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2CGP1HM1SZFG | CNT_2XJDTKQ3GB3G | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 5 | [] | Unnamed Memory, Vol. 5 | Tinasha has yet to show herself since discovering Miralys is a candidate to become Oscar’s fiancée. Shut away in her tower, Tinasha continues to analyze the Witch of Silence’s curse that has long afflicted Oscar. Will Oscar succeed in breaking down the walls Tinasha builds to separate herself from the people around her…? | 01KH3QFMRV5YCRAQMS9GJTVN49 | 5.0 | 2024-04-09T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Unnamed Memory, Vol. 5 | 2024-06-18T07:00:00.000Z | 0 | 0 | ||||||
| PRD_37ZYZTMX7RW0 | CNT_3VCFW3YKA520 | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 3 | [] | Unnamed Memory, Vol. 3 | Long ago, a fearsome beast emerged from Druza’s Magical Lake and terrorized the people of Farsas until it was finally sealed away by the powerful Witch of the Azure Moon, Tinasha. However, a remnant group from the past now threatens to release the terrible creature. Obligation once again falls toTinasha, and she must finish off the monster—this time, for good. But can she triumph when all she could once manage was a stalemate? | 01KGB4FNTZMMPNKM3VHCQTJK30 | 3.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Unnamed Memory, Vol. 3 | 2023-06-20T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3B164M75WCT0 | CNT_1A79V4BEGPH0 | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 4 | [] | Unnamed Memory, Vol. 4 | With Tinasha heading back to her tower for a few days, Oscar is left without his guardian’s supervision. Despite all her warnings to stay safe at home (nagging, if you ask him), Oscar ventures out of the castle to investigate a series of mysterious disappearances in a forest in eastern Farsas. There, he runs into his second witch—Lucrezia, the Witch of the Forbidden Forest! But is every witch as sweet and helpful as Tinasha…? | 01KH3GXKYVFSD58Y1FTB123NSW | 4.0 | 2023-08-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Unnamed Memory, Vol. 4 | 2024-01-30T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3BSQ82RZ14EG | CNT_0HX7WHW1YCXG | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 7 | [] | Unnamed Memory, Vol. 7 | Accompanying her former fiancé, Lanak, Tinasha has vanished to the newly founded magical nation of Cuscull. Oscar resolves to bring Tinasha back after learning about her past from Lucrezia, Witch of the Forbidden Forest. When a missive arrives from Cuscull demanding the subjugation of the Four Great Nations, Oscar discovers that their invasion of Tayiri has already begun! And what of the news that a town in Tayiri has been wiped out by the Witch of the Azure Moon…? | 01KGC0Z1BBWJNTS9G71PV66E2Z | 7.0 | 2025-10-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Unnamed Memory, Vol. 7 | 2026-01-20T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3PH9N3KY5R90 | CNT_16Q0MAZSZTH0 | Unnamed Memory CNT_39E69THA691G | CNT_39E69THA691G | 2 | 1 | 1 | Volume 6 | [] | Unnamed Memory, Vol. 6 | The incident with Miralys winds down, bringing only more questions about her motivations. Despite the confusion, Oscar and Tinasha continue spending the year together in accordance with their contract. The days are peaceful, and the impending celebration of the king’s birthday promises to bring a great many guests from surrounding nations.But Tinasha remains weighed down by her mysterious past, and the question of how to deal with Oscar’s hereditary curse still looms… | 01KGBDZD9AQ2KQMJXRG5GWZBKV | 6.0 | 2024-09-26T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Unnamed Memory, Vol. 6 | 2025-03-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);