database: products: 11 rows where series_id = "CNT

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

11 rows where series_id = "CNT_15HCTFJJKSS0"

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_02F4S2S32G40	CNT_2N5D8XDJGC30	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 2	[]	Jack Frost, Vol. 2	StartFragmentAll hell breaks loose when gangs representing schools from all over the city erupt into an all out war for supremacy. But in the heat of battle these powerful warriors from the south, east and west districts all have but one goal -- to be the brave soul who defeats Jack Frost and lay claim to the title of greatest fighter Amityville has ever seen. Jack, often affectionately referred to as "death incarnate," has a mission of his own; escorting No-Ah, a girl wielding immense power, to a location where a great evil was sealed man years ago. Seems simple enough, but all may not be what it seems in Amityville, the land of the dead. EndFragment	01KGA2F0HGBBBRPN6PM02GMS62	2.0	2018-01-10T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 2	2018-01-18T08:00:00.000Z
PRD_0ZYMEFZS6H50	CNT_0NTG8KQA5D20	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 4	[]	Jack Frost, Vol. 4	Siegfried of the South District makes his move against the North, and his weapon of choice is...Jin? But despite the fact that this latest threat to her power bears the countenance of her associate, Helmina does not hesitate to unleash her terrible strength against Jin. With Siegfried successfully removed from the good doctor's mind, Helmina plots her next strategy...Will even Jack Frost be able to counter the devils she is prepared to release?	01KGA2F2CFA4KE2T6F2C69D7CV	4.0	2018-01-10T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 4	2018-01-18T08:00:00.000Z
PRD_1GWAEZ375Z40	CNT_2ERCTBN5HB30	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 9	[]	Jack Frost, Vol. 9	Cornered among the slabs of the Ancient Rock, Helmina comes face-to-face with Dust, head of the West District. With Jack Frost kept busy elsewhere, fighting the West's vicious pack of warriors, Helmina is forced to test the strength of her powers against the mighty lycanthrope. Alliances will shift and new powers will rise in the battle for dominance and the mirror image!!		9.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 9	2018-01-25T08:00:00.000Z
PRD_1QJTSKX91YB0	CNT_0E2T5NBDWAC0	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 11	[]	Jack Frost, Vol. 11	Swept into Helmina's consciousness, Noh-A witnesses the young Helmina, heir to Devildom--her longing for freedom and the betrayal that gives rise to Solomon's reign of terror. Helmina's strength alone was not enough to defeat the mad king, but in Noh-A's hands, the power of the Witch of the North and the mirror image combine to transform the fearful girl into a fearsome opponent. With Jack Frost at her side, can Noh-A defeat the cruel King Solomon when he threatens to destroy Amityville for good?! The battle rages on in the final volume of Jack Frost!!		11.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 11	2018-01-25T08:00:00.000Z
PRD_1T3NB6YKDXA0	CNT_21CQ571PB9D0	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 6	[]	Jack Frost, Vol. 6	When Ethan of the East District reunites Noh-A with her long-dead father, only to threaten to kill him again if she does not cooperate with the East District, Noh-A reluctantly agrees to go with Ethan. But securing the mirror image for himself is only half the battle. Ethan soon finds himself under siege from the other districts of Amityville as they attempt to steal her away again. As battle rages around her, a gnawing doubt grows in the pit of Noh-A's stomach... Is Jack truly the ally she's believed him to be? Or was he responsible for the loss of everything and everyone she once held dear?		6.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 6	2018-01-25T08:00:00.000Z
PRD_20MCJB800GVG	CNT_3MT3R68PPVWG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 1	[]	Jack Frost, Vol. 1	Any high schooler on a nerve-wracking first day at a new school is apt to lose his or her head a little, but in Noh-A's case, she literally does! When she wakes up in one piece with a little help from a mysterious doctor, Noh-A quickly realizes that nothing is as it seems at Amityville High, where paranormal creatures battle for supremacy. Caught in the crossfire, Noh-A may have to rely on the unlikely (and possibly unreliable) aid of the most sinister student at Amityville...the deadly Jack Frost!	01KGA1HWTDHZ8P0Z1E614TNK5K	1.0	2018-01-10T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 1	2018-01-18T08:00:00.000Z
PRD_2SHDN5CVRJNG	CNT_3J5SSAW5WXJG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 5	[]	Jack Frost, Vol. 5	With his friends in danger, Hansen puts memories of the past behind him and squares off against his brother. Though long-dead, Der Freischütz is still a gunman to be reckoned with, but Hansen has a secret weapon in store that could turn the tables on the deadly sharpshooter. As Hansen delivers his final blow, Jack decides he's had enough of sitting on the sidelines and does what Jack Frost does best. But victory is short-lived as the head of the East District moves his final pawns into place! What does the mastermind behind this attack have in store?	01KGA2F2Z71QVYX7N0K8DGTD9F	5.0	2018-01-10T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 5	2018-01-18T08:00:00.000Z
PRD_2W7W0REY4HMG	CNT_1NFPRMJEBWKG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 3	[]	Jack Frost, Vol. 3	Noh-A watches in fear as Omu strikes down Maru, the last offspring of the Unicorn. With the last obstacle removed and Jack fighting elsewhere in the forest, Omu seizes the Antler of the Unicorn. In an effort to snatch Noh-A's immortality for himself, Omu plunges the Antler deep into her chest. But as the sharp horn pierces her heart, Noh-A is greeted not by death, but by life. Her real life - the life she had before she found herself in Amityville. Though she has longed to uncover the mystery of her forgotten past, nothing could have prepared Noh-A for what she sees...	01KGA2F1CT6DJPJY239874ZHQ6	3.0	2018-01-10T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 3	2018-01-18T08:00:00.000Z
PRD_3H5J79J43ZVG	CNT_3ED3ACG9QTWG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 8	[]	Jack Frost, Vol. 8	Jack the Ripper has completed his first task as a spy for the West District: discover the location of the Ancient Rock that contains the knowledge of Magic King Solomon - all the wisdom in the world. But during his time in the North, Ripper has discovered something else that has attracted his employers' attention. Jack the Ripper has never allied himself with any district, but when it comes to protecting the young mirror image, has he found someone he's willing to fight for?		8.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 8	2018-01-25T08:00:00.000Z
PRD_3JQ3NPG27GMG	CNT_1F2PA2T18VKG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 10	[]	Jack Frost, Vol. 10	Noh-A's awakening as the mirror image has granted her a more complete understanding of the events that led to her birth and what has happened since. The origins of Amityville are revealed to her, as is the threat of Solomon. The immense surge of power that accompanied Noh-A's transformation has aided Solomon's release from his prison, and the Witch King is headed to the North for a long-awaited - and long-dreaded - reunion with Helmina and Jack...!!	01KGA2H6CDN0BR80Q20S16MBCP	10.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 10	2018-01-25T08:00:00.000Z
PRD_3NT2JWCEFYTG	CNT_11QGNY6J2SXG	Jack Frost CNT_15HCTFJJKSS0	CNT_15HCTFJJKSS0	2	1	1	Volume 7	[]	Jack Frost, Vol. 7	Her father killed before her eyes, Noh-A flies into a rage, unleashing her true power as the mirror image. Can her father's words have meant what she suspects? Was Jack Frost responsible for her father's grisly demise in the human world? As Jack squares off against the vengeful mirror image, the truth of Noh-A's father's past and his relationship with the former mirror image is revealed...whether Noh-A is prepared to face it or not!		7.0	2018-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Jack Frost, Vol. 7	2018-01-25T08: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);