database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_28ZMB211XMGG"

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_0V7G6HXW4E3G	CNT_0FEPXMYP32NG	Who Says Warriors Can't be Babes? CNT_28ZMB211XMGG	CNT_28ZMB211XMGG	2	1	1	Volume 3	[]	Who Says Warriors Can't be Babes? Vol. 3	All of Warrior Woman's (misguided) efforts to get Hero to recognize her feminine side end in disaster, so she decides to confess her love for him point-blank! How will he respond? Find out in the final volume of this over-the-top romcom starring everyone's favorite brawny babe!	Love Is A Boss Battle	01KG9DXMHEDCND407Y7E27WWSE	3.0	2021-01-08T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Who Says Warriors Can't be Babes? Vol. 3	2020 TAIJIROU	2021-03-02T08:00:00.000Z
PRD_22B38SY2KWDG	CNT_1CNR0XXA41P0	Who Says Warriors Can't be Babes? CNT_28ZMB211XMGG	CNT_28ZMB211XMGG	2	1	1	Volume 1	[]	Who Says Warriors Can't be Babes? Vol. 1	Warrior Woman doesn't want much out of life, other than to get Hero to fall in love with her. But no matter how hard she tries to show off her feminine side, he only sees her as a fellow adventurer. Maybe that's because she's the strongest fighter alive--strong enough to slay a dragon with a single blow! Does Warrior Woman have what it takes to win Hero's heart without accidentally killing him in the process?	Don't Crush Your Crush!	01KG9CAZNMT0N4W4KPVVT05XE6	1.0	2020-07-31T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Who Says Warriors Can't be Babes? Vol. 1	Taijiro 2019	2020-09-08T07:00:00.000Z
PRD_3C5A18E1G5W0	CNT_0D791J08JA0G	Who Says Warriors Can't be Babes? CNT_28ZMB211XMGG	CNT_28ZMB211XMGG	2	1	1	Volume 2	[]	Who Says Warriors Can't be Babes? Vol. 2	Warrior Woman's combat stats are skyrocketing...while her feminine charm keeps plummeting! She'd give anything for Hero to like her, but between contending with a revenge-seeking Demon Lord general and a fierce battle breaking out in the Elven Forest, she's got her hands full. Will the day ever come when Hero turns to Warrior Woman for more than just her muscles?!	STRONG AT HEART	01KG9D5NAJ4DDVYS7BS5MPMYHV	2.0	2020-09-09T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Who Says Warriors Can't be Babes? Vol. 2	Taijiro 2019 • pixiv	2020-11-03T08: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);