products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_00KY9H5528XG"
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_0K0ZFANA2G70 | CNT_20J1X9NNDG4G | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 1 | [] | Mellow Boy Friend (1) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3EFYQ3H3K6TB61S5SCA3VK | 1.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (1) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1KYSZNSHR98G | CNT_3AZ61BP5G920 | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 7 | [] | Mellow Boy Friend (7) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F66Y6FFX6FHEH3K74JHRA | 7.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (7) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2936VRDAYBT0 | CNT_0BZJHQ6RWTHG | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 8 | [] | Mellow Boy Friend (8) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F68XEWE1Y57CC77JBJ484 | 8.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (8) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2H2F9HD515E0 | CNT_3DNP4S9715DG | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 4 | [] | Mellow Boy Friend (4) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F7T4TFRDYQ5K35DXDPK6S | 4.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (4) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2JMTEZ2SY3J0 | CNT_3NCTN5RNM29G | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 3 | [] | Mellow Boy Friend (3) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F6J0G7MFFCQ58TT0RAFV6 | 3.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (3) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2JVMP0A54HQG | CNT_10XBD0TH70B0 | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 2 | [] | Mellow Boy Friend (2) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F5TQRFTP1YHXTNZ0NMQGY | 2.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (2) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3282AA0FPNW0 | CNT_0FY0K58BAMZG | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 6 | [] | Mellow Boy Friend (6) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F60ZBZ81X6THVGVHKM90H | 6.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (6) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3CB1DN89DNX0 | CNT_166KD1VNWMYG | Mellow Boy Friend CNT_00KY9H5528XG | 3 | 1 | 1 | Chapter 5 | [] | Mellow Boy Friend (5) | Ruika is a comic artist who's not exactly satisfied with her job at the moment. She's concerned she's not following her dreams. One night, she runs into Hina, a friend she hasn't seen since high school. Hina's become a hunky heartthrob of an actor, but on the inside, he's still the same aloof guy he was when they were younger. Ruika can't help being a little stirred in his presence and ends up getting drunk and passing out. When she comes to, she finds herself on a bed in a hotel room?and Hina on top of her!! She's shocked to realize it isn't a dream...! A hot actor makes a comic artist's heart race in this romance between two old friends! | 01KH3F76RT6MPMFZMNCWPMD7BW | 5.0 | 2023-06-30T07:00:00.000Z | Taiseisha LAB_0XTACQT6E8EG | GEO_1PQM5BDYSMG0 | Mellow Boy Friend (5) | ©Bebe Yonaka/Taiseisha | 2023-06-30T07: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);