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

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_134B18DPFEJG	CNT_220T4FV6FZRG	Children of the Sea CNT_244S8AWGMHXG	CNT_244S8AWGMHXG	2	1	1	Volume 5	[]	Children of the Sea, Vol. 5	After following Umi deep into the ocean, Ruka finds herself in an undersea cave where she hears a voice calling to her. She soon realizes it is the meteorite in her stomach, telling her the next step in her journey. The FINAL VOLUME of this majestic tale.	01KGBDDFRW5GFFE87YZG03YSY2	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Children of the Sea, Vol. 5	KAIJU NO KODOMO © 2007 Daisuke IGARASHI/Shogakukan	2024-11-26T08:00:00.000Z
PRD_13B499N1NWG0	CNT_3HHAWAX1YXT0	Children of the Sea CNT_244S8AWGMHXG	CNT_244S8AWGMHXG	2	1	1	Volume 4	[]	Children of the Sea, Vol. 4	Jim, Dehdeh and Ruka's mom finally track down Anglade's yacht, but neither the rogue scientist nor Umi or Ruka are on board. All that remains is a cryptic invitation to Jim. While Jim tries to figure out the game his ex-colleague is playing and Kanako dives into memories of her daughter Ruka, the strange seachanges continue around the globe.	01KGBDCH2ETNNBC9BG7X05Y1ZB	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Children of the Sea, Vol. 4	KAIJU NO KODOMO © 2007 Daisuke IGARASHI/Shogakukan	2024-11-26T08:00:00.000Z
PRD_26T3K73YT2Y0	CNT_3PSCVHQP0MC0	Children of the Sea CNT_244S8AWGMHXG	CNT_244S8AWGMHXG	2	1	1	Volume 2	[]	Children of the Sea, Vol. 2	Umi and Sora are not alone in their strange connection to the sea. Forty years ago, Jim met another young boy with the same powers. As penance for letting the boy die, Jim has been searching the world for other children with those same ties to the ocean. Anglade, a wunderkind who was once Jim's research partner, lures Sora away with the promise of answers. This leaves Umi severely depressed, and it is up to Ruka to help her new friend find his brother. But time is quickly running out...	01KGBDC0F6FTYPQ3WZPJ7D5E6W	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Children of the Sea, Vol. 2	KAIJU NO KODOMO © 2007 Daisuke IGARASHI/Shogakukan	2024-11-26T08:00:00.000Z
PRD_31GC3J46KV7G	CNT_0H61FKR67DBG	Children of the Sea CNT_244S8AWGMHXG	CNT_244S8AWGMHXG	2	1	1	Volume 3	[]	Children of the Sea, Vol. 3	Ruka is traumatized when Sora disappears into the night sea right in front of her. But although she refuses to speak of the incident, the meteorite Sora made her swallow is not so silent. It whispers to her from inside her body, and with its guidance she leads Umi and Anglade into the open ocean in search of answers.Surrounded by the sea, Ruka starts to see glimpses of the past that help her understand how Umi, Sora, Jim and Anglade all came to be connected.	01KGBDCGCZMGTMWYZ8994A9Q8C	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Children of the Sea, Vol. 3	KAIJU NO KODOMO © 2007 Daisuke IGARASHI/Shogakukan	2024-11-26T08:00:00.000Z
PRD_346ZD568ZT6G	CNT_2GGYFXEEJCMG	Children of the Sea CNT_244S8AWGMHXG	CNT_244S8AWGMHXG	2	1	1	Volume 1	[]	Children of the Sea, Vol. 1	Ruka's dad and the other adults who work at the aquarium are only distantly aware of what the children are experiencing as they get caught up in the mystery of the worldwide disappearance of the oceans' fish.	01KGBD2RQFZHE0SVYKQ66KAAA3	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Children of the Sea, Vol. 1	KAIJU NO KODOMO © 2007 Daisuke IGARASHI/Shogakukan	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);