products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
6 rows where series_id = "CNT_0YFD0WNDM5NG"
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_07XM9Y9CG5C0 | CNT_079K1HSHYN8G | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 4 | [] | Amethyst in the Gloom Ch. 4 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 4.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 4 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_129GPQVXGEM0 | CNT_0XXB237N9DGG | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 3 | [] | Amethyst in the Gloom Ch. 3 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 3.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 3 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_15CKKXQ9RCT0 | CNT_0WHNDRJ63BJG | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 5 | [] | Amethyst in the Gloom Ch. 5 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 5.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 5 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_19X2YGHC4BS0 | CNT_2ZW2DA8EEAKG | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 1 | [] | Amethyst in the Gloom Ch. 1 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 1.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 1 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_1G7P3A0502G0 | CNT_0RK70AGKJHMG | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 6 | [] | Amethyst in the Gloom Ch. 6 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 6.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 6 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3BNT466F6B9G | CNT_1W7BX1DA9V20 | Amethyst in the Gloom CNT_0YFD0WNDM5NG | 3 | 1 | 1 | Chapter 2 | [] | Amethyst in the Gloom Ch. 2 | Aiji Ubukata is a highly qualified government ambassador who has almost no relationship experience. After finally being freed from the celibate lifestyle of an extended overseas position in Saudi Arabia, he realizes that even a glimpse of a woman's skin arouses him. Crammed into a crowded train on his return from the airport, he saves a beautiful man, Akira Shimizu, from a molester. As Akira turns to thank him, he spies Aiji's raging hard-on from their close contact...!! "I'm used to this kind of thing. Just leave everything to me..." When Akira brings Aiji to a hotel and makes him cum instantly with a blowjob, Aiji can't help but fall in love with him. However, Akira has lived his whole life pursuing purely casual relationships without opening himself up to anyone, so the idea of a relaxed date with Aiji doesn't exactly appeal to him. When Aiji asks Akira to think about a serious relationship, he dodges the subject and asks him to another hotel instead! | 01KGB012YM3AKQ9QET200V7TW4 | 2.0 | 2024-03-04T08:00:00.000Z | SHINKOSHA LAB_0CW5Q4P4Q090 | GEO_1PQM5BDYSMG0 | Amethyst in the Gloom Ch. 2 | (C) 2023/Kirche Kanno/SHINKOSHA | 2024-03-04T08: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);