products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
13 rows where series_id = "CNT_1PH62AF689KG"
This data as json, CSV (advanced)
Suggested facets: description, image_id, 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_00AA11VXB210 | CNT_147NABHXMWT0 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 6 (2) | [] | Pittosporum Ch.6 (2) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 6.2 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.6 (2) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0B9NY7Q9K070 | CNT_16WZN0WEEV40 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 3 (2) | [] | Pittosporum Ch.3 (2) | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 3.2 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.3 (2) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0BC668YMSY4G | CNT_2JD0D3YA1S7G | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 7 (2) | [] | Pittosporum Ch.7 (2) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 7.2 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.7 (2) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1371RC7GQ980 | CNT_3T5TP0M9BM30 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 6 (1) | [] | Pittosporum Ch.6 (1) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 6.1 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.6 (1) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1ERK06X6VPD0 | CNT_1W4HHFN2GHE0 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 2 | [] | Pittosporum Ch. 2 | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 2.0 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch. 2 | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1NP0SMPD9T8G | CNT_2QPMFMNBNN3G | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 8 (2) | [] | Pittosporum Ch.8 (2) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 8.2 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.8 (2) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1R063684FBA0 | CNT_3VGGQB9RHP10 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 8 (1) | [] | Pittosporum Ch.8 (1) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 8.1 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.8 (1) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_250D5X44N1QG | CNT_077S5Y1A8BMG | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 4 | [] | Pittosporum Ch. 4 | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 4.0 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch. 4 | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_29NERH9T7YM0 | CNT_3J26X4SE68Q0 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 8 (3) | [] | Pittosporum Ch.8 (3) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 8.3 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.8 (3) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2MCD8ZTNFMJ0 | CNT_3Y48KPQVRE90 | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 5 | [] | Pittosporum Ch. 5 | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 5.0 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch. 5 | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_32ZS73MK9ARG | CNT_2TG46ZS554KG | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 7 (1) | [] | Pittosporum Ch.7 (1) | As his feelings for Hisaya grow, Sono feels crushed under the stress of his past trauma and his family conflict. He proposes to move to different dorm rooms, but his expression makes him seem like he's on the verge of breakdown. His actions and the sad but precious expressions he makes it hard to guess his true intentions, causing the two to grow apart. Painful yet gentle love story of the crossing between the overwhelming feelings of love that hides inside his heart, and the desire to know more about his feelings. | 01KH3EPQHKYZEJ7C61JW0R32E1 | 7.1 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.7 (1) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_38KBFWJ1XQXG | CNT_0WFV16VYA1YG | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 3 (1) | [] | Pittosporum Ch.3 (1) | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 3.1 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch.3 (1) | (C)Shino Mikami/GOT | 2023-07-26T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3F1VSFCBSPWG | CNT_2ZT80GG6S0ZG | Pittosporum CNT_1PH62AF689KG | 3 | 1 | 1 | Chapter 1 | [] | Pittosporum Ch. 1 | Hisaya Yano has trouble with his roommate, Sono Odajima, at the boarding school. He breaks curfew and brings female students into the boy's dormitories. Sono is having intimate relations when Hisaya walks in and is left confused and aroused. Sono forcefully helps him deal with his erection. Made fun of for being "a serious model student", but in fact he finds himself in a jumble of romantic feelings that he can't tell anyone about, combined with his emotional trauma. | 01KH3FXPMH7DX1AGJSZAN5EJ4X | 1.0 | 2023-07-26T07:00:00.000Z | GOT LAB_1K6TP4MYWTF0 | GEO_1PQM5BDYSMG0 | Pittosporum Ch. 1 | (C)Shino Mikami/GOT | 2023-07-26T07: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);