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

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0CD5VJ4A1ACG	CNT_2AH3CAGMXWF0	Tales of Berseria CNT_34HRMNXC46CG	CNT_34HRMNXC46CG	2	1	1	Volume 1	[]	Tales of Berseria 1	""Got Tales of Berseria withdrawal? Return to Midgand with vengeful antihero Velvet in the manga adaptation of the JRPG hit! THIRST FOR REVENGE In the Holy Midgand Empire, a disease known as daemonblight wreaks havoc on the population, turning its victims into dangerous monsters known as daemons. Velvet Crowe has spent her life under the threat of daemons... Until the day she becomes one herself. After spending three excruciating years in prison, Velvet escapes seeking vengeance. Her goal: To take the life of Artorius Collbrande– the man responsible for her demonic transformation and her brother's murder. The manga adaptation of the latest installment in the beloved Tales of JRPG franchise!""	01KG9BMJQEHKK9HZ9N01ETJ89Z	1.0	2019-10-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tales of Berseria 1	Nobu Aonagi/Kodansha Ltd.	2019-11-05T08:00:00.000Z
PRD_1C27AMDT4BM0	CNT_2EREK9RTNCGG	Tales of Berseria CNT_34HRMNXC46CG	CNT_34HRMNXC46CG	2	1	1	Volume 2	[]	Tales of Berseria 2	Velvet Crowe is out for revenge. Her brother was murdered. She was turned into a Daemon. Both in one night, and both at the hands of her brother-in-law, Artorius. And after spending three excruciating years in prison while he enjoyed a meteoric rise to fame as the Shepherd, hero of the people, she's prepared to do whatever it takes to stop him, dead. With gorgeous illustrations by Nobu Aonagi that are sure to please any Tales fan, this prequel to Tales of Zestiria is an epic adventure-fantasy where the good guys can be bad, and a bad girl can save the world.	01KGA8AB55AB70ET0SPHVA7J16	2.0	2019-12-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tales of Berseria 2	Nobu Aonagi/Kodansha Ltd.	2020-01-07T08:00:00.000Z
PRD_307TX6M9RDGG	CNT_0X8W2813PYB0	Tales of Berseria CNT_34HRMNXC46CG	CNT_34HRMNXC46CG	2	1	1	Volume 3	[]	Tales of Berseria 3	Overcome by his overwhelming strength, Velvet and crew set off in search for the secrets of Innominat, the source of Artorius's power. But when the truth behind the Abbey's plan is finally revealed, it unravels everything Velvet thought she knew–about the world, the Abbey, and Artorius. In order to defeat Artorius once and for all, Velvet accepts that some sacrifices will need to be made to protect the people she loves most. FINAL VOLUME!	01KGA914C5FTBZG90CB6JGJDAN	3.0	2020-04-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tales of Berseria 3	Nobu Aonagi/Kodansha Ltd.	2020-04-28T07: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);