database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_3QJ7V80KPMA0"

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_07BKM36Y4JS0	CNT_168HF929SMT0	Battle Angel Alita: Last Order Omnibus CNT_3QJ7V80KPMA0	CNT_3QJ7V80KPMA0	2	1	1	Volume 4	[]	Battle Angel Alita: Last Order Omnibus 4	MADNESS IN MULTIPLES In the depths of Melchizedek, Alita inches closer to recovering her dear friend’s brain but not before she is greeted by Mbadi and a rather duplicitous Desty Nova doppleganger. Meanwhile, Sechs and the other members of the Space Angels make their way through ZOTT, where Sechs comes to face a universally renowned Space Karate master in a show of technique, toughness and…thumbs?	01KG993W517NAD0M39SJKCPW56	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Battle Angel Alita: Last Order Omnibus 4	(C) Yukito Kishiro / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0BR27P000HR0	CNT_3SKEEMRJ4KV0	Battle Angel Alita: Last Order Omnibus CNT_3QJ7V80KPMA0	CNT_3QJ7V80KPMA0	2	1	1	Volume 2	[]	Battle Angel Alita: Last Order Omnibus 2	A FIREFIGHT ACROSS THE GENERATION GAP! Nanotechnology made humanity immortal, and the resulting population explosion pushed the Solar System’s resources to the breaking point. As a result, new births are banned and even the planets’ disparate governments cooperate to annihilate any children already born. With the tournament looming, Alita and her comrades find themselves caught between a spacefaring refuge for young innocents and a bloodthirsty mob intent on killing the children for sport!	01KG993V5ES8VMZ6R3S2H0QFG8	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Battle Angel Alita: Last Order Omnibus 2	(C) Yukito Kishiro / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_212B3TQS6J9G	CNT_06KTZ075K5AG	Battle Angel Alita: Last Order Omnibus CNT_3QJ7V80KPMA0	CNT_3QJ7V80KPMA0	2	1	1	Volume 5	[]	Battle Angel Alita: Last Order Omnibus 5	THE SHOW MUST GO ON After nearly being canceled, the Z.O.T.T. resumes and now inches towards its conclusion with the Space Angels going head-to-head against new, formidable opponents that push their combative skills to the limit. With Alita jumping back into the fray, the independence of Tiphares and the scrapyard are depending on her victory, and with her new, seemingly unstoppable abilities, triumph seems to be nearly at hand for the Space Angels. However, behind the scenes, Mbadi and other nefarious entities are plotting to turn things around on Alita and her friends as the Z.O.T.T. continues into its final round.	01KG993WP9ZS4XS33X30R4JQ81	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Battle Angel Alita: Last Order Omnibus 5	(C) Yukito Kishiro / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_25GTDDH32H8G	CNT_2SXQYKXDY4BG	Battle Angel Alita: Last Order Omnibus CNT_3QJ7V80KPMA0	CNT_3QJ7V80KPMA0	2	1	1	Volume 3	[]	Battle Angel Alita: Last Order Omnibus 3	MEMORIES OF MASS MURDER On her way to retrieve Lou’s brain, Alita encounters a ghost from her past?an old mentor whose revelations shake Alita’s very identity. Meanwhile Elf, Zwolf, and Sechs fight their deadly ? and creepiest?enemies yet as the ZOTT rages on! But will the ARs have the mental fortitude to resist the psychically altered leader of the fearsome Starship Cult?	01KG993VPWZE1JFW06J5NZAS3R	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Battle Angel Alita: Last Order Omnibus 3	(C) Yukito Kishiro / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_281AR0K5EGFG	CNT_0S84YXKPD3MG	Battle Angel Alita: Last Order Omnibus CNT_3QJ7V80KPMA0	CNT_3QJ7V80KPMA0	2	1	1	Volume 1	[]	Battle Angel Alita: Last Order Omnibus 1	WHAT DOES IT MEAN TO BE HUMAN? The lovely, deadly cyborg Alita returns in 664 pages of cyberpunk action! Alita wakes up alone in the sky city of Tiphares, her brain and body reconstructed by the mad scientist Desty Nova. There’s no time to wonder why Alita’s greatest enemy would resurrect her, though ? the royal city has been thrown into chaos by Nova’s revelation that the Tiphareans have had their brains replaced by bio-chips! Everyone needs answers ? and Alita will fight to get them! INCLUDES TWO ORIGINAL STORIES BY YUKITO KISHIRO NEVER BEFORE PUBLISHED IN ENGLISH!	01KG936MDHVM14CDSM6T8BJCWF	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Battle Angel Alita: Last Order Omnibus 1	(C) Yukito Kishiro / Kodansha Ltd.	2016-10-25T07: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);