products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
9 rows where series_id = "CNT_2SAPN3Z9WH3G"
This data as json, CSV (advanced)
Suggested facets: level, description, display_order, copyright, 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_0CVQFVHEST20 | CNT_057G6SX6E23G | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 8 | [] | CULINARY DE TONGUETIVE, Chapter 8 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12MB8R0FMWNYWXP57W8HV | 8.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 8 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1K87SEJH5S10 | CNT_24JD6BKEX1CG | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 6 | [] | CULINARY DE TONGUETIVE, Chapter 6 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12J5Q16FK1SPJ6ZYMG8PK | 6.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 6 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1QYP41CV1R00 | CNT_07WT1N9Q80DG | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 4 | [] | CULINARY DE TONGUETIVE, Chapter 4 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12H1V82ZDJFBGZGAGR7PP | 4.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 4 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1TF6QMEXA770 | CNT_276Q10ZZQZEG | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 2 | [] | CULINARY DE TONGUETIVE, Chapter 2 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12FS8XX7SE26VFVFWCTD7 | 2.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 2 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1YXH1787P660 | CNT_06H40JM82YFG | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | CNT_2SAPN3Z9WH3G | 2 | 1 | 1 | Volume 1 | [] | CULINARY DE TONGUETIVE, Volume 1 | The master of the Izakaya "Arakan" is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KG9VK140NCCJM9RNA8JZ53CW | 1.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Volume 1 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | |||||
| PRD_2D0Z040C7THG | CNT_14WPP2RAMHK0 | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 7 | [] | CULINARY DE TONGUETIVE, Chapter 7 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12KMRZMQPKS4GJ0PJHPGP | 7.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 7 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3HHFKRXP3SGG | CNT_3473PCEK3GW0 | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 5 | [] | CULINARY DE TONGUETIVE, Chapter 5 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12HKSM9AZNFMRGX4BX1B9 | 5.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 5 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3M7YXBZRFRQG | CNT_17HGHY4VHFX0 | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 3 | [] | CULINARY DE TONGUETIVE, Chapter 3 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KGA12GD94Y0VHP4R2SD5D3TB | 3.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 3 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3RM98YS287PG | CNT_36WDH9S3WEY0 | CULINARY DE TONGUETIVE CNT_2SAPN3Z9WH3G | 3 | 1 | 1 | Chapter 1 | [] | CULINARY DE TONGUETIVE, Chapter 1 | The master of the Izakaya ”Arakan” is also a famous detective. In accordance with the veteran police detective Numata's request, he joins the investigations. A gruelling detective story blended lightly with cuisine and seasoned with some human drama. | 01KG9VK2PA3GP2PYRFPMCAM4N7 | 1.0 | 2017-12-12T15:00:00.000Z | NIHONBUNGEISHA LAB_0Y5SK4HXM8H0 | GEO_1PKAG51AEAQG | CULINARY DE TONGUETIVE, Chapter 1 | (C)SHIGERU TSUCHIYAMA / NIHONBUNGEISHA Co.,Ltd. | 2017-12-12T15: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);