database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_0R7PFXV271M0"

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_03GY81VTBCT0	CNT_00MA54AJGDJG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 5	[]	Full Metal Panic! Volume 5	On orders from Mithril, Sousuke has been forced to abandon Kaname to focus on learning the secrets the Arbalest and the lambda driver. Meanwhile, Kaname—left to the care of a remote and anonymous intelligence agent—feels the threat from a mysterious pursuer drawing ever closer. Their challenges will lead them both to the tension-racked streets of Hong Kong, a city even more divided than the burgeoning couple's destinies. And a series of climactic showdowns will bring them to a reckoning with enemies old and new!	Sousuke is recalled to Mithril to focus on the Arbalest, while Kaname, left alone, is targeted by a mysterious pursuer. Their fates will be decided in the streets of Hong Kong, a city sitting on a powderkeg!	01KG9BGWWFGWFZREE6RWNR6N85	5.0	2019-10-30T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 5	Copyright (C) 2001 Shouji Gatou Illustrations by Shikidouji	2020-01-09T08:00:00.000Z
PRD_07TSEXKQ1J7G	CNT_3R4DMEBA1EE0	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 3	[]	Full Metal Panic! Volume 3	Kaname is in the doldrums: There's just one week until the end of summer vacation, and she hasn't done anything interesting! Fortunately, Sousuke is here to provide a little adventure, by offering her a trip to Merida Island. But what starts for Kaname as a simple trip to learn more about the mystery surrounding her quickly snowballs into a firefight in a chemical weapons facility, a reunion with a mortal enemy, and a battle for control of a runaway submarine! However things turn out, at least she can't claim that her summer was uneventful...	A simple summer trip for Kaname and Sousuke quickly gets out of hand as the Tuatha de Danaan reunites with a deadly enemy.	01KGA7AX934SV95CCP9DEWNH1W	3.0	2019-07-10T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 3	Copyright (C) 2000 Shouji GatouIllustrations by Shikidouji	2019-09-07T07:00:00.000Z
PRD_0C3MMRZG0H30	CNT_2QTVKT9TDP1G	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 8	[]	Full Metal Panic! Volume 8	Sousuke has been torn away, not just from Kaname, but from the entire life he's made for himself. His flight brings him to a lawless border town in Southeast Asia, whose economy revolves around mech battles played out for sport and profit. On a lead that Amalgam is involved with the corrupt authorities there, Sousuke joins a ragtag team headed by an impetuous young local and her reluctant foreign sponsor. But as he seeks what he's lost, will Sousuke lose what he's gained?	Sousuke's search for Kaname and Amalgam brings him to a Southeast Asian town, where mech battles are played out for sport and profit.	01KG9CNK3FVZKZ023A5Y0K2Q24	8.0	2020-06-23T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 8	Copyright (C) 2006 Shouji Gatou Illustrations by Shikidouji	2020-09-02T07:00:00.000Z
PRD_0RCC20V84AY0	CNT_08EJDN2FE4GG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 12	[]	Full Metal Panic! Volume 12	Clouseau and Mao lead the charge in Afghanistan to prevent nuclear war, while Sousuke and Tessa invade Merida Island, intent on stopping Leonard and his world-changing TARTAROS device. With resources depleted and the very world changing around them, their desperation to find each other is all they have left. Will Kaname awaken from her nightmare? Will Sousuke get through to her in time? Will anyone survive?! All bets are off in the explosive final volume of Full Metal Panic!	Will Sousuke and Kaname be together at last? The battle ends with a bang in the final volume of Full Metal Panic!	01KG9F5G86QGNAH7D1YZFPWXWD	12.0	2021-04-16T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 12	Copyright (C) 2010 Shouji Gatou Illustrations Copyright (C) 2010 Shikidouji	2021-06-25T07:00:00.000Z
PRD_0TB99465AAF0	CNT_3H831DAFZZNG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 9	[]	Full Metal Panic! Volume 9	All hope is not lost! Mithril might be scattered to the four winds for now, but its members continue to work toward the same goal. While Tessa concocts a plan to strike back at Amalgam, Hunter conspires to create a new ace machine to turn the tide. Meanwhile Sousuke—even with few allies, limited resources, and a body riddled by mortal wounds—remains determined to free Kaname from Leonard's clutches. Can these disconnected factions meet up and begin working together in time?!	All hope is not lost! Mithril might be scattered to the four winds for now, but its members continue to work toward the same goal. While Tessa concocts a plan to strike back at Amalgam, Hunter conspires to create a new ace machine to turn the tide. Meanwhile Sousuke—even with few allies, limited resources, and a body riddled by mortal wounds—rem...	01KG9D2QVMEHK0VHCS313WCAEF	9.0	2020-08-25T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 9	Copyright (C) 2007 Shouji Gatou Illustrations by Shikidouji	2020-11-22T08:00:00.000Z
PRD_1AS0S2S5ZX1G	CNT_20QZ51GMVET0	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 7	[]	Full Metal Panic! Volume 7	The Pacific Chrysalis was Mithril's first true victory over Amalgam, but their success has only led to escalation. Between growing suspicion at school and cryptic warnings from Tessa's brother that everything is about to change, Sousuke begins to realize that his peaceful life in Tokyo might not last much longer. Before he can even prepare, though, Sousuke finds himself running a gauntlet beyond anything he could have imagined. He'll have to fight not just for his own life, but for the life of everyone he knows!	When Amalgam escalates their war on Mithril, Sousuke finds himself running a gauntlet beyond anything he could have imagined.	01KGA91P2B6722FT7EPFEFCSC3	7.0	2020-04-16T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 7	Copyright (C) 2004 Shouji Gatou Illustrations by Shikidouji	2020-06-29T07:00:00.000Z
PRD_1DB7G6678S90	CNT_1G77RRQGGNNG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 1	[]	Full Metal Panic! Volume 1	Sagara Sousuke isn't your typical high school student. He reads military enthusiast magazines; he responds to questions with “affirmative;” he brings grenades to school in his bag. Though everyone at school takes him for a hopeless military geek, Chidori Kaname thinks there might be something more to him. When their plane is hijacked in the middle of a field trip, Kaname's instincts will prove correct: Sousuke is an elite, mech-piloting mercenary... and he's here to protect her!	Everyone at school thinks Sousuke is a hopeless military geek, but Kaname thinks there might be something more to him. When their plane is hijacked, her instincts prove correct: Sousuke is a mech-piloting mercenary, and he's here to protect her!	01KGA5W993AYVJ0THNQRHBT771	1.0	2019-04-17T15:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 1	Copyright (C) 1998 Shouji GatouIllustrations by Shikidouji	2019-05-08T07:00:00.000Z
PRD_1PV2XN66BJR0	CNT_2M0GHQSV23WG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 6	[]	Full Metal Panic! Volume 6	What could be more romantic than Christmas Eve on a cruise ship? That's what Kaname is thinking when her school decides to schedule a make-up class trip... at least, until Sousuke declares that he's made other plans. He'll soon find that he's needed, though, as the ship finds itself beset by half-hearted terrorists, killer robots in the hold, and worst of all—a wannabe hero who's seen too much Die Hard! With the specter of Amalgam hanging over everything, can Sousuke probe the mystery behind them, while also keeping Kaname safe from harm?	The school's Christmas cruise quickly goes awry, with half-hearted terrorists, killer robots, and a wannabe hero who's seen too much Die Hard! Can Sousuke keep Kaname safe?	01KGA8FWXF4C7VW8E91VGHWZ60	6.0	2020-01-20T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 6	Copyright(C) 2003 Shouji Gatou Illustrations by Shikidouji	2020-03-29T07:00:00.000Z
PRD_2CC13DBP9QE0	CNT_1BFJ9H3BRBT0	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 11	[]	Full Metal Panic! Volume 11	The secrets of the Whispered have been revealed, but that knowledge has only brought new danger. Leonard has retreated to Merida Island, where he seeks to rewrite reality itself with Kaname by his side. And with Mithril's forces already aching and depleted, Amalgam has occupied a Soviet missile base—with the intent to trigger worldwide nuclear war! It's a two-fronted battle on Merida Island and the mountains of Afghanistan for the penultimate volume of Full Metal Panic!	In the penultimate volume of Full Metal Panic!, Mithril must split its forces to save Kaname, stop Leonard--and prevent an all-out nuclear war!	01KG9ENWDFMMPJ9GRCY07HRFRS	11.0	2021-02-12T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 11	Copyright (C) 2010 Shouji Gatou Illustrations by Shikidouji	2021-04-23T07:00:00.000Z
PRD_2TETNYDW8CYG	CNT_3423JDTP6R70	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 2	[]	Full Metal Panic! Volume 2	Two months after Sunan, Sousuke and Kaname are in a holding pattern. He'll fire his rifle off the school roof; she'll yell at him to stop; lather, rinse, repeat. That all changes one day, when Sousuke's commanding officer Teletha ""Tessa"" Testarossa shows up at his apartment, trying to hide a key to a terrorist superweapon of unprecedented power. Tessa is brilliant, pretty, and the same age as Sousuke, and her presence might put a serious crimp on his relationship with Kaname... assuming the city survives the night!	Sousuke's commanding officer, Tessa, shows up at his apartment, trying to hide a key to a terrorist superweapon of unprecedented power. Her presence might put a serious crimp on his relationship with Kaname... assuming the city survives the night!	01KGA7765KNKCW7P70398YXTHT	2.0	2019-06-04T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 2	Copyright (C) 1999 Shouji GatouIllustrations by Shikidouji	2019-07-12T07:00:00.000Z
PRD_2WY9F3YQFZD0	CNT_38JJQQ7KHVHG	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 4	[]	Full Metal Panic! Volume 4	With the defeat of Gauron, Sousuke's life has entered a comfortable rhythm. He's adjusting to school--the occasional car bomb false alarm notwithstanding--and balancing his newly-found normalcy with the needs of his mercenary life. He's even started to turn his thoughts toward the future--a future that might involve Kaname. But that future will soon face a threat, not from North Korean soldiers, Italian mobsters, or Russian spetsnaz... but from the hierarchy of Mithril itself!	Sousuke is beginning to dream of a normal life and a future with Kaname. But a threat to that future will soon arrive, from the hierarchy of Mithril itself!	01KGA7H4BR10VB4JGN5QYTN59E	4.0	2019-09-13T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 4	Copyright (C) 2000 Shouji GatouIllustrations by Shikidouji	2019-10-29T07:00:00.000Z
PRD_30K3ZH8TM4V0	CNT_2KDVEZHKZRD0	Full Metal Panic CNT_0R7PFXV271M0	CNT_0R7PFXV271M0	2	2	1	Volume 10	[]	Full Metal Panic! Volume 10	The battle at Niquelo ignited in Sousuke and Kaname a new passion to find each other, but the rest of the world won't make it that easy. While Sousuke fights, waiting for the operation that might bring her back to his arms, Kaname endures new trials at the hands of a jealous tormenter. Everything comes to a head in an abandoned Soviet research town, and the winding tunnels beneath it—tunnels that hosted a catastrophe seventeen years ago, and which might hold the secret to the Whispered themselves!	Mithril and Amalgam converge on an abandoned Soviet research town, seeking answers to the mysteries of the Whispered.	01KG9DERGDADVHF85WWSMRE80D	10.0	2020-11-13T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Full Metal Panic! Volume 10	Copyright (C) 2008 Shouji Gatou Illustrations by Shikidouji	2021-02-20T08: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);