products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_2FSJC6BJM3N0"
This data as json, CSV (advanced)
Suggested facets: listed_at, on_sale_at, 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_0JQZ8M6483X0 | CNT_0N3JMVZQZMZG | Sweet Intimacy CNT_2FSJC6BJM3N0 | 3 | 1 | 1 | Chapter 4 | [] | SWEET INTIMACY (4) | Shuri's sweet romance is reaching its climax with a 100-page story! What will Shuri say to the hot, successful, and charismatic pastry chef when he asks her to come to Paris with him!? | 01KGA8YC89KWYKGDSYMTQRAE7A | 4.0 | 2020-04-01T07:00:00.000Z | Hakusensha LAB_254RC5A3DQ30 | GEO_1PQM5BDYSMG0 | SWEET INTIMACY (4) | (C)Mimi Komakiya | 2020-07-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1M4ZTJRCMM5G | CNT_0S0VXDYT5SDG | Sweet Intimacy CNT_2FSJC6BJM3N0 | 3 | 1 | 1 | Chapter 1 | [] | Sweet Intimacy (1) | After Shuri catches her boyfriend with another woman, she decides to restart both her career and her love life. Still, new beginnings always have their own problems... A sweet story of love with a hefty helping of sugar. | 01KGA3QGGMPHZK3ASNBBXT5BXT | 1.0 | 2018-10-01T07:00:00.000Z | Hakusensha LAB_254RC5A3DQ30 | GEO_1PQM5BDYSMG0 | Sweet Intimacy (1) | (C)Mimi Komakiya | 2018-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2GZ71YH9P2CG | CNT_1MS94WTW44F0 | Sweet Intimacy CNT_2FSJC6BJM3N0 | 3 | 1 | 1 | Chapter 3 | [] | SWEET INTIMACY (3) | Shuri's parents reach out to her, proposing an arranged marriage. She tries to make Soya jealous by telling him, but... he doesn't even try to stop her!! A sweet love story that'll leave you begging for seconds! | 01KGA8YBNKVX1SM94ZZT7YBXFG | 3.0 | 2020-04-01T07:00:00.000Z | Hakusensha LAB_254RC5A3DQ30 | GEO_1PQM5BDYSMG0 | SWEET INTIMACY (3) | (C)Mimi Komakiya | 2020-07-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2QDPCHJKJ2KG | CNT_3M364EF4K380 | Sweet Intimacy CNT_2FSJC6BJM3N0 | 3 | 1 | 1 | Chapter 2 | [] | SWEET INTIMACY (2) | Shuri and Soya seem to be doing well despite the rough start when they first met! Shuri's enjoying her new romance when out of nowhere, a woman with a secret comes back into Soya's life... Get ready for 50 pages of sweet, sweet addiction! | 01KG9BKRJS105W0VDY07A63J1J | 2.0 | 2020-04-01T07:00:00.000Z | Hakusensha LAB_254RC5A3DQ30 | GEO_1PQM5BDYSMG0 | SWEET INTIMACY (2) | (C)Mimi Komakiya | 2020-06-01T07: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);