database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_2CSKBEV48Z30"

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_0HQXV7D1FFS0	CNT_1JEWMN9E02K0	A White Rose in Bloom CNT_2CSKBEV48Z30	CNT_2CSKBEV48Z30	2	1	1	Volume 3	[]	A White Rose in Bloom Vol. 3	Liz thinks back on the day when Steph first showed up at her home. From that first moment, Liz was struck by the older girl's elegance and beauty. But who is Steph, and what is her connection to Liz and her mother? Are they related? And if so, what's Liz to do with these feelings growing in her heart?	SISTERLY LOVE?	01KGBBYJDZHGED98AHZJBZV7F2	3.0	2024-07-18T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	A White Rose in Bloom Vol. 3	© Asumiko Nakamura 2022	2024-08-20T07:00:00.000Z
PRD_0KDBMEJRCJG0	CNT_289S65QHM6K0	A White Rose in Bloom CNT_2CSKBEV48Z30	CNT_2CSKBEV48Z30	2	1	1	Volume 2	[]	A White Rose in Bloom Vol. 2	Just as Ruby and Steph are starting to become close, Ruby's dad shows up and pulls her out of school! Her father wants Ruby to come and live with him in Italy, but she isn't too keen on the idea. Steph doesn't want her to go either, so the two come up with a plan: if Ruby can pass the school's scholarship exam, then her father will have to let her stay. Ruby may not be the best student, but with Steph as her tutor, she's willing to try!	SCHOOL DAZE	01KGAERCDG5KXAVC27V1NB7YGT	2.0	2022-02-10T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	A White Rose in Bloom Vol. 2	Asumiko Nakamura 2021	2022-03-01T08:00:00.000Z
PRD_1RKY97GZT1A0	CNT_0GAM9GQ3Y5NG	A White Rose in Bloom CNT_2CSKBEV48Z30	CNT_2CSKBEV48Z30	2	1	1	Volume 4	[]	A White Rose in Bloom Vol. 4	Suspicions spread throughout the girls' school after several small items go missing. Even worse, some people suspect Ruby is the culprit! Just as things seem about to spiral out of control, the dashing detective Steph takes on the case! Can Steph solve the mystery and clear Ruby's name?	SCANDAL IN THE SCHOOLYARD	01KGBN432RSZH8AYB4R15V3GAE	4.0	2025-04-18T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	A White Rose in Bloom Vol. 4	© Asumiko Nakamura 2024	2025-06-03T07:00:00.000Z
PRD_30CPQG1F1PNG	CNT_17XAPWFRCT3G	A White Rose in Bloom CNT_2CSKBEV48Z30	CNT_2CSKBEV48Z30	2	1	1	Volume 1	[]	A White Rose in Bloom Vol. 1	Ruby is a student at an elite European boarding school. Things are going pretty well for her until she finds out that she won't be able to go home at Christmas. Instead, she'll be stuck at school with only one other student--the aloof and beautiful Steph--for company. As Ruby tries to understand Steph, she becomes more and more attracted to the other girl. But can she break through Steph's icy exterior?		01KG9CF9FGRGCDRZRH9ZNEQ554	1.0	2020-11-13T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	A White Rose in Bloom Vol. 1	Asumiko Nakamura 2019	2021-01-05T08: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);