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

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_0BQ9S64K91KG	CNT_1QRQSM9AG8H0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 1	[]	The Saga of Tanya the Evil, Vol. 1	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!	01KGA1G970YNKHBSWRMG18HR2S	1.0	2017-12-03T15:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 1	2017-12-19T08:00:00.000Z
PRD_0BRF4R00HAFG	CNT_2S7WNNKXPPP0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 5	[]	The Saga of Tanya the Evil, Vol. 5	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.	01KGA6K7JJE0DSS9JKFPDNJY08	5.0	2019-03-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 5	2019-03-26T07:00:00.000Z
PRD_0T8STZBB9E50	CNT_1KEFRD7PMKD0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 4	[]	The Saga of Tanya the Evil, Vol. 4	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!	01KG9ARR87AXWES0Z0FYQYWF5W	4.0	2018-11-27T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 4	2018-11-27T08:00:00.000Z
PRD_0TKEKW07TFJG	CNT_0KN0F0PEJ1A0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 10	[]	The Saga of Tanya the Evil, Vol. 10	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...	01KGAGGGSD77DY86HXRBMT2PQ8	10.0	2022-04-25T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1G5EK0KH20W0	The Saga of Tanya the Evil, Vol. 10	2022-05-24T00:00:00.000Z
PRD_18R2BQ8QMNG0	CNT_09W47HHVEHY0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	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.	01KGB4ETT6GFACZS1JZNE4TB7J	12.0	2023-02-07T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1G5EK0KH20W0	The Saga of Tanya the Evil, Vol. 12	2023-09-19T00:00:00.000Z
PRD_1Q2W535KV68G	CNT_2GMHEP6ASJFG	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 2	[]	The Saga of Tanya the Evil, Vol. 2	"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!	01KGA3A3YHXP9K85TAPYBP92EK	2.0	2018-03-27T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 2	2018-03-27T07:00:00.000Z
PRD_1VMHCCY4KJY0	CNT_3BZZN17TA740	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 3	[]	The Saga of Tanya the Evil, Vol. 3	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...?	01KGA4YNAYYV6ZTGR6EXX9RQN3	3.0	2018-07-31T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 3	2018-07-31T07:00:00.000Z
PRD_22G3K661D850	CNT_38G9E66M5A7G	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 7	[]	The Saga of Tanya the Evil, Vol. 7	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...	01KGA7YNBYM5GG4XP9HJM2ZSDZ	7.0	2020-04-22T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 7	2020-06-23T07:00:00.000Z
PRD_2SJE28K88YRG	CNT_39QCFG27562G	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	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?	01KGBJZHFB08F93ZPXA4KSNCZ1	14.0	2024-12-18T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 14	2025-10-21T07:00:00.000Z
PRD_2Y2Q2WYTPR2G	CNT_1X8RAQQDVCPG	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 8	[]	The Saga of Tanya the Evil, Vol. 8	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...	01KG9DJPE0PKAEM73NMJ294219	8.0	2020-11-26T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 8	2020-12-22T08:00:00.000Z
PRD_305RPMCJ9PMG	CNT_0PFGK6D18TZG	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 9	[]	The Saga of Tanya the Evil, Vol. 9	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...	01KGAD7RFVCV5WR0M5JXPK63K4	9.0	2021-12-09T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 9	2022-01-18T08:00:00.000Z
PRD_3JJ9F6NDCF80	CNT_1HWH76R3QBPG	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 6	[]	The Saga of Tanya the Evil, Vol. 6	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.	01KGA73XY958SGMAM6P9C2MQAN	6.0	2019-07-30T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 6	2019-07-30T07:00:00.000Z
PRD_3RAAS5ZFHEY0	CNT_117M89S1B1Y0	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 13	[]	The Saga of Tanya the Evil, Vol. 13	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...	01KGBBVSFAP5CG9Z6PS04G0XB3	13.0	2024-07-12T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Saga of Tanya the Evil, Vol. 13	2024-12-17T08:00:00.000Z
PRD_3XXD055JXTDG	CNT_1PKA9YM1V6FG	The Saga of Tanya the Evil CNT_2ATJ2CC1R4QG	CNT_2ATJ2CC1R4QG	2	2	1	Volume 11	[]	The Saga of Tanya the Evil, Vol. 11	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...	01KGB2PDT4N96FAAT467TT40AM	11.0	2022-12-07T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1G5EK0KH20W0	The Saga of Tanya the Evil, Vol. 11	2022-12-20T00: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);