products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_16YP3PFBZ270"
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_09KV0XCJ83C0 | CNT_2K533GJ00680 | The Detective Who Hopes for True Love CNT_16YP3PFBZ270 | 3 | 1 | 1 | Chapter 3 | [] | The Detective Who Hopes For True Love (3) | Naho's a single woman in her 30's with a past. She spends her days fighting off carnal urges. One morning, Detective Tsubasa Natsunaki visits her apartment asking for information on his case. Tsubasa's a gallant, handsome, loyal young man. Naho gets it into her head that just one time would be enough, and boldly asks Tsubasa for a favor. They've spent a night of passion together, but now what...? This is the unpredictable love story between a man who's pure of heart and a slightly empty-headed woman! | 01KGB6PWSSCPGKG346SG3TH937 | 3.0 | 2023-04-07T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | The Detective Who Hopes For True Love (3) | ©Linda Sumi/Taiseisha | 2023-04-07T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0AX8NAK8C4D0 | CNT_0KTP06XQN7F0 | The Detective Who Hopes for True Love CNT_16YP3PFBZ270 | 3 | 1 | 1 | Chapter 5 | [] | The Detective Who Hopes For True Love (5) | Naho's a single woman in her 30's with a past. She spends her days fighting off carnal urges. One morning, Detective Tsubasa Natsunaki visits her apartment asking for information on his case. Tsubasa's a gallant, handsome, loyal young man. Naho gets it into her head that just one time would be enough, and boldly asks Tsubasa for a favor. They've spent a night of passion together, but now what...? This is the unpredictable love story between a man who's pure of heart and a slightly empty-headed woman! | 01KGB7766TFJ4DC0HPBQE8SPM1 | 5.0 | 2023-04-07T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | The Detective Who Hopes For True Love (5) | ©Linda Sumi/Taiseisha | 2023-04-07T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1CYM2VKWDWMG | CNT_1WWMQWARKYGG | The Detective Who Hopes for True Love CNT_16YP3PFBZ270 | 3 | 1 | 1 | Chapter 2 | [] | The Detective Who Hopes For True Love (2) | Naho's a single woman in her 30's with a past. She spends her days fighting off carnal urges. One morning, Detective Tsubasa Natsunaki visits her apartment asking for information on his case. Tsubasa's a gallant, handsome, loyal young man. Naho gets it into her head that just one time would be enough, and boldly asks Tsubasa for a favor. They've spent a night of passion together, but now what...? This is the unpredictable love story between a man who's pure of heart and a slightly empty-headed woman! | 01KGB77DANMDNHJ99YCYCSFBPS | 2.0 | 2023-04-07T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | The Detective Who Hopes For True Love (2) | ©Linda Sumi/Taiseisha | 2023-04-07T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2BAKFK2DA4WG | CNT_1KGCGFRVVPRG | The Detective Who Hopes for True Love CNT_16YP3PFBZ270 | 3 | 1 | 1 | Chapter 4 | [] | The Detective Who Hopes For True Love (4) | Naho's a single woman in her 30's with a past. She spends her days fighting off carnal urges. One morning, Detective Tsubasa Natsunaki visits her apartment asking for information on his case. Tsubasa's a gallant, handsome, loyal young man. Naho gets it into her head that just one time would be enough, and boldly asks Tsubasa for a favor. They've spent a night of passion together, but now what...? This is the unpredictable love story between a man who's pure of heart and a slightly empty-headed woman! | 01KGB775QM9S53SQ73CQRTM3BH | 4.0 | 2023-04-07T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | The Detective Who Hopes For True Love (4) | ©Linda Sumi/Taiseisha | 2023-04-07T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3D7WV421BV40 | CNT_2WJB755WRE00 | The Detective Who Hopes for True Love CNT_16YP3PFBZ270 | 3 | 1 | 1 | Chapter 1 | [] | The Detective Who Hopes for True Love (1) | Naho's a single woman in her 30's with a past. She spends her days fighting off carnal urges. One morning, Detective Tsubasa Natsunaki visits her apartment asking for information on his case. Tsubasa's a gallant, handsome, loyal young man. Naho gets it into her head that just one time would be enough, and boldly asks Tsubasa for a favor. They've spent a night of passion together, but now what...? This is the unpredictable love story between a man who's pure of heart and a slightly empty-headed woman! | 01KGB77CW7R78X9T2Y8T43YG2T | 1.0 | 2023-04-07T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | The Detective Who Hopes for True Love (1) | ©Linda Sumi/Taiseisha | 2023-04-07T07: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);