products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
6 rows where series_id = "CNT_056CE34HDA90"
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_1T0A15JGRCN0 | CNT_0ZYT5VJ9QMS0 | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 5 | [] | Candy Color Paradox, Vol. 5 | Both work and love are going well for Onoe and Kaburagi! But one day Kaburagi bumps into Sanjo, an old high school buddy who happens to be the heir to a hotel chain. While Sanjo looks ecstatic to see Kaburagi again, Kaburagi himself seems a little awkward about it. Noticing this, Onoe starts to wonder if maybe the two of them were more than just friends once upon a time... | 01KGC1FSMXXY1K54HX7KT2DJVY | 5.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 5 | © 2019 Isaku Natsume/Shinshokan | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_1X7NYBEX0AV0 | CNT_0YK44GYTHJV0 | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 1 | [] | Candy Color Paradox, Vol. 1 | Satoshi Onoe takes pride in the good writing and ethical reporting he does in his job at a weekly magazine. But when the stakeout teams are shuffled around, he ends up being paired up with Motoharu Kaburagi, an ill-mannered photographer who is nothing but trouble. Onoe despises Kaburagi's haphazard and unethical reporting methods, and the two bicker constantly. But Onoe's annoyance begins to shift as he spends more time with Kaburagi, and his feelings turn a bit sweeter... | 01KGC0QS360NV6J8ZC8C4CQ8TX | 1.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 1 | © 2011 Isaku Natsume/Shinshokan | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_1YH5CRCV4BM0 | CNT_2Z8Q558J2KT0 | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 3 | [] | Candy Color Paradox, Vol. 3 | It's been nearly a year since Onoe and Kaburagi began dating, and their office has just hired a new recruit—Kasai. Onoe is thrilled to have a junior to mentor, but Kasai seems to see Onoe only as a rival. And when Kasai discovers Onoe gets most of his scoops through Kaburagi, he throws down the gauntlet and declares that he will make Kaburagi his! | 01KGC1FRG6CH9XMPVYKZ1TWPFY | 3.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 3 | © 2015 Isaku Natsume/Shinshokan | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_3NV28V3KTC5G | CNT_3W93NJQ5H59G | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 6 | [] | Candy Color Paradox, Vol. 6 | Ready to take their relationship to a whole new level, Kaburagi and Onoe make the next big leap on their path to love—finding an apartment together. But end-of-the-year holiday cheer turns into holiday dread, with endless work keeping the two from having time to see each other! Onoe starts worrying that Kaburagi is overworking himself, but his concern comes off as criticism, sparking the couple's first big argument and driving Onoe to say that maybe they shouldn't live together after all. And even after they make up, Kaburagi starts getting cold feet about the big move... | 01KGC1FT6D2B0QET11N7K7FSS0 | 6.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 6 | © 2021 Isaku Natsume/Shinshokan | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_3R9JTFXP6B4G | CNT_1ZKGNWDDW4AG | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 4 | [] | Candy Color Paradox, Vol. 4 | Ever since the yakuza incident and Onoe's daring rescue, rookie reporter Kasai has gone from viewing Onoe as a rival to admiring him to a fault! And Kaburagi is not pleased—at all. While chasing a story about a famous actor having an affair, Onoe and Kaburagi run into Kasai. In a fit of jealousy, Kaburagi blurts out that he and Onoe are a couple. Overhearing this, the devious Inami decides to target Onoe. | 01KGC1FRZSBBTQET4Q7VTKR4VJ | 4.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 4 | © 2017 Isaku Natsume/Shinshokan | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_3WYD52ZR2ABG | CNT_3YYDNE3PB3BG | Candy Color Paradox CNT_056CE34HDA90 | CNT_056CE34HDA90 | 2 | 1 | 1 | Volume 2 | [] | Candy Color Paradox, Vol. 2 | Kaburagi and Onoe still bicker constantly, but at the end of the day they're firmly in love. But suddenly, Kaburagi's sister Noriko shows up! Apparently, the two of them don't get along very well...or at all, really. But Noriko does manage to hit it off with Onoe, and the two start hatching plots to knock Kaburagi's ego down a peg or three... | 01KGC1FQSNS6YTBYE0Q6BNHZXM | 2.0 | 2025-12-09T08:00:00.000Z | SuBLime LAB_128NRHG35NQG | GEO_1PQM5BDYSMG0 | Candy Color Paradox, Vol. 2 | © 2012 Isaku Natsume/Shinshokan | 2025-12-09T08: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);