database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_1TFDGH1QVXNG"

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_03HQXNAXHAB0	CNT_1GRN6MGS3C1G	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 2	[]	Our Last Crusade or the Rise of a New World, Vol. 2	Fate has guided Iska and Alice together once more as they cross paths at an Imperial painter’s art exhibit. There, they agree to meet again—only this time, to settle the score! But when an ancient power awakens to threaten their very lives, Alice is forced to choose between her country and her ideals! Up against an all-powerful foe, will the two heroes form an unlikely alliance—or find themselves unable to overcome their allegiances?	01KG9BKNMVX4QS5E3HCW5PKHCV	2.0	2020-03-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 2	2020-05-05T07:00:00.000Z
PRD_091TJX9YPERG	CNT_01T3MCFF2SWG	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 5	[]	Our Last Crusade or the Rise of a New World, Vol. 5	For years, Alice has worked hard to succeed her mother as queen of the Nebulis Sovereignty, but when her sister Elletear gets wind of her relationship with Iska, her birthright is thrown into jeopardy! Meanwhile, her other sister Sisbell is acting strangely, and unbeknownst to Alice, she’s planning to track Iska down herself…	01KGB3XKBA94Q9C9A4HWQ73J15	5.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 5	2023-03-21T00:00:00.000Z
PRD_0QAYD6D6S6CG	CNT_0Z06RM9BWS8G	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 7	[]	Our Last Crusade or the Rise of a New World, Vol. 7	Determined to protect Sisbell, Iska faces off against a mysterious witch who can manipulate gravity. Yet for all the duel’s intensity, it’s the conflict brewing among the Nebulis sisters that he needs to worry about…Tensions were already high between Alice and Sisbell, but when Elletear, the oldest of the three, gets involved, this sibling rivalry starts to really heat up! Somehow, Iska finds himself at the heart of a dispute which promises to be more fierce than any war he’s ever served in...	01KGB6F2PVAWD00JCDJTGCVQJX	7.0	2023-05-08T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 7	2023-10-24T00:00:00.000Z
PRD_28RJSMYS8E90	CNT_3E5D4BMAWA30	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 6	[]	Our Last Crusade or the Rise of a New World, Vol. 6	Iska defeats the robot adversaries gunning for Sisbell’s life, only to find an indignant Alice waiting for him. Suspicious of each other’s motives, the two sisters quarrel over Iska, and he flees amid the commotion. But Sisbell’s business with him is not yet finished, and soon, he’ll find himself getting more and more involved with her while Alice’s jealousy continues to grow…	01KGB3XKYST2H3TN93PVK0PKJQ	6.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 6	2023-06-20T00:00:00.000Z
PRD_36AQCGNAGG90	CNT_29699ZH2J23G	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 1	[]	Our Last Crusade or the Rise of a New World, Vol. 1	The Nebulis Sovereignty and the Empire are embroiled in a war without end. The Ice Calamity Witch, a Nebulis mage of incredible power, and Iska, the youngest swordsman of the Empire ever to become a Saint Disciple, find themselves face-to-face on the battlefield. Each seeks to bring a close to this ceaseless conflict. Little do they know, however, that their meeting will be the catalyst that shapes the fate of the world!	01KGA640GG1J8AV5Z78VD4JSA0	1.0	2019-09-30T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 1	2019-11-05T00:00:00.000Z
PRD_370CXB1Z5SKG	CNT_297M8T0JN49G	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 4	[]	Our Last Crusade or the Rise of a New World, Vol. 4	Thanks to Rin’s interference, Iska has been taken captive in the Nebulis Sovereignty under Alice’s guard. But the two fated rivals have little time to sort out their feelings, as they learn that the infamous sorcerer Salinger has escaped imprisonment…and Alice must do everything she can to stop him from gaining what he seeks. Against an opponent with the fearsome ability to steal astral powers, will mage and Imperial soldier join hands once again?	01KGB2NHT2KDYCQ6YMQJRP2XEK	4.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Our Last Crusade or the Rise of a New World, Vol. 4	2022-12-13T00:00:00.000Z
PRD_3CT89CG2CVFG	CNT_3ASWY1BJ90M0	Our Last Crusade or the Rise of a New World CNT_1TFDGH1QVXNG	CNT_1TFDGH1QVXNG	2	1	1	Volume 3	[]	Our Last Crusade or the Rise of a New World, Vol. 3	A vortex—a fount of light that has the power to turn those it chooses into astral mages—has appeared, and both the Empire and the Nebulis Sovereignty are hot on its tail, each determined to stop the other from getting their hands on it. But great care must be exercised, especially by the Imperials, as those who dare venture too close just might find the mark of a witch freshly emblazoned on their skin…	01KG9D24AY3W6YZ2VPZV157CS2	3.0	2020-09-22T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Our Last Crusade or the Rise of a New World, Vol. 3	2020-10-27T07: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);