products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_326648THTQ8G"
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_0ME2J2GWXF80 | CNT_20FTCYPB5ZY0 | 15 Minutes Before We Really Date CNT_326648THTQ8G | CNT_326648THTQ8G | 2 | 1 | 1 | Volume 3 | [] | 15 Minutes Before We Really Date, Vol. 3 | Now that their last winter vacation as high school students has ended, Natsuha goes to Tokyo for her college entrance exams, and Yuuki begins to consider the future of their relationship. But Natsuha seems to be…reluctant to do so? With the distance between them, the two are deep in their own thoughts… | 01KG9PMQS4N9VQR92HG74D567G | 3.0 | 2024-01-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | 15 Minutes Before We Really Date, Vol. 3 | 2024-07-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2717GBSV63X0 | CNT_05DDJF4CB64G | 15 Minutes Before We Really Date CNT_326648THTQ8G | CNT_326648THTQ8G | 2 | 1 | 1 | Volume 4 | [] | 15 Minutes Before We Really Date, Vol. 4 | Tension is in the air after Natsuha learns that Yuuki’s been getting a little too close to another girl in school, the popular influencer Airi Hina. This makes Natsuha question just how important to Yuuki she really is. The two had better reconcile fast—life beyond high school is almost here, and they’ve got a lot to talk about! With a future ahead of them yet unwritten, will Yuuki and Natsuha reach their happy ending together? | 01KH3QSW7MMM2GSTYSXM8JCRDX | 4.0 | 2024-05-08T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | 15 Minutes Before We Really Date, Vol. 4 | 2024-10-15T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2TRFHWYPJZ40 | CNT_1Z7X1MBTK9V0 | 15 Minutes Before We Really Date CNT_326648THTQ8G | CNT_326648THTQ8G | 2 | 1 | 1 | Volume 2 | [] | 15 Minutes Before We Really Date, Vol. 2 | Childhood friends Yuuki and Natsuha live in the same apartment complex, and they’ve recently starting dating (at last)! Now their first Christmas is coming up-how will they handle that famously romantic holiday? | 01KGAT43AZTERPR01KXVTZVHNE | 2.0 | 2023-10-30T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | 15 Minutes Before We Really Date, Vol. 2 | 2024-04-16T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3XR8VNEY2A10 | CNT_3X5V0Y6CVSTG | 15 Minutes Before We Really Date CNT_326648THTQ8G | CNT_326648THTQ8G | 2 | 1 | 1 | Volume 1 | [] | 15 Minutes Before We Really Date, Vol. 1 | Growing up in the same apartment complex, Yuuki and Natsuha have known each other forever. They’ve been friends for so long that everyone just assumes they’re a couple! But as they both approach the final stretch of high school, they get a silly, totally-not-serious idea— what if they actually started dating? What a ridiculous thing to say! Unless…? | 01KH3ECBKVXMJK282TVXD5WGSG | 1.0 | 2023-05-31T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | 15 Minutes Before We Really Date, Vol. 1 | 2023-11-21T00: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);