database: products: 26 rows where series_id = "CNT

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

26 rows where series_id = "CNT_0BMMC5Z9CN00"

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	on_sale_at
PRD_03VXJ8GHBWN0	CNT_00PKPCQRA460	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 26	[]	The Irregular at Magic High School, Vol. 26	Parasites are taking over magicians left and right. Several of Lina’s infected teammates make an attempt on her life, but after the rebellion at the Stars’ headquarters, she successfully escapes. Thankfully, Tatsuya and Miyuki can give her refuge on Miyaki, an island controlled by the Yotsuba clan. They’re not out of the woods yet, though, as everyone is eager to capture Lina for their own purposes. Meanwhile, Minoru—who has become a parasite himself—launches an assault on the hospital to kidnap Minami, and only the Saegusa sisters can stop him! The parasite invasion continues, pressure mounts, and magicians around the world prepare to clash. How will Tatsuya navigate this maelstrom?!	01KH2TM8ENY4GJR4W3JEXPF6M8	26.0	2025-10-21T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 26	2026-02-10T00:00:00.000Z
PRD_04NGD8PRHAA0	CNT_3A2SZ7B0P3V0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 3	[]	The Irregular at Magic High School, Vol. 3	The Nine School Battle. Ever year in mid-July, students from magic high schools all over the country gather to participate in fierce competitions of magical skill. Miyuki Shiba is among the members of the team First High will send to the battle. The magical skill of the competitors will be a huge factor, but there's another one-the tuning of their CADs. Luckily, they've got someone with them who specializes in the field-Miyuki's older brother Tatsuya. But when the Nine School Battle is targeted by a sinister group, all the talent in the world may not be enough to secure victory...	01KG9ZSB2W0SFJQXGV8HXV0PZM	3.0	2017-11-28T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 3	2017-11-28T08:00:00.000Z
PRD_04PYX8GD7XH0	CNT_3SE3HYBMQZMG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 19	[]	The Irregular at Magic High School, Vol. 19	Gu Jie, a magician who orchestrated a sinister suicide bombing by manipulating corpses to do his bidding, has gone into hiding somewhere in Japan. As public outcry against magicians builds and humanist forces gain momentum, the Ten Master Clans task Tatsuya, Katsuto, Mayumi, and Masaki with determining the whereabouts of the mastermind behind the bombings. But when Major Benjamin Canopus, the second-in-command of the most powerful magic unit in the United States, starts gunning for Gu Jie as well, Tatsuya becomes inexplicably enraged!	01KGAGH9T10S933V3VD12SFKPF	19.0	2022-04-25T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 19	2022-05-31T00:00:00.000Z
PRD_0BZ0VZ8DJ53G	CNT_1MMEF6DYQFRG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 21	[]	The Irregular at Magic High School, Vol. 21	March 2097—Brazil deploys the strategic-class spell Synchroliner Fusion in South America, starting a wave of unrest that will reach as far as Japan, where the new school year is just beginning. Tatsuya and Miyuki have entered their third year at First High, but anti-magician sentiment has been steadily rising. As many young scions of the twenty-eight families gather to discuss what to do about the concerning political climate, a much more immediate threat sits just beyond the shores of Sado Island…	01KH3HKRCKKF4J5V3HJD40DPPF	21.0	2023-08-21T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 21	2024-01-23T00:00:00.000Z
PRD_0GMTMWEZZQPG	CNT_0MZZN17VRF4G	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 25	[]	The Irregular at Magic High School, Vol. 25	After an attack by one of the Thirteen Apostles, Tatsuya and Miyuki have narrowly escaped unscathed. However, Minami teeters on the edge of death, much like Honami, who protected Tatsuya at the cost of her life. Meanwhile, Minoru seeks the forbidden power of the parasites to fulfill his desire to protect what’s dear to him and more. Will his choice shake the foundations of the future? And what will happen when he and Tatsuya finally clash?	01KGBJWTB0KQ0X3E8A7BFZQA03	25.0	2024-12-10T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 25	2025-07-15T00:00:00.000Z
PRD_0NDFJ8YG591G	CNT_1A481EY5GY1G	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 9	[]	The Irregular at Magic High School, Vol. 9	Miyuki's classmate Shizuku Kitayama is on her way to study abroad. For magicians, this is normally impossible, since allowing the genes of someone who can use magic outside their home country's borders is tantamount to giving up national secrets. But it's allowed to happen in one case-exchange programs. And that's how Angelina has arrived in Japan from the USNA to study at First High. But it seems she's a part of something much bigger than a simple cultural exchange!	01KGA55FA4XAJANCWBZT23A1JJ	9.0	2018-09-18T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 9	2018-09-18T07:00:00.000Z
PRD_0STZSDGVQW90	CNT_3KES3ZYQNRNG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 11	[]	The Irregular at Magic High School, Vol. 11	At the same that the leader of the USNA's elite magician unit, the Stars, traveled to Japan under the identity of an exchange student named Lina, the parasite incident wreaked havoc on the First Magic High School until Tatsuya and his friends saved the day and brought the incident to a peaceful conclusion. However, the parasite merely lost its first host and continues to wander this world. More importantly, it's found its next host-a humanoid helper robot. After copying Honoka Mitsui's behavior and patterns, the parasite has been reborn as Pixie, vowing to follow and serve Tatsuya. After learning more about parasites from Pixie, Tatsuya gathers Miyuki and the others to head towards the Aoyama Cemetery to fight against a new impending danger!	01KGA6JR3Z1MRT6PP6WB00GBCE	11.0	2019-03-19T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 11	2019-03-19T07:00:00.000Z
PRD_0ZPFXQ6Y3XE0	CNT_24W3XH5X3R0G	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 16	[]	The Irregular at Magic High School, Vol. 16	The invitation has arrived. It is time for the New Year’s Reception at the Yotsuba family residence. This year, Miyuki and other candidates will gather there to decide who will be the next leader of their powerful clan. If chosen as the successor, she would never have to see her brother live as a pariah ever again. At the same time, such a position surely entails a political marriage, plunging her mind into complete turmoil. Complicating matters, the current head of their family sows doubt with the shocking claim that Miyuki is not Tatsuya’s sister. When the new year comes, their relationship may be changed forever...	01KG9F1EDW028M07JPY3DB5HEF	16.0	2021-03-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 16	2021-04-27T07:00:00.000Z
PRD_11J25FSD6A2G	CNT_0J68GJ0HWP30	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 12	[]	The Irregular at Magic High School, Vol. 12	April 2096 has arrived. Despite the commotion they were involved in, Tatsuya and Miyuki safely passed all of their classes and are now returning as juniors for another semester. In light of Tatsuya’s accomplishments, a magic engineering curriculum has been established, granting him a new lease on proper student life. With his new classes and his position as acting student council vice president, Tatsuya is certain that this year for sure, he’ll be able to enjoy a peaceful time at school with his sister…until three freshmen form the elite Numbered families start raising hell in their First High debut!	01KGA73Q44YK7H92W9GDC4VWVA	12.0	2019-07-12T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 12	2019-07-12T07:00:00.000Z
PRD_1ADRTV9NT9AG	CNT_2AKP5AK66D2G	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 24	[]	The Irregular at Magic High School, Vol. 24	The video message from Raymond Clark, one of the Seven Sages, makes waves not just in Japan but across the entire world by announcing the Dione Project, which Tatsuya realizes is essentially a plan to exile magicians from the planet. To counter this, Tatsuya unveils his very own ESCAPES Project, a project utilizing a stellar reactor that he has been researching for some time. The time to determine the future of magicians everywhere has come!	01KGBC7Z7YQM82D5P65PSNJGAQ	24.0	2024-08-14T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 24	2025-01-21T00:00:00.000Z
PRD_1AE578CCJXV0	CNT_2ABXB49BTPA0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 2	[]	The Irregular at Magic High School, Vol. 2	Tatsuya and Miyuki Shiba are brother and sister, but they share a bond that transcends mere blood relation. Despite the fact that they're siblings who attend the same school, their lot in life couldn't be more different. Miyuki's a Bloom, one of the elite students of Magic High, while Tatsuya's a Weed, with low expectations and even lower levels of respect. But having skillfully diffused a tense situation, Tatsuya finds himself recruited by the school's disciplinary committee and soon discovers there's more to Magic High than he realized...	01KG9ZQRS4EJVXWF22RJSPJEC0	2.0	2017-10-31T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 2	2017-10-31T07:00:00.000Z
PRD_1WARX9T3TQWG	CNT_0Q48ZHAYB490	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 20	[]	The Irregular at Magic High School, Vol. 20	Spring is here, and the graduating seniors of First High are planning a getaway to sunny Okinawa. At the same time, Tatsuya and Miyuki will be on the island as the Yotsuba family’s representatives at a memorial service for the victims of the invasion there several years earlier. Of course, this is just a cover for their true purpose: foiling a terrorist plot hatched by some deserters and Australian operatives. Their primary target is a party that Shizuku and Honoka will be attending—What are the chances? Romance is in the air, and danger is on the horizon, making this a vacation they’ll never forget!	01KGAJS7HCQZ7PSEWMATW97TX5	20.0	2022-09-30T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 20	2022-10-18T00:00:00.000Z
PRD_235JAM92YJ90	CNT_20WE74R4TYNG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 13	[]	The Irregular at Magic High School, Vol. 13	July 2096. Another year means another summer, and that means a new Nine School Competition. Just to spice things up, the participants are informed only weeks before the event that there are some massive rule changes! While everyone’s running around frantically trying to figure out what they should do, Tatsuya catches wind of another plot that might be brewing behind the scenes of this year’s competition. As the shadows rise for the second year in a row…let the games begin!	01KGA7K8QBBJGXSCKA3A7E4QWV	13.0	2019-09-19T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 13	2019-10-15T07:00:00.000Z
PRD_26C9MY7VKBTG	CNT_2AD3FYHWHMBG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 4	[]	The Irregular at Magic High School, Vol. 4	The rookie competition is one of the most highly anticipated spectacles of the Nine School Competition and a chance for freshman athletes to shine. First High's beloved Miyuki Shiba takes center stage during these matches to give a beautifully elegant performance. Her brother, Tatsuya, doesn't have a moment to waste as he works around the clock as part of the engineering team, relaxing only when he gets a chance to admire his sister from behind the scenes. But after his teammates fall prey to a horrific accident, Tatsuya is suddenly thrust into the spotlight and set on a direct collision course with the Crimson Price, Masaki Ichijou!	01KG9ZSBWQ61EE4R8K79VTDNWB	4.0	2017-11-28T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 4	2017-11-28T08:00:00.000Z
PRD_2F1M9NY2JPV0	CNT_1V4HK12D71Q0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 23	[]	The Irregular at Magic High School, Vol. 23	Watching the news has been rather unpleasant for Tatsuya lately. It seems like whenever he tunes in, it’s just one bad story after another. Just as he feared, it was only a matter of time before strategic magic was used again—this time by the Great Asian Alliance. Things hit much closer to home when a spell Tatsuya developed for the Nine School Competition years ago is tied to a brutal guerilla attack against GAA forces. These violent events only fan the flames of anti-magician sentiment, and it isn’t long before rising tensions provoke a response, culminating in the announcement of the Dione Project, an ambitious plan to develop Venus with magic. While Tatsuya has his doubts about the new space program’s true goal, this problem is about to get very personal when Taurus Silver is named as a prime candidate!	01KH3QK65JJHSZQXTM5MCV6Z91	23.0	2024-04-02T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 23	2024-09-24T00:00:00.000Z
PRD_2HPNGTGK8PMG	CNT_28WTBNNNQSV0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 17	[]	The Irregular at Magic High School, Vol. 17	With the New Year comes a wave of changes. Though few are surprised that Miyuki has formally been recognized as the next head of the Yotsuba family, no one could have anticipated her engagement to Tatsuya would be finalized at the same time. As Honoka and the others try to digest the information, the Ichijou family immediately objects to the union, proposing that Miyuki marry their scion, Masaki Ichijou, instead. Meanwhile, with the world of magic watching intently, the powerful gather to select the next Ten Master Clans...	01KG9GJA3DNKS4E8DE80SAGWC4	17.0	2021-08-04T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 17	2021-09-14T00:00:00.000Z
PRD_2JSMCAYCVP80	CNT_1KX35Q8QE050	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 6	[]	The Irregular at Magic High School, Vol. 6	The nationwide All-High Magic Thesis Competition is lauded as a more cerebral and refined contest than the action-packed Nine School Competition. After seeing more than enough gunfights and magical duels in between classes, this change of pace suits Tatsuya just fine. Unfortunately, not every spectator is content with simply enjoying the event. With rival students, intelligence operatives, and a foreign assassin all in attendance, Tatsuya might need more than just his wits to keep everyone safe!	01KG9ZSZJAB77966V47YESYV0C	6.0	2017-12-19T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 6	2017-12-19T08:00:00.000Z
PRD_2N99WXZQ5WVG	CNT_2PH9YBS6PGZG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 8	[]	The Irregular at Magic High School, Vol. 8	Looking at Miyuki and Tatsuya now, it might be hard to imagine them as anything other than loving siblings. But it wasn't always this way... Three years ago, Miyuki was always uncomfortable around her older brother. The rest of their family treated him no better than a lowly servant, even though he was the perfect Guardian, watching over Miyuki while she lived a normal middle school life. But what really bothered her was that he never showed any emotions or thoughts of his own.However, when danger comes calling during a fateful trip to Okinawa, their relationship as brother and sister will change forever...	01KGA4QYYW7VE9D4E938GQJFES	8.0	2018-06-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 8	2018-06-26T07:00:00.000Z
PRD_2Z9FSXD85G00	CNT_0FH64GXX5GP0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 22	[]	The Irregular at Magic High School, Vol. 22	Tatsuya hasn’t won many new fans with his less-than-friendly behavior at a recent gathering of the Twenty-Eight Families who were in Yokohama to discuss the concerning rise in anti-magician movements. As usual, he puts Miyuki’s safety above all else, even if it means souring relations between the Yotsuba and the other clans. And that’s not the only problem he has to be worried about. Quite a few people are having doubts as to where Tatsuya’s loyalties really lie, and it seems they’re willing to go to extreme lengths to find out!	01KGAXRNM61B3B13S6QNG2A3GB	22.0	2023-12-21T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 22	2024-05-21T00:00:00.000Z
PRD_301D9H56JE7G	CNT_3D3H0SWX7040	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 14	[]	The Irregular at Magic High School, Vol. 14	Two months have passed since the nefarious events surrounding the latest Nine School Competition, and its cerebral counterpart, the Thesis Competition, is fast approaching. Helping out First High with the event, Tatsuya will surely have his work cut out for him even if everything goes according to plan. Of course, nothing ever does, which might explain the letter from Maya Yotsuba containing a curious request: to assist in the capture of Gongjin Zhou, one of the masterminds behind the recent Parasidoll incident. Tatsuya and Miyuki depart for Kyoto, where they’ll have to keep their wits about them to safely navigate the hidden schemes and shadowy conflicts that lurk just beneath the surface of the ancient capital!	01KGA7SG7G0PAZNZSK5R07D1GN	14.0	2019-12-12T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 14	2019-12-31T08:00:00.000Z
PRD_36M5JBXWHATG	CNT_1RYFP7YHNYRG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 10	[]	The Irregular at Magic High School, Vol. 10	December, 2095. In exchange for Shizuku going to study in the USNA, Lina has been attending Magic High School in Japan. Tatsuya figured out her true identity as a member of USNA special forces right away but as soon as one mystery is solved, another breaks out. Right around the same time as Lina's arrival in Japan, there has been a series of attacks on magicians by something called the "vampire." But while Tatsuya and Mikhiko try to use old magic to discover the identity of this criminal, an assault on their school occurs!	01KG9ATYX86MCEWA4X178SXCD7	10.0	2018-12-18T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 10	2018-12-18T08:00:00.000Z
PRD_38QDSJYHGWAG	CNT_3A0KVD4G35VG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 1	[]	The Irregular at Magic High School, Vol. 1	The year is 2095. Magic has been tamed as another form of technology, and the practice of magic is now a rigorous discipline. Brother and sister Tatsuya and Miyuki Shiba are just about to start their first year at the renowned First Magic High School of Japan. But the school's ironclad rules mean that the brilliant Miyuki enters the prestigious Course 1, while her older brother, Tatsuya, is relegated to Course 2--and that's just the beginning of their troubles!	01KG9ZGN4RNA2ZG6G500PENPW5	1.0	2017-10-31T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 1	2017-10-31T07:00:00.000Z
PRD_3CGDV0FFXQRG	CNT_0G8CAEDK9GNG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 5	[]	The Irregular at Magic High School, Vol. 5	After the conclusion of the Nine School Competition, summer arrives in force, bringing with it that most precious salvation for students--vacation! Shizuku invites Tatsuya, Miyuki, and their friends to her family's island villa for a bit of fun in the sun, but all of this is just a pretext to set the perfect tropical stage for Honoka's romance. Meanwhile, the ace of Third High, Masaki, entertains Kichijouji at home, unaware of his partner's struggle with self-doubt. Shun finds himself playing bodyguard to a beautiful foreigner, and Eimi is cornered for a secret she can't reveal at any cost. The one who's got it toughest, though, is Mayumi, who's desperate to find the next student council president before time runs out!	01KG9ZT001E4BD0JEFZ5SP625T	5.0	2017-12-19T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 5	2017-12-19T08:00:00.000Z
PRD_3EKHX46QJC40	CNT_07VRNWJXQE0G	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 15	[]	The Irregular at Magic High School, Vol. 15	Only a scant few weeks remain before the Thesis Competition, which becomes the perfect excuse for Tatsuya and Miyuki to scour Kyoto for the fugitive Gongjin Zhou. Together with Minoru Kudou, a Kyoto local, they comb the ancient city’s streets in what appears to be a fruitless search. Even though the clock is ticking, all their leads seem to go nowhere—until Tatsuya gets word that Mayumi’s bodyguard has turned up dead by the Katsura River. With new clues and new allies kicking the manhunt into high gear, the party quickly closes in on their quarry’s hideout, unaware of what lies in wait for them once they finally catch up...	01KGA8W27Q1J1VPC39Y8A69VQT	15.0	2020-03-12T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 15	2020-04-07T07:00:00.000Z
PRD_3NA4YDMGS6R0	CNT_3G9QYZ1EY1Z0	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 7	[]	The Irregular at Magic High School, Vol. 7	It's time for the National Thesis Competition to take place in Yokohama but what was supposed to be a grand event for the participating students has been turned into a battlefield. A mysterious band of armed magicians and mechanized weapons have stormed in and it may be up to Tatsuya and the others to get everyone home safely!	01KGA3A3GKQ2TS85J1JDWDMVSG	7.0	2018-03-27T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Irregular at Magic High School, Vol. 7	2018-03-27T07:00:00.000Z
PRD_3XQ8B1K8DQNG	CNT_2Q53KMRRXVYG	The Irregular at Magic High School CNT_0BMMC5Z9CN00	CNT_0BMMC5Z9CN00	2	2	1	Volume 18	[]	The Irregular at Magic High School, Vol. 18	A suicide bombing brings the Master Clans Council to an abrupt close! Armed with only the knowledge that the explosion was triggered by corpse manipulation magic, Tatsuya sets off in search of the perpetrator along with Jumonji. After being egged on by his father, Masaki trails behind them to Tokyo in an attempt to one-up Tatsuya’s investigation. But things take a turn for the unexpected when Masaki summons up the courage to propose to to Miyuki…	01KGAD7QZ57ME4DZHEV2J7REG3	18.0	2021-12-09T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Irregular at Magic High School, Vol. 18	2022-01-18T00: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);