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_3TCTDEJF4E90"

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_0QXMZERR6B90	CNT_2V4M8SN5BG90	Beasts of Abigaile CNT_3TCTDEJF4E90	CNT_3TCTDEJF4E90	2	1	1	Volume 4	[]	Beasts of Abigaile Vol. 4	Nina has been drugged and is being held captive! Roy is hot on her trail, but Angelica and the student council will do everything they can to interfere. With luga fighting luga and Nina's secret on the line, the fall of Abigaile has begun in this final volume of Beasts of Abigaile!	The Beginning of the End	01KGA3KAK05ESYDFX0FJ2AF5B3	4.0	2018-10-29T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Beasts of Abigaile Vol. 4	Spica Aoki 2018	2018-11-20T08:00:00.000Z
PRD_2TFH5HW71HR0	CNT_0N5QABF08TN0	Beasts of Abigaile CNT_3TCTDEJF4E90	CNT_3TCTDEJF4E90	2	1	1	Volume 2	[]	Beasts of Abigaile Vol. 2	As punishment for disrupting class, Nina and Roy find themselves working at the secret parties held by the school's human instructors. But Nina's duties quickly become far less more sinister than just waiting tables. The highlight of every party is a fight - wolf vs. luga - and it's not long before she finds herself thrust into the ring. But that's not the only trouble Nina's sticking her nose into. Between picking forbidden roses and standing up for Poe the omega, she's getting into dangerous territory - and sniffing out terrible truths.	Thrown to the Wolves	01KG9ZBMYX6ASP1KQ6M9RB866S	2.0	2017-08-24T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Beasts of Abigaile Vol. 2	(C) Spica Aoki 2016	2017-10-17T04:00:00.000Z
PRD_2WR45HBDA4PG	CNT_3YQPAN5T3FHG	Beasts of Abigaile CNT_3TCTDEJF4E90	CNT_3TCTDEJF4E90	2	1	1	Volume 3	[]	Beasts of Abigaile Vol. 3	Nina's perfume has been stolen! Without it, she doesn't have a way to disguise her true human nature, and there's nothing lugas hate more than humans. If she can prove she is not like the other humans, Roy promises to give her perfume back--but if she fails, he'll kill her!	A Girl in Wolf's Clothes	01KGA1EB8VTQS1P2Z5WQ86CMD5	3.0	2018-02-28T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Beasts of Abigaile Vol. 3	(C) Spica Aoki 2017	2018-03-09T08:00:00.000Z
PRD_3D3FP1HNVKAG	CNT_3JVPV59B8CVG	Beasts of Abigaile CNT_3TCTDEJF4E90	CNT_3TCTDEJF4E90	2	1	1	Volume 1	[]	Beasts of Abigaile Vol. 1	Tsukishiro Nina has just arrived in the beautiful country of Ruberia, and its charming denizens and lush scenery are like a fairy tale come true. That is until she's beset by a mysterious young man with a steely gaze and furry wolf ears - who promptly bites her! Nina finds herself turning into one of these beasts of legend, and whisked away to the prison of Abigaile where all their kind are sent. Nina must keep her wits about her if she's to learn the secrets of this magical world where everyone either makes her blood boil or her young heart race!	A Wolf By Any Other Name	01KG98QRK64CSA9BTDDYN0QR1K	1.0	2017-08-24T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Beasts of Abigaile Vol. 1	(C) Spica Aoki 2016	2017-08-31T04: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);