database: products: 13 rows where series_id = "CNT

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

13 rows where series_id = "CNT_29GVGR8Y6Y4G"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at	add_on
PRD_0C18F4MR11QG	CNT_28MB96DD82M0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Vol. 10 Short Story	[]	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 10 Short Story [Bonus Item]	Exclusive short story for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 10”.	Exclusive short story for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 10”.	01KJP38ZKA8SE40J43R0FS9YCC	10.5	2020-03-27T07:00:00.000Z	BookWalker LAB_0SZPX2Z9ZDAG	GEO_1PQM5BDYSMG0	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 10 Short Story [Bonus Item]	(C)SOW	2020-03-27T07:00:00.000Z	1
PRD_0F3YYMEADQ8G	CNT_3QYKM72A9H5G	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 1	[]	The Combat Baker and Automaton Waitress: Volume 1	The war hero known as Silver Wolf - Lud Langart - piloted a humanoid assault weapon while dreaming of life as a baker. After the war, Lud now peacefully runs a bakery, but, thanks to his frightening scowl, he can't sell a single loaf of bread. After posting an ad for a waitress in a last-ditch effort to save his business, who should reply but a beautiful, silver-haired, red-eyed young girl. What Lud doesn't know is that this new waitress was born from Avei, his AI partner installed in the weapon he piloted during the war.	After fighting in the war, Lud Langart now runs a bakery, but thanks to his scowl, he can't sell any bread. He hires a beautiful young girl as a waitress to help save his business, not knowing that she was the AI of his old weapon.	01KG98P6DZKS0BXCHDHF70V8MN	1.0	2017-06-29T15:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 1	Copyright (C) 2015 SOWIllustrations Copyright (C) 2015 Zaza	2017-06-29T15:00:00.000Z	0
PRD_0KQFWMQH1TGG	CNT_25QE0JRXANQG	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 3	[]	The Combat Baker and the Automaton Waitress: Volume 3	Sven and Jacob take a trip to a neighboring town to sell bread as part of a new sales strategy for the bakery. While there, Jacob has a surprising encounter, and soon after, major changes rock Tockerbrot. A rival bakery opens right next door, while the Schutzstaffel in Wiltia hatches a furtive plan... Get ready, Volume Three is bursting with excitement!	Sven and Jacob take a trip to a neighboring town to sell bread for the bakery. While there, Jacob has a surprising run-in, causing changes to Tockerbrot. A rival bakery opens next door, while the Schutzstaffel in Wiltia hatches a furtive plan.	01KGA30FHMKYHXRK2H43MVBDRD	3.0	2018-03-15T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and the Automaton Waitress: Volume 3	Copyright (C) 2015 SOW Illustrations Copyright (C) 2015 Zaza	2018-03-15T07:00:00.000Z	0
PRD_0SDF7TDTS4FG	CNT_1JF3Z3J8WCN0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 2	[]	The Combat Baker and Automaton Waitress: Volume 2	While business was stabilizing at Tockerbrot Bakery, its owner, Lud Langart, received a surprising invitation. A party was to be held on a large airship for the purpose of building a friendship between Wiltia and Pelfe. Sven persuaded the reluctant Lud to accept the invitation to bake for the party in order to increase his bakery's popularity. However, political speculation and conspiracy mean danger is swirling behind the scenes.	Lud receives an invitation to an international party on an airship between Wiltia and Pelfe. Sven persuades Lud to bake for the party as a sales stunt. However, danger is swirling behind the scenes.	01KGA18E4PQPPEBG9DXZ491QNR	2.0	2017-12-15T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 2	Copyright (C) 2015 SOW Illustrations Copyright (C) 2015 Zaza	2017-12-15T08:00:00.000Z	0
PRD_1F276F0KD8YG	CNT_0EHGN3HRZSX0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 10	[]	The Combat Baker and Automaton Waitress: Volume 10	Everyone celebrated Lud and Sven's wedding with them. However, human and machine lifespans are vastly different, so Sven decides to become human. Meitzer knows how to accomplish this, so she goes to meet him, but he has been abducted by the Security Department. Lud and company take action to rescue Meitzer and find themselves caught up in the Saint's schemes to start another Great War. However, they're no longer a war hero and a weapon—they're just a normal baker and a popular waitress. This record of an eventful small-town bakery reaches its moving finale!	After Lud and Sven's wedding, Sven wants to become human. Meitzer knows how, but he was abducted by the Security Department. While Lud and company try to rescue him, they get involved in the Saint's plans for another Great War. The moving finale!	01KGA7XQVTS20NK3RMSZGE9JG7	10.0	2020-03-27T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 10	Copyright (C) 2019 SOW Illustrations Copyright (C) 2019 Zaza	2020-03-27T07:00:00.000Z	0
PRD_1XBBKYPCT540	CNT_39DDSSHW2HAG	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 9	[]	The Combat Baker and Automaton Waitress: Volume 9	Lud finds out Sven is an automaton when mechanical soldiers targeting Meitzer attack Organbaelz. But before they can come to grips with this new situation, Daian and Blitzdonner appear out of thin air, throwing Tockerbrot into even greater confusion. Usually, Jacob would be there to calm everyone down, but the sudden appearance of his father causes him to make himself scarce. One year since Sven became the bakery's popular waitress, she and Lud are finally beginning to work out their misunderstanding. But as the Saint sows disorder behind the scenes, their future is still uncertain...	Lud finds out Sven is an automaton when mechanical soldiers targeting Meitzer attack Organbaelz. But before they can come to grips with this new situation, Daian and Blitzdonner appear out of thin air, throwing Tockerbrot into even greater confusion. Usually, Jacob would be there to calm everyone down, but the sudden appearance of his father cau...	01KGA71FAJT93E30SWAJ974749	9.0	2019-05-28T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 9	Copyright (C) 2018 SOW Illustrations Copyright (C) 2018 Zaza	2019-05-28T07:00:00.000Z	0
PRD_228KSK30YGBG	CNT_3EV4VXTGXNFG	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 6	[]	The Combat Baker and Automaton Waitress: Volume 6	At the end of the year, the town of Organbaelz holds a Holy Festival to praise the Saint of Europea. It's said that, on the night of the festival, the Saint comes to hand out presents to good children and the Devil comes to take away bad children--and Sven and Lud are going to disguise themselves for these roles! This volume contains the story of the Holy Festival for which the two are bustling about baking new sweets and donning costumes. Also contained within is a story revealing the secrets surrounding Daian Fortuner, a.k.a. the Sorcerer, and a story about Hilde, who has enlisted in an officer's school known as the Preparatory School for Young Ladies. Volume 6 in this popular series revolves around these three stories and the characters after the Genitz's rebellion!	Short stories about the Holy Festival with Lud and Sven baking new sweets and donning costumes, revealing Daian Fortuner's secrets, and Hilde who has enlisted in an officer's school known as the Preparatory School for Young Ladies.	01KGA59N777Z32ABME0N5P3E23	6.0	2018-10-19T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 6	Copyright (C) 2016 SOW Illustrations Copyright (C) 2016 Zaza	2018-10-19T07:00:00.000Z	0
PRD_2616K1BKMXM0	CNT_3SJCJ21RK1Y0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 7	[]	The Combat Baker and Automaton Waitress: Volume 7	One day, Sven returns to Tockerbrot Bakery to find a robber has holed up inside with hostages! Lud—and Sven, after she plunges in—are able to resolve the crisis, but it marks the beginning of a string of unfortunate events. A group of citizens begins protesting outside the shop, clamoring for justice and drastically hurting Tockerbrot's customer flow. Later, when Lud appears in court as a witness, his actions during the war fall under scrutiny. To make matters worse, Mary—a woman Lud believed to be dead—has returned to haunt him yet again with ghosts from his past. What can Sven do to stop her Master from giving up on life as a baker?!	After rescuing hostages from a robber in Tockerbrot, Lud and Sven are caught up in a string of misfortune. Citizens protest outside the shop, Lud has his war history scrutinized, and Mary returns to haunt him with ghosts from his past.	01KGA5GCA24D6XWA3TM8HQGV1J	7.0	2018-12-07T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 7	Copyright (C) 2017 SOW Illustrations Copyright (C) 2017 Zaza	2018-12-07T08:00:00.000Z	0
PRD_2V47EG2NV5R0	CNT_0JTDFTQ4QX5G	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 2: Exclusive additional chapter [Bonus Item]	[]	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 2: Exclusive additional chapter [Bonus Item]	Exclusive additional chapter for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 2”.	Exclusive additional chapter for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 2”.	01KJM9BA2HME2BBD9R9Q9X12YQ	1.0	2017-12-15T08:00:00.000Z	Hobby Japan LAB_21VPHZMGHM20	GEO_1PQM5BDYSMG0	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 2: Exclusive additional chapter [Bonus Item]	(C)SOW	2017-12-15T08:00:00.000Z	1
PRD_2YWH69NBEW10	CNT_066G0KWQA110	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 5	[]	The Combat Baker and the Automaton Waitress: Volume 5	Lieutenant General Genitz of the Wiltian Schutzstaffel finally reveals himself to be the enemy--and he steals Sven away from Lud's side! In Berun, the royal capital, even Sophia becomes a prisoner, and the Weapons Development Bureau falls into the hands of the Schutzstaffel. In a tighter pinch than ever before, can Lud overcome his horrible past and, together with its lovable star waitress, reopen his bakery Tockerbrot?!	Lieutenant General Genitz reveals himself and steals Sven away! In Berun, even Sophia becomes a prisoner, and the Schutzstaffel takes over the Weapons Development Bureau. Can Lud overcome his horrible past reopen his bakery Tockerbrot with Sven?!	01KGA4ZH10D9B8Z4MPGQGG68R4	5.0	2018-08-17T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and the Automaton Waitress: Volume 5	Copyright(C) 2016 SOW Illustrations Copyright(C) 2016 Zaza	2018-08-17T07:00:00.000Z	0
PRD_2ZNBSCPVCKVG	CNT_030QNDWWTYWG	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 4	[]	The Combat Baker and the Automaton Waitress: Volume 4	Lud is exhausted from Tockerbrot's booming business when he receives a request to bake savory breads for the Thanksgiving festival. Meanwhile, Hildegard of the Schutzstaffel and a covert operative called the Wolf Man come to Organbaelz to assassinate Lud. But Sven easily sees through Hilde's disguise and the two ne'er-do-wells are captured. Then Lud asks the Wolf Man if he knows how to bake bread...	Lud is asked to bake for the Thanksgiving festival. Meanwhile, Hildegard and the Wolf Man come to assassinate Lud. Sven easily sees through Hilde's disguise and the two are captured. Then Lud asks the Wolf Man if he can bake bread...	01KGA3F55DART0M6DA1ZV3J315	4.0	2018-06-05T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and the Automaton Waitress: Volume 4	Copyright(C) 2016 SOW Illustrations Copyright(C) 2016 Zaza	2018-06-05T07:00:00.000Z	0
PRD_33TC6CF9SMH0	CNT_0PD4YEK4EFP0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 3: Exclusive additional chapter [Bonus Item]	[]	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 3: Exclusive additional chapter [Bonus Item]	Exclusive additional chapter for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 3”.	Exclusive additional chapter for readers who purchase “The Combat Baker and Automaton Waitress, Vol. 3”.	01KJMA16314V4HEBAYCDA5WFX4	1.0	2018-03-15T07:00:00.000Z	Hobby Japan LAB_21VPHZMGHM20	GEO_1PQM5BDYSMG0	BOOK☆WALKER Exclusive: The Combat Baker and Automaton Waitress, Vol. 3: Exclusive additional chapter [Bonus Item]	(C)SOW	2018-03-15T07:00:00.000Z	1
PRD_3JDHVHAA61Z0	CNT_0NBAWE87DNV0	The Combat Baker and Automaton Waitress CNT_29GVGR8Y6Y4G	CNT_29GVGR8Y6Y4G	2	2	1	Volume 8	[]	The Combat Baker and Automaton Waitress: Volume 8	One day, a mysterious man named Meitzer appears at Tockerbrot Bakery. He claims to be Sven's father, but she's an automaton, so she can't possibly have any blood relatives... In the royal capital, Sophia and Hilde welcome a baffling general from the nation of Noa on the new continent. Meanwhile, Daian sneaks into the rival nation of August with Blitzdonner to examine a certain relic. Eventually, these separate events in different places intersect, leading to an astounding conclusion of even bigger proportions.	One day, a mysterious man named Meitzer appears at Tockerbrot Bakery. He claims to be Sven's father, but she's an automaton, so she can't possibly have any blood relatives... In the royal capital, Sophia and Hilde welcome a baffling general from the nation of Noa on the new continent. Meanwhile, Daian sneaks into the rival nation of August with ...	01KGA6DEJ0Y4N14MJ21DT6GGKE	8.0	2019-02-11T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Combat Baker and Automaton Waitress: Volume 8	Copyright (C) 2018 SOW Illustrations Copyright (C) 2018 Zaza	2019-02-11T08:00:00.000Z	0

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);