products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_3YWRTWJMA240"
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_0EQVZVAA7ZNG | CNT_3FGFQA4FT980 | Boys Run the Riot CNT_3YWRTWJMA240 | CNT_3YWRTWJMA240 | 2 | 1 | 1 | Volume 1 | [] | Boys Run the Riot 1 | High schooler Ryo knows he's transgender, but he doesn't have anyone to confide in about the confusion he feels. He can't tell his best friend, who he's secretly got a crush on, and he can't tell his mom, who's constantly asking why Ryo "dresses like a boy." He certainly can't tell Jin, the new transfer student who looks like just another bully... The only time Ryo feels at ease is when he's wearing his favorite clothes. Then, and only then, the world melts away, and he can be his true self. One day, while out shopping, Ryo sees someone he didn't expect: Jin. The kid who looked so tough in class has the same taste in fashion as him! At last, Ryo has someone he can open up to—and the journey ahead might finally give him a way to express himself to the world. | 01KG9E6PGWXKRZKWMXQDXZR4KW | 1.0 | 2021-05-12T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Boys Run the Riot 1 | Boys Run the Riot Keito Gaku/Kodansha Ltd. | 2021-05-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_15D0RB1KGEMG | CNT_24A5XR07SR90 | Boys Run the Riot CNT_3YWRTWJMA240 | CNT_3YWRTWJMA240 | 2 | 1 | 1 | Volume 2 | [] | Boys Run the Riot 2 | Ryo and Jin have started their own fashion brand, Boys Run the Riot. Now they just have to get the word out there! But the world of fashion is a cutthroat business of patronizing adults, and the boys will have to get creative—and save some cash—if they want to get their brand off the ground and be taken seriously. Working part-time is hard enough, but for Ryo, being transgender makes it even harder. In work, friendship, and romance, he struggles to decide whether to come out as his true self. However, when he befriends his cool coworker Mizuki, the closet door begins to open... | 01KG9FQAEHHTFKC75FSXBNSFP6 | 2.0 | 2021-07-08T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Boys Run the Riot 2 | Boys Run the Riot Keito Gaku/Kodansha Ltd. | 2021-07-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_1VC83M19WY70 | CNT_2EG5HR3YD29G | Boys Run the Riot CNT_3YWRTWJMA240 | CNT_3YWRTWJMA240 | 2 | 1 | 1 | Volume 3 | [] | Boys Run the Riot 3 | Sales for Boys Run the Riot skyrocket when the famous LGBTQ YouTuber WING introduces the brand to their fans...but in the process, also outs Ryo as transgender to the whole world! With his secret now out in the open, Ryo is left to face the confusion of his classmates—most of all from his best friend and crush, Chika—and finds that the regret of staying silent is sometimes worse than the silence itself. Meanwhile, WING has a secret of their own that will soon come back to bite them and stir up an internet mob... | 01KG9GY6SG5ND4K3WKXHTK1TCV | 3.0 | 2021-09-13T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Boys Run the Riot 3 | Boys Run the Riot Keito Gaku/Kodansha Ltd. | 2021-10-05T07:00:00.000Z | 0 | 0 | |||||
| PRD_37WSRF211GG0 | CNT_1HW1TFFC13RG | Boys Run the Riot CNT_3YWRTWJMA240 | CNT_3YWRTWJMA240 | 2 | 1 | 1 | Volume 4 | [] | Boys Run the Riot 4 | RIOTS ARE ALL THE RAGE Now that the drama with Tsubasa has cooled down, Ryo is living out and proud at school, and he and his friends are back on track to create new designs for Boys Run the Riot. While doing so, Ryo bumps into a fan named Joe, who has been running his own fashion brand for 20 years. Under his tutelage, Boys Run the Riot gets put to the test to think up their brand message, motif, and concept...in order to prepare for their brand's debut at Joe's exhibition! Meanwhile, Ryo and Jin must decide whether to hide from their families, or invite them along to the exhibition and reveal their true selves... The boys who once dreamed of changing the world with their clothes are now ready to take the stage, and they're not exiting without causing a riot! FINAL VOLUME! | 01KG9HCR6YJM8VYGS6ND6KWKXM | 4.0 | 2021-11-09T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Boys Run the Riot 4 | Boys Run the Riot Keito Gaku/Kodansha Ltd. | 2021-11-30T08: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);