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

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_0GK2EXMEQBJG	CNT_360E3KBZSW90	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 3	[]	86--EIGHTY-SIX, Vol. 3	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…?	01KGA7MH58XJ8QAVRW387T2P4F	3.0	2019-09-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 3	2019-11-19T00:00:00.000Z
PRD_0TADADR0KSBG	CNT_3TS9C9SFZDXG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 7	[]	86--EIGHTY-SIX, Vol. 7	FOREVER…IF POSSIBLE The 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…	01KG9ET7K4AAYE3QP0E26MYB9T	7.0	2021-01-27T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 7	2021-03-30T00:00:00.000Z
PRD_1C0674A32DFG	CNT_14V7HGTEHSDG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 11	[]	86--EIGHTY-SIX, Vol. 11	PRIDE BEFORE THE FALL It 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...	01KGB2CHKJ3T8TM0YRQRQM337M	11.0	2022-11-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 11	2022-11-22T00:00:00.000Z
PRD_1HZPTJ6AGDCG	CNT_0VHDPEAFCDE0	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 12	[]	86--EIGHTY-SIX, Vol. 12	THE PRICE OF PEACE The 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…	01KH3FVCKCNSZMEV2DXX0NGWVS	12.0	2023-05-31T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 12	2023-11-21T00:00:00.000Z
PRD_1Y30KQPNDZD0	CNT_1Y89F51BEMQG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 6	[]	86--EIGHTY-SIX, Vol. 6	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…?	01KG9DCV3DHGQQRP3EPSZC57PV	6.0	2020-10-28T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 6	2020-11-17T00:00:00.000Z
PRD_2CXY0Q7HV36G	CNT_1YRJD1AWZZF0	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 1	[]	86--EIGHTY-SIX, Vol. 1	A War Without Casualties The 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...	01KG9B2GVYEWY011RV7V5K8QA2	1.0	2019-03-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 1	2019-03-26T00:00:00.000Z
PRD_2VV5K5XZNYZ0	CNT_3T80EDHYE340	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 9	[]	86--EIGHTY-SIX, Vol. 9	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…	01KGADBJCMY77W8V077GEFCPM0	9.0	2022-01-18T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 9	2022-02-22T00:00:00.000Z
PRD_33ATC5EFRBK0	CNT_3JGJ195DP6KG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 2	[]	86--EIGHTY-SIX, Vol. 2	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.	01KGA73QHBYZZ2JTR9CD3WEZAT	2.0	2019-07-23T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 2	2019-07-23T00:00:00.000Z
PRD_35RWEXF5E3FG	CNT_2Z1FDW94K6D0	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 10	[]	86--EIGHTY-SIX, Vol. 10	ANSWERS What 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.	01KGAGGX43MCH0HEB88ZJSHEGV	10.0	2022-04-25T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 10	2022-05-17T00:00:00.000Z
PRD_39BJNARERFTG	CNT_2CFDJ81YC0H0	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 4	[]	86--EIGHTY-SIX, Vol. 4	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 promise and finally caught up to the Spearhead squadron. And while her citizens from the Legion’s dark agenda. Lena, in turn, has fulfilled her presence has brought out a softer side in Shin, it seems to have roused to an end when the Eighty-Sixth Strike Package, with Lena at the helm, the competitive spirits within Kurena and Frederica. But the fun comes in the Republic’s northern secondary capital, Charité. Deep underground, receives its first mission. Their destination: an abandoned subway tunnel the gaping maw of a subterranean Legion base awaits them...	01KGA7WVMMZBN64FFFY2Z0BWD0	4.0	2020-02-26T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 4	2020-03-31T00:00:00.000Z
PRD_3DJTZ0Y8SGV0	CNT_3KQTX8K1YTBG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 8	[]	86--EIGHTY-SIX, Vol. 8	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…	01KG9G4KVF7WNXPEV36J6FWMT3	8.0	2021-06-15T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 8	2021-08-24T00:00:00.000Z
PRD_3H7BWY3390R0	CNT_1EKA9CEGH3W0	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 13	[]	86--EIGHTY-SIX, Vol. 13	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...	01KGBBVVV34GA33R5ZNP1E550X	13.0	2024-07-12T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	86--EIGHTY-SIX, Vol. 13	2024-12-10T08:00:00.000Z
PRD_3YVRXJGZ6KV0	CNT_2YS15AD8ZQSG	86--EIGHTY-SIX CNT_0EZG2ERB1K4G	CNT_0EZG2ERB1K4G	2	2	1	Volume 5	[]	86--EIGHTY-SIX, Vol. 5	WHAT MAKES A MONSTER? “Come find me.” Legion developer Zelene Birkenbaum, a figure shrouded in mystery, has left the Eighty-Sixth Strike Package a trail of bread crumbs leading all the way to the frozen north. But as Shin and the Eighty-Six acquaint themselves with the United Kingdom of Roa Gracia, they learn of an anti- Legion strategy that chills them worse than the cold. Here on this new battlefield, surrounded by mechanical ghosts that exist only to fulfill their duty, the Eighty-Six are forced to acknowledge an unsettling truth...	01KG9CWSGTMFM7CXQVBQPBGM3M	5.0	2020-08-18T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	86--EIGHTY-SIX, Vol. 5	2020-08-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);