database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_21JGC9C9KHV0"

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_1YRYVYHKSKMG	CNT_3TTRKH3JGB6G	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 6	[]	The Summer You Were There Vol. 6	Kaori's health continues to decline, but she does get permission from her doctors for a day out. Her request: a day at the beach with her friends. Shizuku is determined to make sure the day is perfect, but it's hard to keep up a cheerful face. Shizuku is also determined to finish the story that Kaori has asked her to write. But will Shizuku and Kaori's own story have a happy ending? Find out in the final volume of The Summer You Were There.	A SEASON COMES TO AN END	01KG9S5PTF0W8MBQX99PX7T7PQ	6.0	2024-12-12T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 6	© 2024 Yuama	2025-01-28T08:00:00.000Z
PRD_29S0BCZANPCG	CNT_07CWF2THD6TG	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 4	[]	The Summer You Were There Vol. 4	At the start of summer, Kaori suggested to her writer classmate Shizuku that they should pretend to date to give Shizuku material to write about. Together, they've not only gone on dates and grown closer, Kaori has also helped Shizuku face her past. But now, as Kaori sits in a hospital bed thanks to her chronic illness, she tells Shizuku that they should break-up. Shizuku is shocked. Can she show Kaori how much their relationship means to her?	NOT READY TO LET GO	01KG9PESD37PWVAGPJZD11NMR2	4.0	2023-12-19T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 4	2022 Yuama	2024-01-23T08:00:00.000Z
PRD_2MV17SV3SZY0	CNT_24VP9SYTHHY0	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 3	[]	The Summer You Were There Vol. 3	At Kaori's gentle urging, Shizuku reaches out to Ruri, the girl she bullied back in elementary school. All Shizuku wants is to apologize, but it soon becomes clear that even that won't be so easy. Things take a dramatic turn when Kaori faints, and Shizuku learns that Kaori's been keeping a big secret. Now, with everything out in the open, will things between the two girls ever be the same again?	CRUEL SUMMER	01KGB6AYSECQ3JSR9ZZFA0ZWBW	3.0	2023-04-20T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 3	2022 Yuama	2023-06-13T07:00:00.000Z
PRD_2XVX4B4KA8GG	CNT_3Z4BQ392GBMG	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 5	[]	The Summer You Were There Vol. 5	With Kaori stuck in the hospital, Shizuku is resolved to do whatever she can for her. Time is precious since they can only see each other during visitor hours, but Shizuku's writing helps keep Kaori in good spirits. As the two girls spend more time together, Kaori's young sister, Shiori, starts to resent how close they are. Accused by Shiori of stealing away her big sister, how will Shizuku handle Shiori's hurt and jealousy?	LOVESICK	01KGBBWYAMCT2CZ62Q1CT2GG55	5.0	2024-07-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 5	© 2023 Yuama	2024-07-30T07:00:00.000Z
PRD_2XX1WCKAAKF0	CNT_2G50RMY7CZD0	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 2	[]	The Summer You Were There Vol. 2	After Kaori read her classmate Shizuku's novel, Kaori suggested that the two of them date to give Shizuku inspiration for her next book. Shizuku decides to go along with it, but as they spend time together, she grows worried that she'll hurt Kaori. When Shizuku opens up about her past as a school bully, Kaori has a revelation of her own: she already knew. Will this bring the girls closer together, or will it end their summer romance?	A Twist in the Tale	01KGB2A5DVEH8XJD0VCMP8S5P4	2.0	2022-10-24T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 2	2021 Yuama	2022-12-13T08:00:00.000Z
PRD_3T9KDY37D9PG	CNT_0QM0VG62Y670	The Summer You Were There CNT_21JGC9C9KHV0	CNT_21JGC9C9KHV0	2	1	1	Volume 1	[]	The Summer You Were There Vol. 1	Shizuku is a shy high schooler who hardly talks to other people. Instead, she loses herself in writing, crafting a novel that she never intends to show anyone. But when her cute, popular classmate Kaori gets her hands on Shizuku's manuscript, everything changes. Kaori suggests that, in order to give Shizuku material for her next book, the two of them should start dating! Can this mismatched pair create their own happily ever after?	The Start of a Yuri Storybook Romance	01KGAJW7QVKZ5YFDXZWNJ393MK	1.0	2022-07-29T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	The Summer You Were There Vol. 1	2021 Yuama	2022-09-06T07: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);