products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
11 rows where series_id = "CNT_399QFQ9T4SP0"
This data as json, CSV (advanced)
Suggested facets: geoblock_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_058QVAKGMCFG | CNT_0ZV966W91MKG | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 9 | [] | Honey Lemon Soda, Vol. 9 | With newfound confidence, lots of friends, and the boyfriend of her dreams by her side, Uka is ready to tackle her second year of high school with a spring in her step! As if things couldn’t get any better, she makes the perfect pal in Nano Iwakawa, a clumsy and shy but sweet girl who idolizes Uka for how far she’s come. But as it turns out, Nano is in Kai’s class, and her similarities to Uka haven’t gone unnoticed by their peers—especially since Nano seems to be getting awfully close to him. Could there be more to Nano’s behavior than meets the eye? | 01KG9S78DZ4RVH1PQTPC8CEY9N | 9.0 | 2024-12-18T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Honey Lemon Soda, Vol. 9 | 2025-06-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0CD97T44C1JG | CNT_17QEDDA1BKP0 | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 7 | [] | Honey Lemon Soda, Vol. 7 | Nobody can seem to put a name to Uka and Kai’s relationship, not even themselves. But Uka knows deep down exactly who she wants to be to him—his girlfriend! After being in his shadow for so long, confessing to someone so far out of her league is going to take confidence she’s not sure she has. But when an opportunity rolls around during the sports festival, will Uka finally work up the courage to tell Kai how she really feels? | 01KH3R99NBZRXKKJN5SY9MCHHG | 7.0 | 2024-05-08T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Honey Lemon Soda, Vol. 7 | 2024-10-15T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0JRBD56RWMP0 | CNT_16QW3W37DZP0 | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 1 | [] | Honey Lemon Soda, Vol. 1 | Uka Ishimori has one dream in life: to have fun in high school! As a self-avowed dense, stone-faced introvert who spent all of middle school hardening her heart against a daily barrage of bullying, breaking out of her shell is easier said than done. Luckily, she’s not alone—Kai Miura, a classmate whose blond hair reminds her of the lemon soda he so enjoys, has her back. Step by step, she endeavors to cast off the shadows of her past and reinvigorate her life! | 01KGB2Z6AS19S3XP6JGA4WY2TQ | 1.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 1 | 2023-01-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0RMJN2N53YQ0 | CNT_0E29PQB7G640 | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 11 | [] | Honey Lemon Soda, Vol. 11 | It’s been one heart-pounding moment after another on Uka’s school camping trip, as it’s her first time getting to stay with Kai past sunset! When her attraction toward him grows in a way she’s never felt before, she decides to sneak into his room in the middle of the night—but now she’s terrified that she totally gave him the creeps! Is it wrong of her to yearn for her boyfriend’s touch? Plus, there are many things about Kai that Uka still doesn’t know, including a crucial part of his backstory… | 01KP0B21KQFVG1SBHB72Y4Y4Z8 | 11.0 | 2025-10-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 11 | 2026-04-28T00:00:00.000Z | 0 | 0 | ||||||
| PRD_11XDMBF6D450 | CNT_1V5PXZYH0PN0 | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 8 | [] | Honey Lemon Soda, Vol. 8 | Finally, Kai and Uka have both admitted their feelings for each other, and Uka’s heart bursts with satisfaction at this miraculous development. But does having feelings for each other mean dating?! What is dating, anyway? With a bit of worry and a lot of joy, Uka has become the girlfriend of the person she loves. | 01KGBCHWYDKJAAMCGEC0ZCPBA0 | 8.0 | 2024-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Honey Lemon Soda, Vol. 8 | 2025-02-18T08:00:00.000Z | 0 | 0 | ||||||
| PRD_18TY7GF9915G | CNT_39ESZYPMEBTG | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 5 | [] | Honey Lemon Soda, Vol. 5 | It’s summer vacation, and Uka and her friends came to the beach to have fun in the sun-or that was the plan, but a chance encounter with some past acquaintances dredges up painful memories for her. Meanwhile, Kai calls out his ex-girlfriend Serina for a private chat... Will the storm clouds on the horizon ruin Uka’s precious summer memories? | 01KGAT3C4P5NM4HCZNJCYCR4QT | 5.0 | 2023-10-30T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 5 | 2024-03-19T00:00:00.000Z | 0 | 0 | ||||||
| PRD_19PGCQF61SG0 | CNT_1397TK0EP8BG | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 4 | [] | Honey Lemon Soda, Vol. 4 | It’s the opening day of Hachimitsu High’s culture festival! With its cute decor, tasty food, charming maids, and potential glimpses of Kai, Class 1-B’s Café Avail is doing better than anyone could have expected—and it’s all thanks to the pillar of the class, Uka. But even the strongest pillars can come crumbling down, and Uka gets a sudden reality check when she’s swarmed by irate girls demanding to know what relationship she and Kai have. Emboldened by the festival, Uka may have forgotten just how far apart her and Kai’s worlds are—but everyone else certainly hasn’t! | 01KH3EXVVEARQ1PCWCH27C4DD9 | 4.0 | 2023-05-31T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 4 | 2023-11-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2KY116YZ22JG | CNT_0WMA383EDH80 | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 3 | [] | Honey Lemon Soda, Vol. 3 | When Uka meets Kai's ex-girlfriend Serina and sees how different they are, she completely loses confidence. But can a few words from Kai inspire her not to give up? | 01KGB6GF7CBY707WZYKPFDMAZM | 3.0 | 2023-05-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 3 | 2023-08-22T00:00:00.000Z | 0 | 0 | ||||||
| PRD_34XQJD2KS4A0 | CNT_2KHNGQYB38NG | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 10 | [] | Honey Lemon Soda, Vol. 10 | Uka is pleased as punch to have made friends with Nano Iwakawa, a transfer student who’s just like her—or so it seemed. When Uka learns that Nano might be putting on an act to get closer to Kai, everything she thought she knew comes crashing down! Faced with the fear of losing both of them, Uka resolves to talk to Nano and find out who she truly is. Can she salvage their friendship and keep her boyfriend to herself at the same time? | 01KGBN03SQFASPWCYB7H9H1H34 | 10.0 | 2025-04-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Honey Lemon Soda, Vol. 10 | 2025-09-23T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3EP628K32M5G | CNT_2JZJNMKPD4HG | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 6 | [] | Honey Lemon Soda, Vol. 6 | Uka’s father mistakenly believes she is being bullied and tells her to transfer schools. With her father and her friends being equally important to her, Uka is determined to not give up on either, but... | 01KGAY001YYEEK272QJ1M0MZCH | 6.0 | 2024-01-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 6 | 2024-07-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3JNFQ89BJCZG | CNT_0JY2B8YWF97G | Honey Lemon Soda CNT_399QFQ9T4SP0 | CNT_399QFQ9T4SP0 | 2 | 1 | 1 | Volume 2 | [] | Honey Lemon Soda, Vol. 2 | Making friends, laughing along with her classmates, and even falling in love…To Uka, her current high school life is a dream come true! Although self-doubt still looms over her like a mountain, she’s determined to keep climbing—and what better time to do so than at the school’s welcome hike? But when a strange fork in the road sends the entire class down a dangerous trail, can Uka step up and save the day? | 01KG9KT062TK3RXCSQ2TH23P1K | 2.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Honey Lemon Soda, Vol. 2 | 2023-05-23T00: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);