database: products: 19 rows where series_id = "CNT

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

19 rows where series_id = "CNT_11QCDYPV3DS0"

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_05W448R3CMXG	CNT_2Q50DGKENS5G	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 10	[]	Magika Swordsman and Summoner Vol. 10	Hikaru has never really been in touch with her feminine side, but for a chance at getting closer to Kazuki, master swordsman and Harem King, she's willing to give it a shot! A romantic evening and movie date is just the thing to bring them together...until flashing swords intervene. Magic and steel clash as a three-way brawl unfolds, and foreign warriors fight on the streets of Japan!	A TABLE (AND SWORDS) FOR TWO	01KGA5HTJP1ATWHNBQPZ5BRHBF	10.0	2018-11-30T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 10	MonRin 2018, Mitsuki Mihara 2018	2018-12-31T08:00:00.000Z
PRD_06M1P4M50HS0	CNT_0BRMCHY1RX5G	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 11	[]	Magika Swordsman and Summoner Vol. 11	The Selection Tournament's grand finals loom near! Whoever claims victory will snag the coveted position of joint student council president, but Kazuki's foe doesn't just want the prize--she wants his head. Shizuka is a spy for the dangerous Sinotao Country, and she'll use all the power at her disposal to see Kazuki dead. It's a battle that will test the full might of the Harem King!	GRAND FINALS	01KGA73B8DC6GH09C7D28W2VFX	11.0	2019-04-26T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 11	MonRin 2018, Mitsuki Mihara 2018	2019-06-11T07:00:00.000Z
PRD_0VSZ58SJX7E0	CNT_2H71YAR21WM0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 9	[]	Magika Swordsman and Summoner Vol. 9	The Kengika and Magika are due to select their Joint Student Council President, and the candidates will earn their votes the way they know best: through battle! A tournament is underway, and for Kazuki, everything is on the line. Skill at arms, mastery of magic, and the bonds of friendship will all be tested as the fighting rages on!	The Tournament Begins!	01KGA3G6KYK9XJKASVGSB75JBK	9.0	2018-05-27T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 9	MonRin 2017, Mitsuki Mihara 2017	2018-06-26T07:00:00.000Z
PRD_16YPG8F0PC20	CNT_1SE650R14Z10	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 6	[]	Magika Swordsman and Summoner Vol. 6	Welcome to Magika Academy, where students duel with swords and magic! Master Swordsman Kazuki Hayashizaki enrolled after forming a binding contract with a magic-wielding diva, and though he has defeated the Ace of the Northern European Knights, his battles are far from over. This time he must face his greatest foe yet: Magika student council president Otonashi Kaguya, the most powerful student at Magika Academy.	SWORDS + SORCERY	01KG98ASPFQF6K9NPAKQZE1FHT	6.0	2017-02-21T04:59:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 6	(C) Mitsuki Mihara 2014, (C) Mitsuki Mihara 2014	2017-02-21T04:59:00.000Z
PRD_1WMQ672PRKD0	CNT_3F8VGWPJY3FG	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 17	[]	Magika Swordsman and Summoner Vol. 17	Kazuki fights off Ilyaelia with the power of the Three Sacred Treasures. Now, his magic exhausted, must go on a sizzling date to increase his Level of Affection...but with whom? Meanwhile, Kanae seeks to perfect a new sword technique, one that can tip the balance of power between sword and spell! Just in time too, as the attack on the Magical Domain is entering its final stage!	SPELL-BREAKING SWORD TECHNIQUE!	01KGAZFPFX5YS57CSFNFT9A23H	17.0	2024-02-19T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 17	Friendly Land 2023, Mitsuki Mihara 2023	2024-04-09T07:00:00.000Z
PRD_28MDMGJDR6FG	CNT_34KAVA0JK1B0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 4	[]	Magika Swordsman and Summoner Vol. 4	Kazuki Hayashizaki has made progress as a summoner with his contracted diva, Leme, but the results of his efforts are soon to be tested. He enters the Inter-Department Tournament as a representative for the Magika and there must face off against the demon god Loki, But when Kazuki and Mio join forces and embark on quests off-campus, trouble brews in their absence, as a new transfer student appears--one who happens to be a peculiar princess from Northern Europe!	LET THE GAMES BEGIN!	01K5GB0YA3KGAN82XK87CMSW9E	4.0	2016-06-27T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 4	(C) Mitsuki Mihara 2014, (C) Mitsuki Mihara 2014	2016-06-27T15:00:00.000Z
PRD_2KWNAJ90DAXG	CNT_3CF7F8XB0N50	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 2	[]	Magika Swordsman and Summoner Vol. 2	Kazuki Hayazhizaki's plan to become a swordsman of the prestigious Hayashizaki family changed when he received the Enigmas - the mark of a summoner. Against his sister's objections, he entered the Magika - an all-girls' school dedicated to training summoners. His diva, Leme, informed him that she has no powers of her own, and instead uses the powers of divas contracted to the other summoners. However, in order for her to access these powers, Kazuki must make those girls fall head over heels for him first! For now, he has challenged Mio Amasaki - one of the same girls Leme wants him to court - to a duel to prove the strength of the sword and the Hayashizaki style! As Kazuki is dealing with the result of that duel, a figure from his past resurfaces - with a friend...		01K5GARXCY54V8ETCEKK1TAF77	2.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 2	(C) Mitsuki Mihara, (C) Mitsuki Mihara	2015-11-13T15:00:00.000Z
PRD_2V9QCAN5N4DG	CNT_1K29NRCZHTR0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 15	[]	Magika Swordsman and Summoner Vol. 15	To ascend to the mystic throne and be declared King of Japan. one must find the Three Sacred Treasures which are rumored to be hidden in the monster-filled Sea of Trees around Mt. Fuji. This rule, which was imposed by meddling outsiders from the Magically Advanced Countries, means that Kazuki, must personally take up the challenge! Will his plans come to fruition...or will Loki's machinations allow the god of mischief to put a puppet on the throne?	TREASURE HUNT	01KGAGECXEZ6RKFPPQQNCQS73S	15.0	2022-04-20T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 15	Friendly Land 2021, Mitsuki Mihara 2021	2022-04-21T07:00:00.000Z
PRD_2VCB1CVHZCP0	CNT_1SP4DTNWRDPG	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 12	[]	Magika Swordsman and Summoner Vol. 12	The battle to decide Knight Academy's new unified student council president ends with betrayal: Shizuka Hayashi turns out to be a spy for the land of Sinotao, and escapes to foreign shores. And after a brief interlude of romance, Kazuki and his fellow students find themselves at the core of an explosive conflict. With backing from Sinotao and a host of spirits, West Japan declares its independence, and full-scale war engulfs the country. The swordsmen and summoners of the Academy soon find themselves on the battlefield, with the fate of their nation at stake!	A LAND DIVIDED	01KGA7T171A1A202MP4XJ0EAT4	12.0	2019-12-20T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 12	MonRin 2019, Mitsuki Mihara 2019	2020-01-28T08:00:00.000Z
PRD_304C2WDCMCTG	CNT_3BY78ZJJMM0G	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 18	[]	Magika Swordsman and Summoner Vol. 18	In order to retrieve the Sacred Treasure known as the Grass-Cutting Sword, Kazuki and his companions head to the Magical Domain's snow-topped mountain, only to discover that the guardian of the treasure is none other than a retired hero--Kazuki's mother! Their joyous family reunion is cut short when Hel, daughter of Loki, launches an attack. Whose family ties are stronger, and whose shall be sliced in half?!	MOTHERS, DAUGHTERS, MAGIC SWORDS!	01KGBJ5Z2N4XK0PESXCQ2YZN0F	18.0	2024-11-15T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 18	© Friendly Land 2024, © Mitsuki Mihara 2024	2024-12-10T08:00:00.000Z
PRD_355JB7C36HS0	CNT_278VCV4V6VTG	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 1	[]	Magika Swordsman and Summoner Vol. 1	Parallel to our dimension is a world filled with magic, home to a host of mystical beings and fantastical powers. Humanity has learned to harness these forces and bring forth that world's entities to do their bidding through the power of ""summoners."" Our world has never been the same. Fifteen years later, Kazuki Hayashizaki is chosen as the first male summoner. His attendance in an all-female summoner class, however, is met with opposition - and none so strongly than from his own sister, the school's most skilled swordsman. As Kazuki is torn between the way of the sword and the world of summoning, can he overcome adversity and learn to harness his new powers?	A Kind of Magic	01K5G9S889MT6H6WKSY6CBXNAK	1.0	2015-10-04T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 1	(C) Mitsuki Mihara 2014, (C) Mitsuki Mihara 2014	2015-10-04T15:00:00.000Z
PRD_3DHH67ANQBVG	CNT_19P3V82EESC0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 19	[]	Magika Swordsman and Summoner Vol. 19	Kazuki is finally reunited with his mother--only to lose her! He is now in possession of a keepsake of his mother's, the sacred grass-cutting sword, but without even any time to grieve, he is confronted by the king of Yamato, Ikousai. In the ancient town of Sekigahara, the showdown between the dueling kings of Japan and Yamato is set to begin!	FINDERS, KEEPERS! LOSERS...	01KGBVQ2AP2TZ2FQTFCXEG4VJ7	19.0	2025-08-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 19	© Friendly Land 2025, © Mitsuki Mihara 2025	2025-10-28T07:00:00.000Z
PRD_3NGQKN1NHNDG	CNT_10R1SH32C8PG	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 5	[]	Magika Swordsman and Summoner Vol. 5	Master swordsman Kazuki Hayashizaki is settling into his predetermined role of a summoner, but the Magika's only male student has a long way to go yet. After failing to pass one of their quests, Kazuki and Mio are allowed a second attempt alongside Scandinavian transfer student, Lotte. But, when the trio is attacked by a mysterious female knight, everything they've learned suddenly seems for naught. Then, as if things weren't bad enough, a giant beast appears! Will Kazuki live long enough to capture the hearts of his classmates, or is this the end of his short summoning career...?	SEDUCE THE HEROINE, SAVE THE WORLD!	01KG987SD85V9RSMKMWTS2J06F	5.0	2016-10-11T06:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 5	(C) Mitsuki Mihara 2014, (C) Mitsuki Mihara 2014	2016-10-11T06:00:00.000Z
PRD_3NJ405PK8T3G	CNT_2GS3YXK534J0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 14	[]	Magika Swordsman and Summoner Vol. 14	After forming a contract with Amaterasu, Kazuki has become king of both the Solomon and Japanese mythoi. Just when he thought the war between Yamato and Japan was coming to a close, the emperor of the Russian Empire, Ilyaelia Murometz, has invaded. She claims to have come to demand a ceasefire, but what is her real aim?	A NEW WRINKLE	01KG9F2GQA8R36XCDXND75YTSD	14.0	2021-04-06T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 14	Friendly Land 2020, Mitsuki Mihara 2020	2021-04-20T07:00:00.000Z
PRD_3PMGM8DBGJ40	CNT_0ACHYYTRDD70	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 16	[]	Magika Swordsman and Summoner Vol. 16	The treasure hunt to rule Japan continues in the obstacle-filled Sea of Trees around Mt. Fuji! Amidst the battles between representatives from all the different nations, Kazuki crosses swords with the leader of the Pro-Sword Party, Hidetada. In the middle of their battle, the Russian Tsarina Ilyaelia enters the fray--equipped with one of Japan's Three Sacred Treasures, the Eight Tan Mirror! Can Kazuki win against the most powerful Russian Tsarina? Can he claim the sacred birthright of his homeland?!	MIRROR, MIRROR	01KH3GRYQ48GDFXK9AKGXQRC5D	16.0	2023-08-17T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 16	Friendly Land 2022, Mitsuki Mihara 2022	2023-09-19T07:00:00.000Z
PRD_3QGCZBD787QG	CNT_10KPDJ0WJVW0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 13	[]	Magika Swordsman and Summoner Vol. 13	To put a dent in Western Japan's military might, Kazuki must travel to Ise Grand Shrine--in enemy territory--to persuade the deity Amaterasu to pacify the Japanese Divas. But if he wants to succeed, he'll need to add a queen to his harem! Does Kazuki have what it takes to become a Great King, surpassing all others?	DEUS EX MAGIKA	01KG9CXNFGC6FGJ3D66GGKJ29G	13.0	2020-07-31T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 13	Friendly Land 2019, Mitsuki Mihara 2019	2020-08-25T07:00:00.000Z
PRD_3VR6CH2BY320	CNT_3XW21FNAHCK0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 8	[]	Magika Swordsman and Summoner Vol. 8	The dust of the seventh match has settled. School life for Kazuki and his friends goes back to normal, until they are tasked with establishing a combined Magika and Kengika administration. Step one is finding a Joint Student Council President and Kazuki himself is soon thrust into the election. The new principal of the school has given him an ultimatum: become Joint Student Council President or leave the Witches' Manor!	GOVERNING BODY	01KG9VV28WNH4BXHBEW7ZJ9VEH	8.0	2017-10-30T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 8	(C) MonRin 2017, (C) Mitsuki Mihara 2017	2017-12-05T08:00:00.000Z
PRD_3WJCK6AKD7X0	CNT_264CXFDEMJ6G	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 3	[]	Magika Swordsman and Summoner Vol. 3	Kazuki Hayashizaki, the only boy in the all-girls' Magika, is starting to accept his fate as a summoner rather than a swordsman. But after a decisive victory in the dueling arena, the teachers believe Kazuki's rightful place is at the Kengika, the school for training swordsmen. No feels this more strongly than Kazuki's adoptive sister, Kanae, who challenges him to a duel that would pit her sword skills against his summoning magic. If Kazuki wins, it will prove once and for all that he has what it takes to become a summoner and should remain at the Magika. There's only one hitch--Kazuki's spells are mysteriously running dry, and time is running out!		01K5GAW6RMMQY366NJ2TMRH3BV	3.0	2016-02-01T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 3	(C) Mitsuki Mihara 2014, (C) Mitsuki Mihara 2014	2016-02-01T15:00:00.000Z
PRD_3ZA5S819EQS0	CNT_21WWP4GS00M0	Magika Swordsman and Summoner CNT_11QCDYPV3DS0	CNT_11QCDYPV3DS0	2	1	1	Volume 7	[]	Magika Swordsman and Summoner Vol. 7	A strange and turbulent magic is on the loose at the Magika! While investigating the suspicious power in the basement, Kazuki and the others enter a hidden facility - only to find themselves face-to-face with Principal Otonashi...and his dark, demonic secrets! The seventh match of sword and sorcery is about to begin!!	SINISTER SPELLWORK	01KG9Z7ZNA83A4W13TYG755K3X	7.0	2017-07-19T04:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Magika Swordsman and Summoner Vol. 7	(C) Mitsuki Mihara 2017, (C) Mitsuki Mihara 2017	2017-07-19T04: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);