products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_0HEV3RSF60W0"
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_03PGYJN32FT0 | CNT_3CQF6HWRJ2J0 | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 8 | [] | A Red Camellia with a Hot Needle Ch. 8 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGBBZW7NM38S2B1PJ1PM8XT1 | 8.0 | 2024-08-02T07:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 8 | (C) Akira Sasayama/KOOI. | 2024-08-02T07:00:00.000Z | 0 | 0 | ||||||
| PRD_066EPE41BPRG | CNT_1C7CWZHAM3BG | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 3 | [] | A Red Camellia with a Hot Needle Ch. 3 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGAVWBHCAN5GHAAV1PR0CHG9 | 3.0 | 2023-12-21T08:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 3 | (C) Akira Sasayama/KOOI. | 2023-12-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0HFXHFK6ZBNG | CNT_3BKBJV40N8EG | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 4 | [] | A Red Camellia with a Hot Needle Ch. 4 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGAVWKQJBM28BPDYH5Y3P0Z9 | 4.0 | 2023-12-21T08:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 4 | (C) Akira Sasayama/KOOI. | 2023-12-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0RKH0CSPT1M0 | CNT_3A257MG7R4G0 | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 10 | [] | A Red Camellia with a Hot Needle Ch. 10 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGBBZYKB6BEDZ3GJPQRK13V2 | 10.0 | 2024-08-02T07:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 10 | (C) Akira Sasayama/KOOI. | 2024-08-02T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1CG5EJ6ZNC70 | CNT_08KR30MM1SW0 | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 5 | [] | A Red Camellia with a Hot Needle Ch. 5 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGAVWNGFAEEXZNAXECB3Z56T | 5.0 | 2023-12-21T08:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 5 | (C) Akira Sasayama/KOOI. | 2023-12-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_24CB1E6ACD8G | CNT_2FPJP4C57HCG | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 6 | [] | A Red Camellia with a Hot Needle Ch. 6 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGBBZTW6XMY0JQ4HHF5AHHAF | 6.0 | 2024-08-02T07:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 6 | (C) Akira Sasayama/KOOI. | 2024-08-02T07:00:00.000Z | 0 | 0 | ||||||
| PRD_28W1TBH8NMF0 | CNT_0F6GFJ2Q9J40 | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 1 | [] | A Red Camellia with a Hot Needle Ch. 1 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGATKP8BEV26FDN3NCZH9WYY | 1.0 | 2023-12-21T08:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 1 | (C) Akira Sasayama/KOOI. | 2023-12-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2QNYWFDFG25G | CNT_0B2HM00V4P7G | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 9 | [] | A Red Camellia with a Hot Needle Ch. 9 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGBC0171RPWMDSP3WGAY42HK | 9.0 | 2024-08-02T07:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 9 | (C) Akira Sasayama/KOOI. | 2024-08-02T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2YRSTN8VR0BG | CNT_0DQVQXBBYM1G | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 7 | [] | A Red Camellia with a Hot Needle Ch. 7 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGBBZY2CAWMNBW498NZ4DJ68 | 7.0 | 2024-08-02T07:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 7 | (C) Akira Sasayama/KOOI. | 2024-08-02T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2YT70ZSG58B0 | CNT_0DXCDSBNNNR0 | A Red Camellia with a Hot Needle CNT_0HEV3RSF60W0 | 3 | 1 | 1 | Chapter 2 | [] | A Red Camellia with a Hot Needle Ch. 2 | Very, very hot fingertips are carving my back. Ikkoku, a deputy leader of the Yajima syndicate, has vowed to devote his life to Genran, the leader of the syndicate. One day, Ikkoku makes a mistake, and in order to protect Genran's reputation, he has to get a tattoo from a tattoo artist, Zhu Chunyan. Chunyan greets Ikkoku with a warm welcome, but a suspicious desire is wavering in the depths of his eyes... | 01KGAVWF4MBJG9W9MRBAY1N26V | 2.0 | 2023-12-21T08:00:00.000Z | KOOI. LAB_1ZDF52AZYZTG | GEO_1PQM5BDYSMG0 | A Red Camellia with a Hot Needle Ch. 2 | (C) Akira Sasayama/KOOI. | 2023-12-21T08: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);