database: products: 15 rows where series_id = "CNT

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

15 rows where series_id = "CNT_11DCNZD1AWQ0"

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_0234WGJQY4MG	CNT_0WXPNB7XTZS0	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 1	[]	Our Last Crusade or the Rise of a New World, Vol. 1	Love is a battlefieldFor years, a great war has raged on between the scientifically advanced Empire and a paradise of witches known as the Nebulis Sovereignty. This age-old battle sets the scene for a fateful encounter between two young combatants: an imperial swordsman, Iska, and the witch princess, Aliceliese. As sworn enemies, they vow to cut each other down in order to unite their worlds, and yet Iska finds himself entranced by her beauty and righteousness, while Aliceliese is moved by his strength and resolve. In the midst of a never-ending war that forbids them from being together, they have no choice but to destroy each other—or can they find another way?	01KGA60GDH46F0KXYF28E46DAC	1.0	2019-09-24T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 1	2019-09-24T07:00:00.000Z
PRD_07KW3X0S5FC0	CNT_1HEK7SK6PKWG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 7	[]	Our Last Crusade or the Rise of a New World, Vol. 7	BURNING BRIDGES The Nebulis Sovereignty is in flames. For the first time since its founding, the Paradise of Witches is raided by Imperial forces. It’s Imperial solider versus Sovereign witch. Saint Disciples against Purebreds. Unit 907 toe-to-toe with the House of Hydra. While war indiscriminately obliterates all, Iska squares off against Alice. Finding each other on the battlefield, the two discover their circumstances have changed for the worse. As paradise falls, they face a choice that might alter the course of their relationship forever…	01KG9H236G2VSZRPDGCG5S1HD6	7.0	2021-09-16T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 7	2021-10-12T07:00:00.000Z
PRD_09R9Q4SPKTJ0	CNT_265QWBWYQMCG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 6	[]	Our Last Crusade or the Rise of a New World, Vol. 6	SISTERS AT WAR With Iska’s unit at her side, Sisbell races against the clock, desperate to return to the palace and uncover who was behind the violent coup. However, when Elletear catches wind that Sisbell’s new guards are enemy soldiers, she hatches a little plan to thwart her sister’s earnest attempt to save their troubled country. In fact, Elletear’s best bet is caging Sisbell and her new guards in the family villa to keep them out of the way of her schemes. Meanwhile, petrified that Elletear might hurt their youngest sister, Alice scrambles to the scene…forcing all three siblings to come together under one roof for the first time in a long while.	01KG9F19AHYR0RR46TYXKQ24X0	6.0	2021-03-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 6	2021-04-20T07:00:00.000Z
PRD_0ENN567H0N70	CNT_2V3P2B3NY150	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 10	[]	Our Last Crusade or the Rise of a New World, Vol. 10	Just as Iska and Unit 907 finally rescue Princess Sisbell, the Lord Yunmelngen abducts Rin and orders them back to the Imperial capital. Despite the obvious danger, Iska and company hurry to the heart of the Empire to both free their comrade and discover what transpired there a century ago during the creation of witches. But neither of these tasks will be easy, for the Eight Great Apostles are determined to end Iska’s pursuit of the truth. Meanwhile, disaster brews in the Nebulis Sovereignty!	01KGB2C5AW68DC5063A605CHB6	10.0	2022-11-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 10	2022-11-22T00:00:00.000Z
PRD_16EN2VMBGEQ0	CNT_0CRQG2P1CFNG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 2	[]	Our Last Crusade or the Rise of a New World, Vol. 2	May luck shine in your favorThe stars once aligned to grant a series of meetings between two fighters from enemy nations, but those ephemeral days have come to a close. Iska and Aliceliese must now take it into their own hands to scour the land in hopes of a rematch. Call it coincidence or predestination, but the pair manage to slip past each other at every turn, unaware they’ve been dispatched to the same battlefield. In their fight over a vortex of astral energy, they might just find that what brews and burbles in its abyss is more than magic…	01KG9BHJ0Q9FH431KV31JW22QR	2.0	2019-12-12T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 2	2019-12-31T08:00:00.000Z
PRD_1830PY9MNMX0	CNT_1ET496TN36D0	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 14	[]	Our Last Crusade or the Rise of a New World, Vol. 14	war has no winnersThe battle between the head of the Hydra family, Talisman, and the witch Elletear results in the worst possible outcome. Princess Mizerhyby, seeking power and revenge, has decided to march on the Empire alongside Shanorotte, aiming to reduce it to cinders. Facing them are Aliceliese, Kissing, and Mismis. The all-out battle royale between Astral Mages is about to commence. What conclusions will be drawn at the end of this fateful clash, and who will remain standing once the dust settles…?	01KGBDZXKVZT5NPEJS22AZ0XND	14.0	2024-09-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 14	2025-05-20T07:00:00.000Z
PRD_187AQSH6A5C0	CNT_2ZD8FSYS4R9G	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 9	[]	Our Last Crusade or the Rise of a New World, Vol. 9	<P>In their scheme to overthrow the government, Hydra abducts Third Princess Sisbell and spirits her away to the Empire. To rescue her, Rin takes it upon herself to tail Iska and company from the shadows and stage an infiltration! Little does she know that chaos brews in the land of witches… </P>	01KGAGRHV87RYJ4V1RASKSA74W	9.0	2022-06-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 9	2022-06-28T00:00:00.000Z
PRD_1Y4XQJ95M9J0	CNT_1Y0QVS1GGS40	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 13	[]	Our Last Crusade or the Rise of a New World, Vol. 13	In the aftermath of Elletear’s attack, nothing is certain about the war between the Empire and the Sovereignty. Kissing surrenders to Iska to avenge her uncle, and the two join up with Alice and the others to travel to a forbidden land in search of answers. There, they learn the truth of the astral swords, the calamity at the center of the planet, and the terrible future that awaits…	01KGAY0611V7MZHJG8Q0ANVA3Z	13.0	2024-01-25T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 13	2024-07-23T00:00:00.000Z
PRD_2CMAHD5K42QG	CNT_15JF5ZNJJGSG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 15	[]	Our Last Crusade or the Rise of a New World, Vol. 15	A CRUSADE UNFULFILLEDThe invasion of Omen has been thwarted, and three of the Sovereignty’s princesses have joined forces with the Empire. But as everyone decides how to deal with Elletear and the calamity, Queen Mirabella hesitates to lend aid. To face the truth, she asks Sisbell to use Illumination to re-create the events from thirty years ago. They see a young Mirabella who cared only for battle, shirking her royal duties and connections with others to indulge in her obsession with combat. That all changed, however, when she met Salinger, the infamous transcendental sorcerer and the only person capable of challenging her. This is the tale of what blossomed between two unlikely rivals, pushing each other to be better—until tragedy ripped it all away.	01KGBQ8PY24AFDS3FV6YHGR041	15.0	2025-05-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 15	2025-11-25T08:00:00.000Z
PRD_2HG3D9X9PTY0	CNT_2DS09NWYXF6G	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 4	[]	Our Last Crusade or the Rise of a New World, Vol. 4	A SECRET NEVER TO BE TOLD...To rest and recuperate from their set of life-threatening missions, Unit 907 is finally granted a much-needed break. And what better place to spend time off than at a distant resort where they can lounge in their bathing suits 24-7? Against all odds, the trip is going according to plan…until Iska bumps into a certain witch who instantly reminds him of Alice. In fact, it feels all too familiar when she demands he come to Nebulis—for reasons she simply cannot reveal. And she isn’t the only one with a hidden motive: Alice has arrived to investigate why her sister has been spying on Iska…for months.	01KG9D21ZX84T1DVH5M1C6827Z	4.0	2020-08-21T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 4	2020-09-29T07:00:00.000Z
PRD_2QA3MG4MJ6N0	CNT_358Z5T17Z5PG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 12	[]	Our Last Crusade or the Rise of a New World, Vol. 12	THE AWAKENING OF A TRUE WITCH Alice pursues the Grand Witch Nebulis to the Empire to stop her rampage, but instead, she comes across her transformed older sister, Elletear. No longer human, Elletear has gained immense power from merging with the calamity at the planet’s core, and she’s set on destroying the Empire and the Sovereignty to achieve her dream of building a true paradise for witches. To prevent their nations from being reduced to ashes, Lord Yunmelngen, Iska, and Alice form a united front against Elletear and her knight, the traitorous Saint Disciple Joheim.	01KH3FVGCQDXRFDEZ8921V493Y	12.0	2023-05-31T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 12	2023-11-21T00:00:00.000Z
PRD_2Y9MYRZ1HXY0	CNT_1XJX9Z66X250	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 8	[]	Our Last Crusade or the Rise of a New World, Vol. 8	THE TRUTH LIES BENEATH THE SURFACE<BR /><BR />As the night of the witch hunt ends, the Nebulis Sovereignty finds it’s sustained nearly insurmountable damage. Its citizens are pointing fingers at the royal family, demanding they take responsibility for the chaos and accelerate the conclave to select a new queen. Meanwhile, Alice entrusts Iska with the task of rescuing Sisbell, the only one capable of revealing who is responsible for the Imperial raid. Iska’s next destination? The research facility run by the<BR />House of Hydra! Just who is the blue-haired princess who awaits them there?	01KGADBJW3CSWTA1ZHA6KWYP46	8.0	2022-01-18T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 8	2022-03-15T00:00:00.000Z
PRD_3KV3ESJTDY9G	CNT_1N96F5X07A3G	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 11	[]	Our Last Crusade or the Rise of a New World, Vol. 11	Iska and Unit 907 have defeated one of the Eight Great Apostles, Luclezeus, and arrived at the Imperial capital. There, they meet Lord Yunmelngen, who asks Sisbell to use her astral power to help uncover the truth behind the tragedy that transpired a hundred years ago. They travel deep underneath the Empire to learn, at long last, the mystery behind the birth of the Founder Nebulis, of Lord Yunmelngen, and of the Black Steel Gladiator, Crossweil. However, what awaits them is a heart wrenching tale…	01KGB3Y4XQ2Z7RZ8M5ZNE7FDPA	11.0	2022-12-07T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 11	2023-03-21T00:00:00.000Z
PRD_3PM53ZP8Y330	CNT_20JX8WS2VMSG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 3	[]	Our Last Crusade or the Rise of a New World, Vol. 3	Break free…if you canGetting assigned to a special mission to infiltrate the Sovereignty was already more than Iska could handle, but with Captain Mismis becoming a witch, his list of problems just keeps getting longer. To make matters even worse, Iska finds himself dragged to the Sovereignty’s prison block after an accident nobody bargained for. There, he’s chained to Alice, giving him no chance of escape—and intimate insight into her true nature. But reality comes crashing down on them hard when the “transcendental” sorcerer manages to break out of his cell…	01KGA8WD7V96KYHEE960BC5KS3	3.0	2020-03-12T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 3	2020-04-28T07:00:00.000Z
PRD_3XDX4T4QZE8G	CNT_1JGTPYG1X2RG	Our Last Crusade or the Rise of a New World CNT_11DCNZD1AWQ0	CNT_11DCNZD1AWQ0	2	2	1	Volume 5	[]	Our Last Crusade or the Rise of a New World, Vol. 5	UNDER THE SAME STARSTwo sisters with two clashing impressions of the same boy: Sisbell would do anything to get Iska to be her ally, while Aliceliese sees him as a worthy opponent, regardless of their duties or convictions. As part of a deal with Sisbell, Iska is required to serve as her guard until she returns to the palace. None the wiser about this pact, Alice desperately races around the nation to locate her younger sister before the other families can target her again. When Alice spies Sisbell and Iska linking arms in the Sovereignty, her chest starts to ache for reasons unknown…	01KG9DJ8AQGM022QSSS26MQP2D	5.0	2020-11-26T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 5	2020-12-29T08: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);