database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_2ZMD183YAPW0"

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_0JDXYBWJ98XG	CNT_345ZAR9QGM00	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 1	[]	Somari and the Guardian of the Forest, Volume 1	In a world populated by diverse range of tribes, humans have been persecuted nearly to extinction. One day, a forest guardian known as a Golem crosses paths with an abandoned little human girl. This is the story of the bond between a member of the disappearing human species and a guardian of the forest.An anime adaptation was released in 2020.This series has been published in Japan since 2015 which Japanese title name is "Somali to Mori no Kamisama"	01KGA61XKXM3Z666XS2EKWSNDY	1.0	2019-02-22T08:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 1	(C)2015 by YAKO GUREISHI/COAMIX	2019-07-23T07:00:00.000Z
PRD_11QM24K3K7H0	CNT_0JZ0HXGBRRBG	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 4	[]	Somari and the Guardian of the Forest, Volume 4	Father and daughter continue their journey to the Edgelands in search of humans. A chance encounter with another mixed-species family, an evening of baking in a Woodpeckers' cabin, a reunion in Chompers' Row, the village of tooth and fang specialists... each step of their adventure brings Somari and Golem closer to their goal.	01KG9BGFM9YZ03AJ98K2Y2MFK3	4.0	2019-11-05T08:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 4	(C)2015 by YAKO GUREISHI/COAMIX	2019-11-26T08:00:00.000Z
PRD_1HS6DXJ7HFQ0	CNT_0K686MEECGNG	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 5	[]	Somari and the Guardian of the Forest, Volume 5	The company make their way to the lawless town of Arishikka, where Shizuku confirms Somari's true identity and questions why a Golem would be traveling with a human in tow. What came next was the story of father and daughter's first encounter...	01KGA89E8YTXP6NNS2JWYG4GV9	5.0	2019-12-10T08:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 5	(C)2015 by YAKO GUREISHI/COAMIX	2019-12-17T08:00:00.000Z
PRD_1KGAD98D60Z0	CNT_1PA7SB8F4C7G	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 3	[]	Somari and the Guardian of the Forest, Volume 3	Human daughter and "other" father continue their journey to find clues about human beings, who have been persecuted to near-extinction. On their way to the Edgelands, the world beyond the maps, daughter takes a secret adventure into the Below to make her dream of staying by father's side come true. What "others" will they encounter on their voyage across the desert?	01KGA7KMRJ72EAH6PYC691EAZD	3.0	2019-04-22T07:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 3	(C)2015 by YAKO GUREISHI/COAMIX	2019-09-26T07:00:00.000Z
PRD_3076WX2EJYM0	CNT_1QBTG4GTDSTG	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 2	[]	Somari and the Guardian of the Forest, Volume 2	Their search for humans leads father and daughter to the village of the witches. Here, they learn of Haraiso's Tale, a book that tells the history of the relationship between two groups: the humans and the others.	01KGA7CC1HSTN87QZGTMQ23V6K	2.0	2019-03-22T07:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 2	(C)2015 by YAKO GUREISHI/COAMIX	2019-08-20T07:00:00.000Z
PRD_3QJZP2KRZTNG	CNT_1SRA6CWDFBP0	Somari and the Guardian of the Forest CNT_2ZMD183YAPW0	CNT_2ZMD183YAPW0	2	1	1	Volume 6	[]	Somari and the Guardian of the Forest, Volume 6	In search of clues in the outer edges of the land, the four travel to the Cauldron, home of the famous black market auctions. Curios, trinkets, odds and ends — and a certain book lying among the riches and curiosities on display. Known as Haraiso's Account, the tome was stolen from the witches long ago...	01KGA8CTTNV0CT8V34QV5GQ8HR	6.0	2019-12-05T08:00:00.000Z	Coamix LAB_28S99QQ57PGG	GEO_1PKAG51AEAQG	Somari and the Guardian of the Forest, Volume 6	(C)2015 by YAKO GUREISHI/COAMIX	2020-01-21T08: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);