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

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_011EQF8NW83G	CNT_03R8Z9SS9SR0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 7	[]	Flying Witch Volume 7	Makoto and her cousins head out to the yomiya, a night festival. There they run into the Harbinger of Summer who tends to oversleep. To apologize for causing it to snow on their house, the Harbinger offers them a treasured delicacy from the other side. Makoto has been raising mandrakes in the garden, but something has gone awry! Akira takes Makoto to a hot springs where a reporter tries to get a scoop about witchcraft. Akane goes to great lengths to cure Inukai, but she might not be ready to change back...!		01KGA7WPN2CRWCHKMS1XQMC6FV	7.0	2020-02-26T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 7	Chihiro Ishizuka / Kodansha Ltd.	2020-03-17T07:00:00.000Z
PRD_0B2XAAD2ZBZ0	CNT_27X5R1ET7FV0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 6	[]	Flying Witch Volume 6	Everyone gathers to grill giblets to celebrate Chinatsu's first bit of witchcraft. The familiars are lured to school with the promise of a tasty lunch... which draws the attention of an upperclassman witch. Makoto is tasked with solving a case where people get spirited away, but the solution turns out to be very down-to-earth...		01KGA4J9P136W70MZFCZG2J8ET	6.0	2018-05-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 6	(C) Chihiro Ishizuka / Kodansha Ltd.	2018-06-05T07:00:00.000Z
PRD_0BAB71GWBPZG	CNT_25GXQ23F637G	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 11	[]	Flying Witch Volume 11	A Wonderful Summer Summer finally comes to a close for Makoto and her friends-but not without incident! In Aomori, Beachy makes a surprise visit and helps Chinatsu with a summer project that's out of this world. Meanwhile, in Tokyo, Akane gets sauced and puts Makoto's plans to return to Aomori on hold. And when Makoto gets back, she'll find plenty of surprises waiting for her. However, the biggest surprise comes when her friends find Makoto in a compromising situation that might just expose her status as a witch.		01KGB2TQWFDFY9W428JAA8C06S	11.0	2022-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 11	Chihiro Ishizuka/Kodansha Ltd.	2023-01-11T08:00:00.000Z
PRD_110DQFNS4MF0	CNT_16DMHDVGTG80	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 5	[]	Flying Witch Volume 5	Makoto gets her first official job request from a Society Witch, and while the job seems mundane at first, a bit of immature magic makes for an unexpected situation. Makoto uses the payment from the job to buy a magical item that reveals the invisible. Chinatsu's gift from Beachy starts to wreak havoc, until it's reduced to a form that lets her use a spell...		01KGA3A9V15VYQAVV3RWJVG72Z	5.0	2018-03-12T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 5	(C) Chihiro Ishizuka / Kodansha Ltd.	2018-03-20T07:00:00.000Z
PRD_1Q34BKSNFSQG	CNT_2BE66ZR7S2EG	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 3	[]	Flying Witch Volume 3	Makoto and her cousins visit a cafe run by a witch that's cloaked in magic and has regular visitors from folks on the “other side.” Inukai stops by to make amends, and Nao gets a taste of some spicy medicine. Akane drops by just in time for a very special sighting of a rare, sky-borne animal...	A Slice of Magic	01KG9ZBBBJVQFH25QZE6B5VAHV	3.0	2017-08-28T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 3	Chihiro Ishizuka / Kodansha Ltd.	2017-09-26T04:00:00.000Z
PRD_1ZZJK416TXTG	CNT_3P3EVCK8DCH0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 12	[]	Flying Witch Volume 12	To atone for stopping time under the influence, Makoto's sister Akane must undertake a challenging job for the Society. Her mission: retrieve a sacred artifact from a long-sealed chamber in the Tibetan mountains or risk forever staining her reputation. Back in Aomori, Makoto fits a friend in a handmade robe-only to unexpectedly unleash a little chaos. And when a special visitor asks for help, Makoto and her crew put all their skills to the test in a task that, if done wrong, could spell the end of the human race.		01KGAZP0MP199JXBMX2GY2H65E	12.0	2024-03-05T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 12	Chihiro Ishizuka/Kodansha Ltd.	2024-03-26T07:00:00.000Z
PRD_2GBMHS7XPY3G	CNT_1VNMQJDPYFR0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 8	[]	Flying Witch Volume 8	Makoto and her family journey to the peaceful region of Shimokita, where a mysterious figure called ""Enigumo"" can supposedly help Makoto find out which element she can control. The cousins chow down on sea urchin and have fun at the beach, completely unaware that her element might defy all expectations ... Join the gang on this mystical—and surprisingly explosive—adventure!		01KGA92SW69TP72PM1T4XRK22D	8.0	2020-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 8	Chihiro Ishizuka / Kodansha Ltd.	2020-05-12T07:00:00.000Z
PRD_2HBHS0G4YA8G	CNT_09QHMA317ZBG	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 10	[]	Flying Witch Volume 10	Summer Showers and Sourpusses As summer continues, Makoto takes a trip back home to Kanagawa. However, her time there won't be all fun and games. She and her friends have to solve the mystery of a temple that appears to be cursed with constant daily rain. Before long, they find the culprits, but a communication issue may just leave Makoto and her companions all wet!		01KGAD9P3KKZ7N9F3TB270MWCA	10.0	2021-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 10	Flying Witch Chihiro Ishizuka/Kodansha Ltd.	2022-01-11T08:00:00.000Z
PRD_2K97P5SYK530	CNT_0F6Q3TBBSQP0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 13	[]	Flying Witch Volume 13	Preparations for the Great Sabbath, a worldwide witchy event held once every twenty years, have kicked into full gear, and to Makoto's delight, Aomori is on the list of candidate host cities. She, Akane, and Maria try to amplify its appeal to the judges who have come to tour the city-only to be blindsided by a very sneaky sabotage campaign. It also comes to light that a missed milestone has put Chinatsu in dicey spiritual territory. Now, it's up to Makoto to save her soul!		01KGBS9X5MXQZY9S49YR3GH36Y	13.0	2025-07-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 13	Chihiro Ishizuka/KODANSHA LTD.	2025-07-29T07:00:00.000Z
PRD_2VB40M12J6G0	CNT_2S8Y6EAQA8K0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 1	[]	Flying Witch Volume 1	Makoto Kowata, a novice witch, packs up her belongings (including her black cat familiar) and moves in with her distant cousins in rural Aomori Prefecture, in the far north reaches of Japan, to complete her training and become a full-fledged witch.		01KG98M5QB6ZKX6DMJ0S3V5MB2	1.0	2017-04-10T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 1	(C) Chihiro Ishizuka / Kodansha Ltd.	2017-04-25T05:00:00.000Z
PRD_32GHW1MAG8EG	CNT_29TYY3M24J7G	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 2	[]	Flying Witch Volume 2	Natural Enchantment -- Makoto goes to a local cherry blossom festival and happens to encounter someone who has a bone to pick with her sister, Akane. When Akane happens to drop by, she teaches Makoto some new tricks for flying and some easy spellcraft. Their kid cousin Chinatsu is so charmed by the witches' talents that she makes an unexpected request…		01KG9Z3Z6K5FWXXFED9KBTB77S	2.0	2017-05-29T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 2	(C) Chihiro Ishizuka / Kodansha Ltd.	2017-06-27T05:00:00.000Z
PRD_35TZNFPWGTBG	CNT_0169J3HWYEXG	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 9	[]	Flying Witch Volume 9	Summertime Magic Makoto and her companions experience summer celebrations of all sorts, from the spectacular lantern floats of Aomori's most famous festival to an otherworldly procession dedicated to exotic beasts. Along the way, they'll conquer mountainous desserts, reunite with an old friend, and make potentially groundbreaking discoveries in magic. Enjoy the ongoing, charm-filled adventures of Makoto and her crew as they have fun under the sun and more in Aomori!		01KG9ES9MVFQ8AS9B9G1GM85W3	9.0	2021-02-17T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 9	Chihiro Ishizuka / Kodansha Ltd.	2021-03-09T08:00:00.000Z
PRD_3ZZ1ZAQVX9QG	CNT_33ET2M2R00X0	Flying Witch CNT_3FZF3806DKF0	CNT_3FZF3806DKF0	2	1	1	Volume 4	[]	Flying Witch Volume 4	Serene Sorcery Makoto makes her way to a fabric shop in town in order to sew a new robe, and ends up crafting a surprise for Chinatsu, too. Makoto combines her mundane studies with a bit of witchcraft and makes a freaky treat. On the way home from a late-night meeting with her mentor, Makoto runs into Inukai. They head to the beach and meet an adorably mysterious creature that immediately makes itself at home...		01KGA18XP4WC2G202HYGMR9FKY	4.0	2017-12-12T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Flying Witch Volume 4	(C) Chihiro Ishizuka / Kodansha Ltd.	2017-12-19T08: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);