database: products: 14 rows where series_id = "CNT

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

14 rows where series_id = "CNT_0NE6MTQ8QJ40"

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
PRD_06GBFB6N3JG0	CNT_12556TEFJ3MG	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 5	[]	Witch Hat Atelier 5	In a world where everyone takes wonders like magic spells and dragons for granted, Coco is a girl with a simple dream: She wants to be a witch. But everybody knows magicians are born, not made, and Coco was not born with the gift for magic. She's resigned to her un-magical life, until a traveling magician passes through her village, and Coco learns what what everybody ""knows"" might not be the truth.		01KGA8TVCXVV65BQM8JZJ2ZHRK	5.0	2020-03-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 5	Kamome Shirahama / Kodansha Ltd.	2020-03-17T07:00:00.000Z
PRD_0SFMHGMK9EAG	CNT_071ZJNPQ12YG	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 7	[]	Witch Hat Atelier 7	As the new trial comes to an end, one of Coco's rewards from Beldaruit the Wise is the story of Qifrey's past and how he came to desire the mysteries of magic. Feeling a connection with her own desire to save her mother, Coco departs for the source of all answers: the Tower of Tomes. But it is a perilous journey to make on her own, and the secrets held within could sway even the most virtuous of witches...		01KG9DM72SC9M8GD454NRN1FWB	7.0	2020-12-09T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 7	Kamome Shirahama / Kodansha Ltd.	2020-12-29T08:00:00.000Z
PRD_112KB9WJJ190	CNT_02VW5T3JK12G	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 11	[]	Witch Hat Atelier 11	THE PRICE OF KNOWLEDGE As the new trial comes to an end, one of Coco's rewards from Beldaruit the Wise is the story of Qifrey's past and how he came to desire the mysteries of magic. Feeling a connection with her own desire to save her mother, Coco departs for the source of all answers: the Tower of Tomes. But it is a perilous journey to make on her own, and the secrets held within could sway even the most virtuous of witches...		01KH3FFVXEJ93K204AB8SKY6FK	11.0	2023-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 11	Kamome Shirahama/Kodansha Ltd.	2023-09-12T07:00:00.000Z
PRD_1EHPN6J8Z4SG	CNT_0T5RMCC8G3J0	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 12	[]	Witch Hat Atelier 12	Coco and Agott spun a well-received spectacle at the Silver Eve procession, but the wonder is quickly dispelled when an enormous terror descends upon the streets of Ezrest. The crowd is thrown into a frenzy, and the Knights Moralis, the King, and the Wise Ones rush forth to keep destruction at bay. Coco turns to Qifrey about Custas and Dagda, but no one's safety can be guaranteed once the intentions of all are laid bare under the starry sky		01KGAZZ6KS60EY1N6Z41G5BH8K	12.0	2024-04-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 12	Kamome Shirahama/Kodansha Ltd.	2024-05-21T07:00:00.000Z
PRD_1G5CDKSC3E5G	CNT_3CKWAX32R170	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 9	[]	Witch Hat Atelier 9	AT THE BORDERLINE With their magic contraptions in hand, Coco and her friends head to Ezrest for the annual festival, Silver Eve! The cobblestone streets of the crown city are lined with vibrant tents, and visitors from across the land partake in reunions and greetings anew. Here, witches, royals, the Knights Moralis, and even the Three Wise converge—each party carrying with them their private motivations and powerful histories. However, the bright lights and merriment lure in the uninvited as well...		01KGAGS9C19E7821A49R377KPN	9.0	2022-06-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 9	Witch Hat Atelier Kamome Shirahama/Kodansha Ltd.	2022-06-21T07:00:00.000Z
PRD_1R4A38MQETM0	CNT_1WH298ZRFJ60	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 13	[]	Witch Hat Atelier 13	The true mastermind responsible for the havoc in Ezrest is subdued at last, but not without exacting a heavy price on Coco. She is still eager to rejoin the search for Custas, and fortunately Beldaruit knows just the spell to allow her to do so without overworrying Qifrey. Meanwhile, the other witches are called to where they are most needed in the aftermath. As strings of fate never meant to interact are further entangled, the starlight reveals society's true nature.		01KG9RKE7CG79MVGCFFGG35FZ9	13.0	2024-12-24T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 13	Kamome Shirahama/Kodansha Ltd.	2025-01-14T08:00:00.000Z
PRD_1TW1WTGYQQ20	CNT_1W0BKW4Y1W2G	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 6	[]	Witch Hat Atelier 6	Coco and her peers follow Olruggio and Luluci as they deftly ferry a wounded Qifrey to the underwater Great Hall where witches gather. To their surprise, Beldaruit of the Three Wise Ones awaits the young apprentices at the bottom of the ocean... And he's willing to offer another trial after Agott's and Richeh's was cut short. But the spells and tests of Beldaruit are as much a mystery to unfold as his past, and Coco may be the only one who can put the pieces together and close in on the startling truth...		01KGA99APDG0V216EV504CKDJC	6.0	2020-06-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 6	Kamome Shirahama / Kodansha Ltd.	2020-06-16T07:00:00.000Z
PRD_1XZ0563STXM0	CNT_0GJ6QR3BPA2G	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 10	[]	Witch Hat Atelier 10	FOR THOSE IN NEED During their heated reunion, Custas introduces his old friends to Ininia, a girl who is loyal to one of the Brimmed Caps. Suddenly, the young witch binds Coco and Tartah to a promise: The two must partake in the Silver Eve Procession. But to do so, they must conjure up a new spell, and quickly. As the weight of many secrets bears down on her, Coco cannot turn to Qifrey or her friends. When she happens upon Dagda, she sees his chest is marked with a forbidden magic...		01KGAJSYE632KT1FBXSV5T7W5D	10.0	2022-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 10	Witch Hat Atelier Kamome Shirahama/Kodansha Ltd.	2022-11-15T08:00:00.000Z
PRD_281QX2K5ZAZ0	CNT_3RWK5YD1Z67G	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 1	[]	Witch Hat Atelier 1	In a world where everyone takes wonders like magic spells and dragons for granted, Coco is a girl with a simple dream: She wants to be a witch. But everybody knows magicians are born, not made, and Coco was not born with a gift for magic. Resigned to her un-magical life, Coco is about to give up on her dream to become a witch...until the day she meets Qifrey, a mysterious, traveling magician. After secretly seeing Qifrey perform magic in a way she's never seen before, Coco soon learns what everybody “knows” might not be the truth, and discovers that her magical dream may not be as far away as it may seem...	A TOUCH OF MAGIC	01KG9B3FBGYH7HVBBHN2QZH7FB	1.0	2019-03-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 1	(C) Kamome Shirahama / Kodansha Ltd.	2019-04-09T07:00:00.000Z
PRD_2E5X19N53BX0	CNT_1AWCW1NGQCZG	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 4	[]	Witch Hat Atelier 4	""TWISTED PATHS Can Coco and her friends pass their most harrowing test yet? Or will the nefarious Brimmed Caps end their journey towards witch-hood?! Now that Coco has been fully accepted into Qifrey's Atelier, it's time for her and her colleagues to move onto the next test: The Sincerity of the Shield. Passing the test involves escorting some feathery friends to their nesting grounds, which sounds simple enough, except that the path before the young witches is a winding road filled with ancient magical traps! The test must also be completed in a group, and there's one witch-in-training from outside of Qifrey's atelier who doesn't seem to have the confidence to make the cut. To top it all off, a Brimmed Cap lurks in the shadows, waiting to attack...""		01KGA7PT66Y9TPZYH98DB9YJ0R	4.0	2019-10-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 4	Kamome Shirahama / Kodansha Ltd.	2019-11-12T08:00:00.000Z
PRD_2T7Z5W25Z0VG	CNT_0X12DQPZ4VT0	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 2	[]	Witch Hat Atelier 2	Join Coco as she continues her spellbinding journey of magic and discovery! After traveling to the mystical township of Kalhn with her new master to buy a casting wand, a strange, masked witch transports Coco and her three sister apprentices to an eerily quiet city. But they soon find out that they're not alone, and they encounter a ferocious dragon! Do these fledgling witches have what it takes to defeat the fire-breathing beast, or will their plans and lives go up in flames?!	TRIAL BY FIRE	01KGA78DTVG00P5229Q7SBG9XQ	2.0	2019-06-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 2	(C) Kamome Shirahama / Kodansha Ltd.	2019-06-25T07:00:00.000Z
PRD_2YGYJ2KT2GKG	CNT_02E8FSCMAHKG	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 14	[]	Witch Hat Atelier 14	At long last, Dagda and Custas are back together, reunited in the medical tower. All they should have to do now is wait for the doctors to treat them. But at that moment, Qifrey has a terrible premonition. Meanwhile, Coco has a plan to defend the town from the rampaging valance leeches. But it's a long shot that'll need all the town's witches to work together...		01KKWSMZG5JKEJMRE4JEG4XWHB	14.0	2026-03-03T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 14	Kamome Shirahama/KODANSHA LTD.	2026-03-17T07:00:00.000Z
PRD_3D19CHEYSPY0	CNT_0HMTTJ2GKA2G	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 8	[]	Witch Hat Atelier 8	After ﬁnding success together in their second trials, Coco and her friends return to the warmth of the atelier. Before long, they are approached by Tartah from Kalhn, and he needs their help setting up shop at the thrilling witches' festival, Silver Eve! But to design a contraption to sell there, the young students must consider the power of magic—at once delightful, beneﬁcial, and potentially harmful. As Coco makes preparations alongside Tartah, she's reunited with Custas, a boy who was saved by Coco once before, but is convinced that luck will never shine on him again...		01KG9GXA63HC66R4X7Z274AW0R	8.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 8	Kamome Shirahama / Kodansha Ltd.	2021-09-28T07:00:00.000Z
PRD_3XJ59ARS01QG	CNT_2RGWRZRPFWY0	Witch Hat Atelier CNT_0NE6MTQ8QJ40	CNT_0NE6MTQ8QJ40	2	1	1	Volume 3	[]	Witch Hat Atelier 3	Cast yourself into the world of witch es as Qifrey chases after the dark mysteries of the Brimmed Caps! With some quick thinking and ingenuity, Coco and her fellow classmates use their growing magic skills to save some locals from a grim fate. But this triumph nearly turns to tragedy as the Knights Moralis threaten the young witches with severe punishment for disturbing the natural order of magic. Qifrey convinces the Knights to overlook this issue, but a peculiar happening related to this incident puts him onto the trail of the same forbidden magic that brought Coco into his atelier. This may be Qifrey's only chance to come into contact with the Brimmed Caps, but is he in over his head to engage in this treacherous pursuit on his own?	AN INKY INVESTIGATION	01KGA7DD4GJNZZK256ZR188VQ5	3.0	2019-07-24T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Witch Hat Atelier 3	(C) Kamome Shirahama / Kodansha Ltd.	2019-08-27T07: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);