products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_04Q33E58X12G"
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_0MN9G2H55QAG | CNT_0HTAF7BBGFF0 | The Anemone Feels the Heat CNT_04Q33E58X12G | CNT_04Q33E58X12G | 2 | 1 | 1 | Volume 3 | [] | The Anemone Feels the Heat, Vol. 3 | “What do I want to be to her?” Nagisa’s plan to stop hating Mashiro worked a lot better than she expected! But now that she’s confessed her feelings, Nagisa finds that liking Mashiro may not be quite as simple as she thought… | 01KKWPSX2C2MNGSMCF48J8ST3M | 3.0 | 2025-09-17T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GY29CRR8MV0 | The Anemone Feels the Heat, Vol. 3 | 2026-03-24T00:00:00.000Z | 0 | 0 | ||||||
| PRD_19ZVYBQ69HY0 | CNT_3E29R5HK7N1G | The Anemone Feels the Heat CNT_04Q33E58X12G | CNT_04Q33E58X12G | 2 | 1 | 1 | Volume 2 | [] | The Anemone Feels the Heat, Vol. 2 | “What does it mean to like someone?” Nagisa still isn’t sure… She thought she’d managed to go from hating Mashiro to liking her, but for some reason, seeing her face still makes her hexart pound like crazy! And when an older student’s words make her even more conscious of these confusing feelings, it gets hard to focus on anything else, especially now that she’s tutoring Mashiro for their upcoming exams. The more time they spend together, the more their feelings begin to overflow… | 01KG9QFW24TMW1G2B6SMPQV2KK | 2.0 | 2025-04-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | The Anemone Feels the Heat, Vol. 2 | 2025-08-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_243KQ88VNJ80 | CNT_3JSVN4VMX6NG | The Anemone Feels the Heat CNT_04Q33E58X12G | CNT_04Q33E58X12G | 2 | 1 | 1 | Volume 1 | [] | The Anemone Feels the Heat, Vol. 1 | “I want to learn to like you.”After screwing up the entrance exam for the high school she wanted, studious Nagisa has resolved to keep her chin up and move on. That is, until she meets a sickly girl named Mashiro at her new school—the very same girl who threw a wrench into her plans on exam day! Every time Nagisa looks her in the eye, she remembers her failure. Even so, she vows to warm up to Mashiro rather than hate her. And when Mashiro is inspired to change her own outlook on life, it may just bring them closer than Nagisa ever expected… | 01KGBESPXKJDBVM3GMT9XVAYWT | 1.0 | 2024-10-04T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | The Anemone Feels the Heat, Vol. 1 | 2025-04-02T07: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);