database: products: 8 rows where series_id = "CNT

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

8 rows where series_id = "CNT_12YJ2E58T9SG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_1ZRHP37TDPYG	CNT_2QF5QQEE5KFG	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 7	[]	Love, That's an Understatement 7	Risa is experiencing new things at every turn, like sharing a more steamy kiss with Zen and becoming close friends with Kuma-san. She might even be ready to take her relationship with Zen to the next level, even if she's not entirely sure what that means. At the same time, Zen's rival Fuumin joins Risa's cram school to prepare for his university entrance exams, and impresses her with his hard work and intelligence. But as the days go by, he starts finding it harder and harder to focus...because Risa's always on his mind?!	01KJQ6WD4E8KRZPSMZ3WAHK9WD	7.0	2026-02-10T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 7	Fujimomo/KODANSHA LTD.	2026-02-24T08:00:00.000Z
PRD_21P9YDA0FTVG	CNT_1NHFWCY2TSC0	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 8	[]	Love, That's an Understatement 8	After Fuumin breaks his arm saving Risa from a nasty fall-jeopardizing his chances of passing his university entrance exams-Risa can't help but feel responsible. Ever the good boyfriend, Zen takes it upon himself to help his nemesis out until the exams are over. But when Zen realizes Fuumin also has feelings for Risa, their rivalry intensifies more than ever! Meanwhile, Risa is trying to stay focused on her own studies, but she can't resist the urge to spend more intimate time with Zen…	01KT5KWA74JKNF4GFR9YEM5NBF	8.0	2026-06-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 8	Fujimomo/KODANSHA LTD.	2026-06-23T07:00:00.000Z
PRD_2RXJSWEV1VX0	CNT_1GN10S1MKE4G	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 4	[]	Love, That's an Understatement 4	Locked out of her house late at night after losing her keys, Risa finds herself staying over at Zen's. She isn't sure what to expect at first, but is immediately made to feel welcome by Zen's warm and lively family. His sister offers Risa a spot in her bed, so Zen can't sneak by for a nighttime rendezvous. But half asleep after she gets up to go to the bathroom in the middle of the night, Risa wanders back into the wrong bedroom...	01KH3PCKFJJ4PTZC8ZD1FJTCHV	4.0	2024-04-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 4	Fujimomo/Kodansha Ltd.	2024-05-21T07:00:00.000Z
PRD_36G6WKHCDBY0	CNT_2SRBNWSPXXY0	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 1	[]	Love, That's an Understatement 1	Spare eraser? Check. Extra folding umbrella? Check. First aid kit? Check. Cool and collected high school student Risa Amakawa has something in her heavy bag for every situation, and the last thing she needs-or knows how to ask for-is anyone's help. When she saves a beat-up delinquent in the park one rainy evening, she refuses any sort of repayment. But it turns out that saving the notorious Zen Ohira buys her the attention of some unsavory characters. As Zen keeps swooping in to help her out of one pickle after another, her feelings about relying on anyone but herself-and her feelings toward Zen-slowly begin to change... A new romcom from the author of Lovesick Ellie!	01KGB6N4744XXYGQM60B8CB5JT	1.0	2023-04-04T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 1	Fujimomo/Kodansha Ltd.	2023-04-25T07:00:00.000Z
PRD_38CY7VAPPSR0	CNT_30ZA9BR2V3K0	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 3	[]	Love, That's an Understatement 3	After Risa's fever foils their plans for a first date, a concerned Zen drops by for what turns out to be a steamy house call that ends in them confessing their feelings for each other. Now officially boyfriend and girlfriend, Zen and Risa decide to meet at the local festival for a second shake at their first official date. But with exam season and troublemaker Fumiya looming in the background, it might not be the smooth sailing they expect...	01KH3FY0PWN7V8JV4GXE2N4FKX	3.0	2023-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 3	Fujimomo/Kodansha Ltd.	2023-09-12T07:00:00.000Z
PRD_3C84BEVDH6D0	CNT_3K3YKE8RVTGG	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 5	[]	Love, That's an Understatement 5	After Zen lets himself get beaten up to save Risa from Fuumin's gang, Risa realizes that what she feels for him may be real. But while the two are closer than ever, Zen struggles-while he knows Risa cares about him, he's not sure if she sees him in a truly romantic way. After all, it's hard to tell if her heart races like his does when they're together when she's always falling asleep around him! Meanwhile, an old middle school friend of Zen's transfers into Risa's school...and she still has a big crush on him.	01KGBFGV50KWJE6V7TWHX7JPBM	5.0	2024-10-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 5	Fujimomo/Kodansha Ltd.	2024-11-05T08:00:00.000Z
PRD_3KVV449NX720	CNT_22FFXRN4Q6E0	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 6	[]	Love, That's an Understatement 6	Ever since they started dating, Risa finds herself falling harder and harder for Zen. Her desire to have him all to herself seems to balloon by the day, and she longs to know everything about him. So much so that, for the first time, she invites him on a date: a meticulously planned day of activities at the zoo, right down to where they'll watch the sunset together. But when they run into Kuma-who clearly has some kind of history with Zen-Risa struggles with fresh new feelings of unease.	01KGBQ4S180CGMBKHJGSJH25ZH	6.0	2025-05-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 6	Fujimomo/Kodansha Ltd.	2025-06-10T07:00:00.000Z
PRD_3MS6YYBC9PH0	CNT_16N5NEG9WRB0	Love, That's an Understatement CNT_12YJ2E58T9SG	CNT_12YJ2E58T9SG	2	1	1	Volume 2	[]	Love, That's an Understatement 2	Risa has gradually warmed up to Zen, as he'd shown up to lend a hand or a shoulder to cry on (or sleepily drool on) through one crisis after another. The more time she spends with him, the more a version of herself she doesn't recognize seems to be bubbling up to the surface... Her heart and mind aflutter, she even leaned in for a smooch! Now she has to make good on her promise to help Zen and his crew with a study session at his house. Hopefully things won't be too awkward...	01KGB7K9MBESA21CTG2XWCXR9X	2.0	2023-05-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love, That's an Understatement 2	Fujimomo/Kodansha Ltd.	2023-05-23T07:00:00.000Z

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);