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

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_01753WAX9RWG	CNT_0S4E90PFZTRG	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 4 Under Pressure	[]	86--EIGHTY-SIX, Vol. 4 Under Pressure	Old Friends, New Enemies Against all odds, Shin and the Eighty-Six have emerged victorious from their battle with the Morpho, liberating scores of surviving Republic citizens from the Legion's dark agenda. Lena, in turn, has fulfilled her promise and finally caught up to the Spearhead squadron. And while her presence has brought out a softer side in Shin, it seems to have roused the competitive spirits within Kurena and Frederica. But the fun comes to an end when the Eighty-Sixth Strike Package, with Lena at the helm, receives its first mission. Their destination: an abandoned subway tunnel in the Republic's northern secondary capital, Charité. Deep underground, the gaping maw of a subterranean Legion base awaits them...	01KGB65MPTGAXW2Q9WYVS1R90K	4.0	2023-03-30T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 4 Under Pressure	2023-04-18T07:00:00.000Z
PRD_08FV9ZQTW8AG	CNT_26KZF63DJBE0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 9 Valkyrie Has Landed	[]	86--EIGHTY-SIX, Vol. 9 Valkyrie Has Landed	LIKE LOOKING IN A MIRROR... For better or worse, the battle with the Noctiluca has drawn to a close...for now. The Eighty-Six's minds are heavy with thoughts of close friends and bitter enemies swallowed by the cold, dark abyss. Among the casualties are Shana, Shiden's vice captain, joining the fallen in their watery grave, and Theo, whose loss of his left hand had all but sealed his fate as a Processor. As Shiden swears revenge, Kurena, who blames herself for Shana's death, cracks beneath the weight of her guilt. While the Eighty-Six struggle to pick up the pieces, though, the Legion inexorably pursue their bloodless objective, and the Noctiluca has reportedly taken refuge in the surviving Holy Theocracy of Noiryanaruse. Now Shin and company must set foot in the mysterious western nation of which even the United Kingdom and the Federacy are wary...	01KGC246NPQ6RRX7T7KYDVF6CQ	9.0	2024-05-28T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 9 Valkyrie Has Landed	2024-06-11T07:00:00.000Z
PRD_0EXNFY1KG9AG	CNT_1ZCYJS1CG45G	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 7 Mist	[]	86--EIGHTY-SIX, Vol. 7 Mist	FOREVER...IF POSSIBLEThe Merciless Queen, a high-ranking commander unit for the Legion, has finally been taken into custody. Now the Federacy, the United Kingdom, and the Alliance of Wald can conduct a thorough analysis of this special Ameise, which houses the consciousness of Legion developer Zelene Birkenbaum. If their efforts bear fruit, they may learn the secret to stopping the Legion once and for all! In the meantime, the Federacy has decided to rest its battle-worn blades. The Eighty-Sixth Strike Package has been allowed leave for the first time in ages. As they arrive in the Alliance of Wald's territory, they are able to step away from the iron and blood and enjoy a rare vacation! And it seems that two members of the Strike Package are getting a bit cozier than the rest...	01KGAT8W5WJ0GK74R8RHFGAB69	7.0	2023-11-15T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 7 Mist	2023-12-12T08:00:00.000Z
PRD_0KEM2HHCWYV0	CNT_0XQESC3Y46V0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 12 Holy Blue Bullet	[]	86--EIGHTY-SIX, Vol. 12 Holy Blue Bullet	THE PRICE OF PEACEThe Republic's evacuation resulted in massive casualties on both sides, and the fallout takes a toll on all survivors. As Shin ruminates on what it means to be a leader, Lena thinks of the homeland now lost to her forever. Frederica, too, is dismayed by her own powerlessness as the ill-fated final Empress of Giad. If her future is to change, she'll have to change first. Meanwhile, unrest is brewing within the Federacy, and a few disaffected squadrons, desperate to turn the tide of the war, reach for a dangerous miracle...	01KGC1X47BRW2D1R32YDP4R5EB	12.0	2025-11-26T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 12 Holy Blue Bullet	2025-11-28T08:00:00.000Z
PRD_0WASZH3VVSDG	CNT_05N7HM5NASD0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 5 Death, Be Not Proud	[]	86--EIGHTY-SIX, Vol. 5 Death, Be Not Proud	Live to fight. Die with honor. That was all the Eighty-Six knew, and they were proud. However, seeing themselves reflected in the Sirins-slaughtered by the thousands, with nothing to show for it-a crack has formed in their ironclad resolve. Shin's mind festers with doubt. At the same time, Lena's heart tears at the seams as she struggles to understand him. Will the two find common ground over the course of the United Kingdom operation? Or will they only drift further apart...?	01KH3FXN45ZW32CTBK3Y51DBD7	5.0	2023-07-12T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 5 Death, Be Not Proud	2023-07-19T07:00:00.000Z
PRD_0YBM0VN9F9M0	CNT_2E7S2HMKC4G0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 2 Run Through the Battlefront (Start)	[]	86--EIGHTY-SIX, Vol. 2 Run Through the Battlefront (Start)	Let's go back to where we belong Having bid Lena farewell, Shin and the surviving members of the Spearhead squadron continue into the heart of Legion territory. There, they endure countless hardships until they're rescued by the Federal Republic of Giad, a reformed nation that offers them a second chance at a peaceful life. But it isn't long before a sense of duty calls the Eighty-Six back to the battlefield. Choosing to enlist in the military, they willingly walk back through the gates of hell, this time joined by a peculiar new ally-Frederica Rosenfort: a haughty young girl with a rare ability and wisdom far beyond her years.	01KGB2FZXHTHZH1X3P6KS4EP4Q	2.0	2022-11-17T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 2 Run Through the Battlefront (Start)	2022-11-18T08:00:00.000Z
PRD_0YXW5MHRMWP0	CNT_0MPRXEAJ38R0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 3 Run Through the Battlefront (Finish)	[]	86--EIGHTY-SIX, Vol. 3 Run Through the Battlefront (Finish)	Pride is all we have The attack Shin foresaw has finally come to pass. Wielding a weapon with destructive force hitherto unseen, the Long-Range Artillery-type Legion unit rains unmitigated chaos over the battlefield. Both the Federacy's western front and the Gran Mur of the Republic crumble under the might of the monolithic railgun, capable of dealing catastrophic damage from hundreds of kilometers away. With their backs against the wall, the Giadian military makes a controversial decision: A special strike force will charge into the heart of Legion territory, engage the Railgun type from close range, and destroy it. Shin and the Eighty-Six will spearhead the operation. ...But Shin has not been himself lately. Having defeated his brother's ghost and freed himself from the Republic, the Reaper finds himself without purpose. What reason does he have to go on living? For whose sake does he fight...?	01KGB466J2X1BFMDHDE2Z5NMFA	3.0	2022-12-27T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 3 Run Through the Battlefront (Finish)	2023-01-12T08:00:00.000Z
PRD_1D1C876FYYBG	CNT_3T289B8SZQBG	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 11 Dies Passionis	[]	86--EIGHTY-SIX, Vol. 11 Dies Passionis	PRIDE BEFORE THE FALLIt happened all too quickly. A flash, a rumble, and then... silence. In an instant, an unprecedented Legion assault wrought untold destruction upon nations across the world. As humanity's borders are sent into swift decline, Shin and Lena are tasked with a large-scale rescue operation that brings them back to Republic soil after what seems like a lifetime. Yet even with humanity on the brink of extinction, they find a country that hasn't changed-one that cannot change. Many survivors view rescue by the Eighty-Six as the height of indignity. Similarly, many Eighty-Six are reluctant to lend aid to those who stripped away their humanity. But behind the cavernous, silver eyes of the mechanical ghosts lays a single, gruesome directive...	01KGC1X4ZSCNRNNQXR0298FBZ9	11.0	2025-11-26T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 11 Dies Passionis	2025-11-28T08:00:00.000Z
PRD_1EGXYM45JZ4G	CNT_1TQV9SJHGRAG	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 13 Dear Hunter	[]	86--EIGHTY-SIX, Vol. 13 Dear Hunter	The frontlines are exhausted. Rocked by the relentless onslaught of Legion, the Eighty-Six face additional hardship with the constant influx of refugees. Rumors have begun to spread. There is a weapon hidden in Republic territory. One that could destroy the Legion. The people of the Republic are colluding with the Legion, someone whispers. The Eighty-Six are conspiring with them, says another! The people whisper and whisper. When hardship comes, accountability is always cast by the wayside...	01KGC1X60QWB834A8106W2H05H	13.0	2025-11-26T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 13 Dear Hunter	2025-11-28T08:00:00.000Z
PRD_1ZEZB1Z6E6F0	CNT_18GV2X9YQPDG	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 8 Gun Smoke on the Water	[]	86--EIGHTY-SIX, Vol. 8 Gun Smoke on the Water	A PATH TO PURPOSE LAID WITH IRON RAILS.An end to the endless war-the possibility of stopping the Legion once and for all. Such is humanity's most fervent desire. But in the war-free world of tomorrow, what will become of the Eighty-Six? Many have gained renewed faith in the future. Some have found love; others, new aspirations. But what of those who have yet to dream? The warm rays of hope have bent their iron wills and distorted their realities. For those tragic few, the worst is yet to come...	01KGAZTCM1NS7EJBA5ACRGNNG9	8.0	2024-03-04T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 8 Gun Smoke on the Water	2024-03-12T07:00:00.000Z
PRD_296QW1EHA8M0	CNT_194DEAJFGJQ0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 6 Darkest Before the Dawn	[]	86--EIGHTY-SIX, Vol. 6 Darkest Before the Dawn	WE ARE NOT THE SAME.Live to fight. Die with honor. That was all the Eighty-Six knew, and they were proud. However, seeing themselves reflected in the Sirins-slaughtered by the thousands, with nothing to show for it-a crack has formed in their ironclad resolve. Shin's mind festers with doubt. At the same time, Lena's heart tears at the seams as she struggles to understand him. Will the two find common ground over the course of the United Kingdom operation? Or will they only drift further apart...?	01KH3HMR3594HXY0RPA5TJD2YS	6.0	2023-09-05T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 6 Darkest Before the Dawn	2023-09-12T07:00:00.000Z
PRD_3CJ3RNV79RGG	CNT_2ZRH9NJDRAM0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 1	[]	86--EIGHTY-SIX, Vol. 1	A War Without CasualtiesThe Republic of San Magnolia has long been under attack from the neighboring Giadian Empire's army of unmanned drones known as the Legion. After years of painstaking research, the Republic finally developed autonomous drones of their own, turning the one-sided struggle into a war without casualties-or at least, that's what the government claims.In truth, there is no such thing as a bloodless war. Beyond the fortified walls protecting the eighty-five Republic territories lies the "nonexistent" Eighty-Sixth Sector. The young men and women of this forsaken land are branded the Eighty-Six and, stripped of their humanity, pilot the "unmanned" weapons into battle...	01KGAH2VBEHYDB3565XN88PDKC	1.0	2022-06-24T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 1	2022-07-12T07:00:00.000Z
PRD_3CR5QYQAGZM0	CNT_2TCHS2DNS7T0	86--EIGHTY-SIX CNT_1K7B6X2HEMTG	CNT_1K7B6X2HEMTG	2	4	2	Volume 10 Fragmental Neoteny	[]	86--EIGHTY-SIX, Vol. 10 Fragmental Neoteny	ANSWERSWhat makes a Reaper? What hardships must an innocent child endure to become the vaunted champion of the Eighty-Six? A peek into the past will shed light on his truth. The path he walks is paved with bonds forged in love and broken by tragedy-the shattered fragments of stories untold, committed to memory through the iron will of the one who would shoulder their legacy.	01KGC1X5HFV08VDDBT8RP805W7	10.0	2025-11-26T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 10 Fragmental Neoteny	2025-11-28T08: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);