database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_1PPF22TENWYG"

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_01K20DC91M7G	CNT_12792EKB500G	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 7	[]	Kuma Miko Volume 7	Machi starts a new life in a town by the sea. But what happened to her dreams of moving to the big city? She hasn't made it through those big city trials yet and the first semester of school is already over. Now summer break is already here! Summer is the most important time for a student to prepare for entrance exams, but how will Machi spend her time?	01KGA37H6ETWM4X7GC7G95CNHR	7.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 7	(c)Masume Yoshimoto 2016	2018-03-08T08:00:00.000Z
PRD_041JK09KDK6G	CNT_35H6DR9KGZ1G	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 4	[]	Kuma Miko Volume 4	On a day just like any other, a corpse washes up in the river that separates Kumade from Tamura Village. The victim was a resident of Tamura, so the detectives, considering the long history of antagonism between the villages, suspect someone from Kumade. The detectives look around the village for suspicious characters, and soon their hunt leads them straight to Kumade Shrine!	01KGA37FKK0HRMRQQA8JX22X1B	4.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 4	(c)Masume Yoshimoto 2015	2018-03-08T08:00:00.000Z
PRD_0X2KPTJ75N0G	CNT_32WW2WX2P17G	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 5	[]	Kuma Miko Volume 5	When a detective from outside the village sees Natsu talking. Yoshio quickly explains that the bear is the village mascot. To cover his tracks. Natsu-chan has to come up with a marketing plan for himself. What will happen when he makes his debut on the national stage?	01KGA37HV9ZH3PW0Y06ST0222B	5.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 5	(c)Masume Yoshimoto 2015	2018-03-08T08:00:00.000Z
PRD_0YC3B7GWSP1G	CNT_13JF2H8TB26G	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 2	[]	Kuma Miko Volume 2	Machi is 14 years old and has spent her whole life in the Touhoku Mountains as a miko. Raised alongside a talking bear, Natsu, she knows nothing of modern life. But, she's enthralled with its mysteries and determined to figure them out. Natsu attempts to prepare her for the trials and tribulations she will face entering the fast-paced city in this comical coming of age story of a backwoods girl in Japan.	01KGA37JRDHZ9AT8RHQ0ENHBMY	2.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 2	(c)Masume Yoshimoto 2014	2018-03-08T08:00:00.000Z
PRD_27RATQZEFMQ0	CNT_25WFXQEFAFG0	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 1	[]	Kuma Miko Volume 1	Machi is 14 years old and has spent her whole life in the Touhoku Mountains as a miko. Raised alongside a talking bear, Natsu, she knows nothing of modern life. But, she's enthralled with its mysteries and determined to figure them out. Natsu attempts to prepare her for the trials and tribulations she will face entering the fast-paced city in this comical coming of age story of a backwoods girl in Japan.	01KGA1JXJKDBE50Y7G1Y1VMKDX	1.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 1	(c)Masume Yoshimoto 2013	2018-03-08T08:00:00.000Z
PRD_2R4RJX1ZVQJ0	CNT_03X8K8DP2JN0	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 6	[]	Kuma Miko Volume 6	Natsu's childhood friend makes an appearance-and it's another wild bear! Natsu plays the role of a spirit to bless Yoshio and Hibiki's relationship! And, Machi faces new trials on her path to the city! The calm of the village is shattered in Volume 6, a time of upheaval!	01KGA37M9V136GGMHER2H9F69Y	6.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 6	(c)Masume Yoshimoto 2016	2018-03-08T08:00:00.000Z
PRD_2WNBXG327PH0	CNT_2375JT3YHHP0	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 3	[]	Kuma Miko Volume 3	While he works at the village hall, Yoshi has a premonition of his fate: To promote tourism to Kumade village! But Kumade only produces bland vegetables, so what is he to do? Machi, and even Hibiki, get drawn into his big project in Kuma Miko: Girl Meets Bear Volume 3!	01KGA37JAGM3V8VBSVVB9YN8TS	3.0	2018-02-28T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 3	(c)Masume Yoshimoto 2014	2018-03-08T08:00:00.000Z
PRD_3VC7P0QRDQJG	CNT_3RW0AWZ01VGG	Kuma Miko CNT_1PPF22TENWYG	CNT_1PPF22TENWYG	2	1	1	Volume 8	[]	Kuma Miko Volume 8	A boy Machi's age arrives from the city, and there's trouble brewing! Meanwhile, a guest from outside the village takes up residence in Kumade for the summer. Right from the start he sees Natsu talking, and Machi is too shy to even talk to him. How will Machi survive her last summer vacation of middle school?	01KGA3G14QGWBSYANCQXWX69BS	8.0	2018-05-20T15:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	Kuma Miko Volume 8	(c)Masume Yoshimoto 2017	2018-05-29T07: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);