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

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_1N3VHBJ7EA20	CNT_12EZCHF3KC80	Aliens Area CNT_1CJ6XXW7JDR0	CNT_1CJ6XXW7JDR0	2	1	1	Volume 3	[]	Aliens Area, Vol. 3	Sharaku organizes a meeting with the team leaders of Foreign Affairs 5 in order to take down the criminal organization A3. The meeting is fraught with red tape, but Tatsumi's memories may just hold the key they need to move forward. With an all-out war between Foreign Affairs 5 and A3 now looming, Foreign Affairs 5 will find themselves facing their most dangerous extraterrestrial threat yet in this epic conclusion!	01KGBDJ689SVH6FD8817SRT713	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Aliens Area, Vol. 3	ALIENS AREA © 2022 by Fusai Naba/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2RBTB895XM50	CNT_2GNZR240K6N0	Aliens Area CNT_1CJ6XXW7JDR0	CNT_1CJ6XXW7JDR0	2	1	1	Volume 2	[]	Aliens Area, Vol. 2	Now that Tatsumi and Sharaku have defeated the assassin Maumoki, Tatsumi is finally ready to start training as a Foreign Affairs 5 recruit! His first mission? To brave a sweltering day in the sun while hunting for an extraterrestrial nest in a rice paddy. But when the mission takes an unexpected turn, Tatsumi might just learn that things aren't always what they seem...	01KGBDKF7WT9YCEHMZ01PH2EPS	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Aliens Area, Vol. 2	ALIENS AREA © 2022 by Fusai Naba/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3ZN0D7Q35VK0	CNT_39XJ4AYMNWZ0	Aliens Area CNT_1CJ6XXW7JDR0	CNT_1CJ6XXW7JDR0	2	1	1	Volume 1	[]	Aliens Area, Vol. 1	After losing his parents in a freak accident, high schooler Tatsumi Tatsunami is doing his best just to get by and provide for his younger siblings. But his life gets a whole lot more complicated when he's attacked by aliens! Saved by a mysterious man named Sharaku who belongs to the even more mysterious organization called Foreign Affairs 5, Tatsumi will have an important decision to make if he wants to figure out why these aliens are after his life!	01KGBD3AY9JSF0ZPHW4ZPB2C8X	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Aliens Area, Vol. 1	ALIENS AREA © 2022 by Fusai Naba/SHUEISHA Inc.	2024-11-26T08: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);