database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_1KETDSNNCVG0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_04QQC17H4EDG	CNT_1B7JZGG1E14G	The Mimosa Confessions CNT_1KETDSNNCVG0	CNT_1KETDSNNCVG0	2	2	1	Volume 5	[]	The Mimosa Confessions Vol. 5	After a shocking proposal carries their relationship into uncharted territory, Sakuma and Ushio greet the new year with a fresh label and newfound resolve. Yet as winter wears on, and the class trip to Hokkaido draws ever closer, their bond will be tested--not only by the lingering question of its sustainability but also by the infamous Sera, sweet-talking trickster and sower of discord. Can their relationship survive the machinations of a man hell-bent on worming between them? Or will Sakuma falter in the face of the biggest moral conundrum he's ever had to confront? In this heartrending conclusion, deep-seated doubts emerge as unspoken lines are finally crossed. When Sakuma and Ushio at last close the book on the most challenging chapter of their youths, where will they find themselves--and each other--in the coming dawn?	THE END OF AN ERA	01KGBSCQV0FBY8G0TY4SSJYZ9Z	5.0	2025-07-23T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	The Mimosa Confessions Vol. 5	© 2024 Mei HACHIMOKU	2025-09-25T07:00:00.000Z
PRD_08R9E4P8KA00	CNT_3ETCYT5962A0	The Mimosa Confessions CNT_1KETDSNNCVG0	CNT_1KETDSNNCVG0	2	2	1	Volume 3	[]	The Mimosa Confessions Vol. 3	It's smooth sailing for Sakuma and friends after the autumn culture festival, and Ushio is fast reclaiming her popularity at school. Just when it seems like the worst is finally behind them, Ushio's old rival barges in with a challenge: defeat him in a race, or rejoin the boys' track-and-field team. It's an outlandish request, yet--despite being out of practice and at a severe disadvantage--Ushio accepts. Meanwhile, tension is brewing between two of the school's biggest troublemakers, with Arisa Nishizono on the brink of a violent blowup after repeated provocations from Itsuku Sera. Eventually, her fury boils over, and she takes matters into her own hands in a way no one saw coming. Sparks fly as the youths' resolve is put to the test... When the dust settles, who will be victorious?	A CLASH OF EGOS	01KG9R8J3QQBYSWQDWH36AN2C4	3.0	2024-12-05T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	The Mimosa Confessions Vol. 3	© 2021 Mei HACHIMOKU	2025-01-02T08:00:00.000Z
PRD_10FPME9VKDK0	CNT_1RA5DBNXJ090	The Mimosa Confessions CNT_1KETDSNNCVG0	CNT_1KETDSNNCVG0	2	2	1	Volume 2	[]	The Mimosa Confessions Vol. 2	After a dramatic first semester, Sakuma and Ushio dive headfirst into summer vacation. Despite their unspoken agreement to not mention the "incident" that occurred on the last day of school, things get real awkward real fast when they meet up with Natsuki on a trip to the aquarium. She asks them a pointed question: "You two are dating, aren't you?" The trio will be forced to set their unresolved feelings aside when fall semester arrives--and with it, the annual culture festival. Can Sakuma balance his feelings for both of them in addition to his work on the festival committee, not to mention a starring role in the class production of Romeo and Juliet?	TIME TO RAISE THE CURTAIN	01KGBBC92ZSZS85EKVZ4WKP9PD	2.0	2024-08-23T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	The Mimosa Confessions Vol. 2	© 2021 Mei HACHIMOKU	2024-09-12T07:00:00.000Z
PRD_1QFGMJ4WD8VG	CNT_22WC0K380BV0	The Mimosa Confessions CNT_1KETDSNNCVG0	CNT_1KETDSNNCVG0	2	2	1	Volume 4	[]	The Mimosa Confessions Vol. 4	"Promise me you'll always be a good older brother to her, okay?"Misao Tsukinoki clung to these words from her late mother, looking to her older sibling as a guiding light. But when she came home that fateful day to find Ushio wearing her school uniform, her respect and adoration instantly turned to scorn and disbelief. Why was Ushio suddenly dressing like this? When did the changes start? Or had the person she thought of as a brother been someone different all along? Desperate and in need of answers, Misao retraces their life together from the present to the distant past: their father's second marriage, their history with Sakuma Kamiki, their mother's death--and a promise they made to each other long, long ago. Old secrets and buried truths will finally come to light as Misao grows closer to understanding Ushio's struggles. And with them, a tragic tale of a fractured family unravels in reverse.	A PROMISE AND A CURSE	01KGBNEPJ7BJ080W8ZN7YG5SB2	4.0	2025-04-25T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	The Mimosa Confessions Vol. 4	© 2021 Mei HACHIMOKU	2025-05-29T07:00:00.000Z
PRD_3KKBK7GS87MG	CNT_2EYXTHPT32PG	The Mimosa Confessions CNT_1KETDSNNCVG0	CNT_1KETDSNNCVG0	2	2	1	Volume 1	[]	The Mimosa Confessions Vol. 1	Growing up in a dreary suburb, Sakuma has little to brighten his humdrum days aside from his best friend. The bright, talented, and attractive Ushio seems to have everything Sakuma lacks, and his good looks, academics, and athletic prowess make him popular with the girls at school. Past trauma--and an understandable inferiority complex--slowly drive the two apart, and by the time they enter high school, they hardly even speak anymore. Thus, Sakuma finds himself alone. Against all odds, he eventually gains a friend in Natsuki, the sweetest girl in class. The two hit it off gushing about their favorite novels, and he falls head over heels for her. But that very same night, he stumbles upon an unexpected sight while walking through a familiar park: his old friend Ushio, dressed in a full-blown schoolgirl's uniform and sobbing uncontrollably.	A World-Changing Revelation	01KH3P9SYZ4K81HHXKTF7DHV69	1.0	2024-04-03T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PZ1FZ4QK0N0	The Mimosa Confessions Vol. 1	© 2021 Mei HACHIMOKU	2024-04-25T07: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);