database: products: 14 rows where series_id = "CNT

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

14 rows where series_id = "CNT_3N2P8SM9DP4G"

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_00117GAF8SY0	CNT_2YBFTGF87200	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 14	[]	The Saga of Tanya the Evil, Vol. 14	None of the soldiers on the front can remember the last time they had a decent chance to eat, drink, or sleep—and yet the battle rages on. Hoping for a victory that will do little more than delay defeat, Tanya and her mages rush to the battlefield. They howl and struggle, a faint glimmer in the dark of twilight as Zettour finally lives up to his name as an enemy of the world. Will his master plan truly be enough to save the Empire?	01KGC1X0GS1DPNKE19J1NBGE5Y	14.0	2025-11-25T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 14	2025-11-28T08:00:00.000Z
PRD_04QHH37HMRX0	CNT_0HNWT25GJ110	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 13 Dum Spiro, Spero: Part 1	[]	The Saga of Tanya the Evil, Vol. 13 Dum Spiro, Spero: Part 1	The Federation's Offensive—Rising Dawn. The Federation has been steadily preparing itself for the decisive battle. As the moment of truth rapidly approaches, the Empire which has long been on the offensive remains unaware of the threat. In these dire circumstances, only one person has noticed where everything is heading: Tanya. Zettour also refuses to simply watch and begins his grand plan to deceive the world. In the end, the one who will pull the trigger on this operation is a monster in the guise of a young girl...	01KGC1WYNVX8KT1BGZ4J7NANYQ	13.0	2025-11-25T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 13 Dum Spiro, Spero: Part 1	2025-11-28T08:00:00.000Z
PRD_04WPNAAQ7QSG	CNT_3ZZNSQH78SK0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 3 The Finest Hour	[]	The Saga of Tanya the Evil, Vol. 3 The Finest Hour	Contrary to her dearest wish to find a safe place and stay there, Major Tanya von Degurechaff continues to wade through the fog of war with her troops on land, at sea, and in the air. After many battles with the increasingly numerous enemies of the Empire, a chance for a breakthrough finally appears.But when her comrades begin celebrating the glories they've reaped, savoring the sweet nectar of imminent triumph, Tanya alone is frozen in fear. Has the Empire decisively won the war, or is this nothing more than a Pyrrhic victory...?	01KGAH6TBZ5AHRVK1Y0JB2YK4G	3.0	2022-05-11T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 3 The Finest Hour	2022-05-11T07:00:00.000Z
PRD_1HHMMFG7WT10	CNT_07JJTWC77NS0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 10 Viribus Unitis	[]	The Saga of Tanya the Evil, Vol. 10 Viribus Unitis	Time is not on the Empire's side. It has become painfully clear that simply winning battles will not be enough to turn the tide of this war. Having no interest in sharing the fate of her country, Tanya immediately decides to do the only thing that makes sense—look for a new job! Of course, she'll have to proceed with extreme caution, because her current employer isn't some random company but the Imperial Army. As it happens, she isn't the only one ready to do something drastic when push comes to shove...	01KH3QKRP49SK1CRG00DA1XY1Y	10.0	2024-04-05T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 10 Viribus Unitis	2024-05-14T07:00:00.000Z
PRD_1J0YBW3BABRG	CNT_0NT4XRKWQ8D0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 5 Abyssus Abyssum Invocat	[]	The Saga of Tanya the Evil, Vol. 5 Abyssus Abyssum Invocat	Winter is roughly two months out. The time limit has been set.But the Empire's military leaders are fiercely divided on what to do. Should they conduct aggressive offensives in hopes of a break through, or should they weather the winter and use that as a chance to reorganize, restructuring the lines of battle? In the end, they decided that while they gather supplies for a theoretical offensive, they would conduct an investigation to collect intelligence. Naturally, Tanya's Salamander Unit was the first candidate for the mission. Should they push ahead, or should they hold their ground? There's no time to hesitate. As the hellish conditions worsen, the war shows no sign of slowing down or becoming any less brutal. Everyone has no choice but keep what they hold dear close to their hearts as they march ever onwards toward the battlefield. Everything for the sake of the motherland, for the fatherland.	01KGAJSGM5BTW4NYMKXTAAE3P5	5.0	2022-09-30T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 5 Abyssus Abyssum Invocat	2022-10-11T07:00:00.000Z
PRD_1R5J5XSVZH3G	CNT_3KY3V5MSPKS0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 2 Plus Ultra	[]	The Saga of Tanya the Evil, Vol. 2 Plus Ultra	Girl--this, this is war.After being reborn and becoming a magic wielding soldier in the Imperial Army, Tanya Degurechaff bemoans her fate of being placed at the very edge of the front lines instead of a comfy place in the rear. Swearing revenge on Being X, she plunges head-first into battle, dragging her subordinate along with her!	01KGAH6H5CWZ1E7T7DGZP4TEJR	2.0	2022-05-11T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 2 Plus Ultra	2022-05-11T07:00:00.000Z
PRD_23E176JPW3EG	CNT_3XKG7KNY9QEG	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 11 Alea Iacta Est	[]	The Saga of Tanya the Evil, Vol. 11 Alea Iacta Est	Anyone can tell that continuing the war is ludicrous. The question now is not whether to but how to end the war. Colonel Lergen has been working on brokering a truce in Ildoa for some time now, yet peace seems farther than ever. Bringing the war to a close in a way that everyone can stomach may be harder than surviving on the eastern front. In the meantime, people like General Rudersdorf and General Zettour are beginning to move in the shadows. If a resolution isn't reached soon, things are only going to get even more dangerous...	01KGBBMW3WM2CCG6P1W7T3KF7F	11.0	2024-06-25T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 11 Alea Iacta Est	2024-07-16T07:00:00.000Z
PRD_26E9RTNCPRDG	CNT_3Y06ASACDHHG	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 12	[]	The Saga of Tanya the Evil, Vol. 12	Tanya has won victory after victory on the battlefield, and still the Empire hurtles toward its destruction. Zettour stands at the helm, a warped sense of patriotism guiding his actions as he prepares the stage. His only goal now is to secure the best possible defeat the Empire can afford, even if it means going down in history as the greatest villain of all time. And to make that happen, he'll do whatever it takes to shock and awe the world, starting with Ildoa. The time for diplomacy or reason has passed. There is only war.	01KGC1WZ64N33F12TADF5A36MJ	12.0	2025-11-25T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 12	2025-11-28T08:00:00.000Z
PRD_28T9P2AQPKJG	CNT_0YSB3XVJ6NA0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 4 Dabit Deus His Quoque Finem	[]	The Saga of Tanya the Evil, Vol. 4 Dabit Deus His Quoque Finem	A devil wanders the battlefield in the guise of an adorable young child and her name is Tanya Degurechaff! After returning from the sandy southlands, Tanya receives an incredibly suspicious order from headquarters to embark on a training exercise. In reality, command has sent her on a covert mission to initiate a border conflict with the Federation. Soon the Empire finds itself embroiled in another fight it cannot back down from, even if it means making the entire world their enemies!	01KGAHMP024W7K5ZE4862QQKXF	4.0	2022-06-09T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 4 Dabit Deus His Quoque Finem	2022-07-05T07:00:00.000Z
PRD_29T9S7QY1N80	CNT_2YZS9A2KW8DG	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 1 Deus lo Vult	[]	The Saga of Tanya the Evil, Vol. 1 Deus lo Vult	High above the blood- and mud-soaked trenches, a young girl pits herself against army mages in high stakes aerial duels with bullets, spells, and bayonets. Her name is Tanya Degurechaff and she is the Devil of the Rhine, one of the greatest soldiers the Empire has ever seen! But inside her mind lives a ruthless, calculating ex-salaryman who enjoyed a peaceful life in Japan until he woke up in a war-torn world. Reborn as a destitute orphaned girl with nothing to her name but memories of a previous life, Tanya will do whatever it takes to survive, even if she can find it only behind the barrel of a gun!	01KGAGY1K4AZWMWHX8YBPQMSB5	1.0	2022-05-11T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 1 Deus lo Vult	2022-05-11T07:00:00.000Z
PRD_2YCKTZ2FP1N0	CNT_051KXASFDVP0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 8 In Omnia Paratus	[]	The Saga of Tanya the Evil, Vol. 8 In Omnia Paratus	When Zettour tries his best to caution against the reckless plan to strike at theFederation's vital resource fields, he soon finds himself "promoted" to a fielddeployment on the eastern front. Meanwhile, as the ill-advised Operation Andromedapresses on, commanding officer Tanya must fight another bitter battle despitedwindling supplies, poor communication, and exposed flanks. With retreat expresslyforbidden and time running out, the only way to survive is to win...	01KH3HMMB4DXKERDZZ4C7MA4G7	8.0	2023-08-21T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 8 In Omnia Paratus	2023-09-12T07:00:00.000Z
PRD_338PRJBQNTC0	CNT_0BWQK024C7J0	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 6 Nil Admirari	[]	The Saga of Tanya the Evil, Vol. 6 Nil Admirari	Survival is always a fight. Lieutenant Colonel Tanya von Degurechaff has become keenly aware of this after deploying to the freezing eastern front. The bone-chilling weather makes every move a struggle, grinding even the Empire's proud army to a halt. And yet, winter is the time for the flowers of intrigue to blossom. When a supposed ally begins acting suspiciously and enemies begin to collude, a profusion of conflicting interests and various secret deals will summon a maelstrom of confusion no one can control.	01KG9KKVRX07T1EA61W9PTWTNT	6.0	2023-01-19T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 6 Nil Admirari	2023-02-14T08:00:00.000Z
PRD_3QNS367QJGMG	CNT_10CMY7Z1M02G	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 9 Omnes una Manet Nox	[]	The Saga of Tanya the Evil, Vol. 9 Omnes una Manet Nox	The Salamander Kampfgruppe has finally come off the front lines and is headed back west for much-needed R & R. The troops are more than ready to enjoy some peace and quiet after many long days flying missions on the eastern front. What they aren't ready for is how unfamiliar it feels not to be surrounded by whizzing bullets and exploding artillery shells. For Tanya, though, this long-awaited return to the rear brings more disturbing realizations than respite. This vacation may be far more eventful than it has any right to be...	01KGAXNEWWXQ8AWGZY9NZWB2TG	9.0	2023-12-15T08:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 9 Omnes una Manet Nox	2024-01-16T08:00:00.000Z
PRD_3TG71TR31ZCG	CNT_2GNTXSX1728G	The Saga of Tanya the Evil CNT_3N2P8SM9DP4G	CNT_3N2P8SM9DP4G	2	4	2	Volume 7 Ut Sementem Feceris, ita Metes	[]	The Saga of Tanya the Evil, Vol. 7 Ut Sementem Feceris, ita Metes	The eastern front is a place where soldiers never sleep and artillery guns howl without rest. This quagmire is where the Salamander Kampfgruppe has been hurled once again, just another cog in the grand war machine of their fatherland. Still, there's only so much one unit can do. As the fighting ramps up with renewed enemy attacks and a brand-new weapon that pitches the Federation's quantity against the Empire's quality, Tanya faces one of her toughest battles yet, making a certain visitor's arrival a sight for sore eyes...	01KGB68R6NZCCA9DP4ZT4TGCJ5	7.0	2023-04-12T07:00:00.000Z	Yen Audio LAB_34QX5FTMWAZ0	GEO_1PQM5BDYSMG0	The Saga of Tanya the Evil, Vol. 7 Ut Sementem Feceris, ita Metes	2023-05-16T07: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);