products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_0Q5DYE524SF0"
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_0VB04AQKYEH0 | CNT_3F2NZYF9ZXAG | Heaven and Demon CNT_0Q5DYE524SF0 | CNT_0Q5DYE524SF0 | 2 | 1 | 1 | Volume 2 | [] | Heaven and Demon vol. 2 | The wildness of love affairs with Tengoku is escalating. Finding the pleasure in being handcuffed or forced to say something, Aoki indulges in this ambiguous relationship. For him, Tengoku is still neither a close friend nor a lover. What should he do with this unclear relationship? One day, Tengoku invites him to dinner, saying it’s a date. Aoki hears the story of Tengoku’s childhood and his feeling begins to change slowly. But then, a handsome young teacher, Hatano, newly arrives at the school. And he makes advances towards Aoki. He also seems to know something of Tengoku... Hatano is able to stir up the turbulent. The second of a total of 2 volumes, this great BL manga is brilliant at describing the psychology of the characters! | 01KH3EJXX6F8752ERM4RX3QFZN | 2.0 | 2023-07-03T07:00:00.000Z | TAKESHOBO LAB_2YE29WN5APKG | GEO_1PQM5BDYSMG0 | Heaven and Demon vol. 2 | (C) Kyoko Oyoshikawa, Naomi Aga / TAKESHOBO | 2023-07-07T07:00:00.000Z | 0 | 0 | |||||
| PRD_1RP0A2R9JKS0 | CNT_199ZX4MEBNK0 | Heaven and Demon CNT_0Q5DYE524SF0 | CNT_0Q5DYE524SF0 | 2 | 1 | 1 | Volume 1 | [] | Heaven and Demon vol. 1 | High school teacher, Aoki is reluctant to go to the infirmary. Because he does not like the doctor there, Mr. Tengoku for no reason. But one day, he is forced to pay a visit to talk about a student who often skips class there. At the first contact, Tengoku easily sees through Aoki's nature of disguising an exemplary teacher, and smiles mysteriously. Tengoku tells him that he has been watching Aoki ever since he is assigned to this school. While discussing about the student, Tengoku points out the naivety of Aoki, and then gives him a kiss all of sudden. In his embarrassment, Aoki is unable to refuse at that moment. Later on, he remembers his childhood memories and starts to see his true self. What awaits for the timid teacher, Aoki? In the end, is he in heaven or hell? | 01KGB6QXHAM0549B9N5JEJS9FH | 1.0 | 2023-05-01T07:00:00.000Z | TAKESHOBO LAB_2YE29WN5APKG | GEO_1PQM5BDYSMG0 | Heaven and Demon vol. 1 | (C) Kyoko Oyoshikawa, Naomi Aga / TAKESHOBO | 2023-05-05T07:00:00.000Z | 0 | 0 | |||||
| PRD_3R8EDHQQHYJG | CNT_0XZP0JA9S0P0 | Heaven and Demon CNT_0Q5DYE524SF0 | CNT_0Q5DYE524SF0 | 2 | 1 | 1 | -sai- | [] | Heaven and Demon -sai- | SAI means “again” in Japanese, like the prefix "re-". In this 3rd volume of Heaven and Demon, Aoki and Tengoku starts dating and slowly deepens their relationship. But one day, when Aoki is talking with his friend on speakerphone while cooking, he brings up what Aoki said some time ago that he had no plans to marry his current partner. Tengoku hears but says nothing about it. When Tengoku leaves after the dinner, Aoki walks together to the station with a slight feeling of uneasiness. They kiss on the way, on the dark, lonely street at night. When Aoki notices someone passing by see them kissing, he almost unintentionally says “...This sucks”. Now Tengoku suddenly changes his tune and walks away, leaving Aoki alone and perplexed. Why does Tengoku leave like that? Their good relationship now seems to be in crisis... | 01KGC2807163MCX4QN0V6818PX | 3.0 | 2024-06-03T07:00:00.000Z | TAKESHOBO LAB_2YE29WN5APKG | GEO_1PQM5BDYSMG0 | Heaven and Demon -sai- | (C) Kyoko Oyoshikawa, Naomi Aga / TAKESHOBO | 2024-06-06T07: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);