database: products: 24 rows where series_id = "CNT

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

24 rows where series_id = "CNT_2XE4AGPS646G"

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_01PP5M9QCRJ0	CNT_0A0YAPQ51JHG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 14	[]	PandoraHearts, Vol. 14	Just when it seems the tragedy of Sablier is on the verge of recurring at Isla Yura's residence, the sinister blade of the Headhunter swings once more. From the darkness where the mysteries of Fianna's House and Humpty Dumpty converge, one truth will come to light: an unmoving reality that is itself so shocking, it seems like an illusion...Will Oz and his allies ever recover?	01KG97Y5VWP8AE7HBTWS2QV1WF	14.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 14	2016-06-30T15:00:00.000Z
PRD_0476Q7BS97H0	CNT_2DBBA0DDCHJG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 12	[]	PandoraHearts, Vol. 12	With Pandora and the Baskervilles in a race to discover the whereabouts of the seals that secure Glen Baskerville's body, Oz and his friends are caught up in the ensuing fury of this ruthless hunt. Amidst this chaos, Oscar Vessalius organizes a brief respite for his beloved nephew and his companions in the form of an outdoor tea party. When Oscar surprises all present with an impromptu group photograph, the memory of their fleeting peace together is captured in time so as to never be forgotten. If only such memories could be made to last forever by the simple act of wishing...	01KG97Y351HZ70E2X73ZPNRA7R	12.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 12	2016-06-30T15:00:00.000Z
PRD_08NH2T53N6G0	CNT_0CNRNJ3NVGKG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 10	[]	PandoraHearts, Vol. 10	A century before, in Sablier, a forbidden portal was flung wide by a boy, Vincent, in his single-minded desire to protect his brother, Gilbert. And thus did that foolhardy desire lead to the corruption of that innocent boy's soul like a sweet poison... Now, as Gil, Oz, and Alice wander the ruins of the former capital, they are assaulted by illusions from the past. But how much of it is real? And how much of it illusion?	01KG97Y0A6BJV0Q6SA63F31Y98	10.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 10	2016-06-30T15:00:00.000Z
PRD_0FA0CD75H5Q0	CNT_2FZNNXSY9FWG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 8	[]	PandoraHearts, Vol. 8	The snow-white maiden encountered once upon a time in the depths of the Abyss by the clown christened the Red-Eyed Specter...who was she really? As there are two sides to every story, could it be there are two sides to the existence known as Alice? Duke Barma may have provided a sordid outline, but Break colors the tale with vivid swathes of bloody crimson as he opens up about his past. Will these tragic truths long secreted away isolate Break further from his allies once he has revealed them?	01KG97XZ2C6HA0E2AJPXYHQRPQ	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 8	2016-06-30T15:00:00.000Z
PRD_0MEG20AXQFQ0	CNT_2B56DK5JG1W0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 24	[]	PandoraHearts, Vol. 24	Someone once said that all they would find there was darkness that swallowed everything whole. But that never meant that light was nowhere to be found-- They finally arrive at an answer to the question of how to save their world. It is the product of many months, even years. Cruel yet kind, it is a simple formula. Now, led on by the cogs of destiny, it spells the end of but one story...as if it were no more than a ridiculous fairy tale.	01KG933H9AD6J3R7RQDTC42TWV	24.0	2016-09-26T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 24	2016-09-26T15:00:00.000Z
PRD_0X07T1CD0SK0	CNT_2AP1BB2WJKGG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 16	[]	PandoraHearts, Vol. 16	Oz. Leo. Inescapable tragedy assaults and binds the two. He is no more. That simple truth tears their hearts apart like castles of sand caving in . . . But will history repeat itself when, in the midst of their sorrow, the two are pitted against each other in a struggle that could end in catastrophe?	01KG97Y8Z5609NMAW4Q6D11MA5	16.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 16	2016-06-30T15:00:00.000Z
PRD_0XFZJ36Q0KVG	CNT_217KKW8F6DZ0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 21	[]	PandoraHearts, Vol. 21	What I have granted them...is the "possibility" of survival. "I want you to be 'happy.'" One man's parting wish succeeds in awakening Oz's heart, long held captive in the depths of his own soul, as though breaking all the chains that bind him...	01KG97THVMPZHC4BXSZB9DPQX4	21.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 21	2016-06-30T15:00:00.000Z
PRD_10S5M2DC8S1G	CNT_26FNZB138410	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 22	[]	PandoraHearts, Vol. 22	Where in the world are you? This question is posed to Oz Vessalius once more. After overcoming the chains of infinite despair that bind him, the answer at which he arrives becomes a blinding light, piercing through the jet-black darkness. As though hope can be spun out of the emotions of a person's heart...	01KG95N2D1K7RNMY6T34YRBZH9	22.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 22	2016-06-30T15:00:00.000Z
PRD_1KRGZ01FX4P0	CNT_0FA2NFE6MEXG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 6	[]	PandoraHearts, Vol. 6	"What those people are looking at...isn't me." Though Oz's sudden appearance in the midst of Pandora wreaks havoc, the initially chilly reception to the prison-breaker runs more than warm when Jack Vessalius, hero of the tragedy of Sablier and the man from Alice's memories, manifests in Oz's body. Sensing Oz's resultant inner turmoil, Uncle Oscar drags Oz and company on a "mission" to Lutwidge Academy, where Oz's little sister, Ada, is a student. But some carefree fun and a tearful reunion ten years in the making is not all for which Oz must prepare himself: crimson-cloaked foes are lying in wait to torture him for answers about the events of a hundred years ago...	01KG97XVVWWTBRAEC9PMNQT7VX	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 6	2016-06-30T15:00:00.000Z
PRD_1P93AK2HS3N0	CNT_2EMZMS4F3DYG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 4	[]	PandoraHearts, Vol. 4	As Oz Vessalius and his valet, Gilbert, are reunited with their dear Uncle Oscar, they fail to notice an alienated Alice lost in thought stumbling right into the lurking Xerxes Break. Before Alice can take heed of Break's warning of a trap set by the Cheshire Cat - a powerful, extraordinary chain - she and Break are spirited away to Cheshire's lair, where both danger and fragments of Alice's past reside. With Sharon's help, Oz and Gil find a way to enter the sealed dimension of memories, but not only do their allies await them there, so too does the man from Alice's earlier memory! Does he hold the key to the truth about Oz's "sin"?	01KG97XT1XYKQR82CPG167KBAD	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 4	2016-06-30T15:00:00.000Z
PRD_1TZKM7WM52M0	CNT_01ZCM4TQECZG	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 2	[]	PandoraHearts, Vol. 2	"The answer you seek lies within them." Oz Vessalius may have survived his stint in the Abyss, but he is no closer to discovering the truth behind the "sin" for which he was condemned. On the advice of a mysterious man who appeared to him when Alice regained the first of her memories, Oz, along with Alice and Pandora's Raven, embarks on a mission to investigate the site of his disastrous coming-of-age ceremony in search of answers. However, what begins as a simple investigation becomes the revelation of a harsher reality, which comes swooping down on Oz as the hands of the clock continue ticking away mercilessly . . .	01KG97XRCJ1VCDZKY7CB5KATKH	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 2	2016-06-30T15:00:00.000Z
PRD_239FKBYJER2G	CNT_3AB7VDW0V300	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 15	[]	PandoraHearts, Vol. 15	Brother, master, friend... There once was an impure soul who, unknowingly, sealed a contract with Humpty Dumpty in the dark bowels of Sablier. But the time has come for him to face both his true self and his sins. Reexamining the events that have led him to this juncture, he comes to a realization and, choosing to stand by his convictions, decides on a course of action...as though it may yet save him somehow...	01KG97Y7FNG3N6KQCAC330BWF8	15.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 15	2016-06-30T15:00:00.000Z
PRD_27ZYYYRMB71G	CNT_1DNMTZJ96210	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 13	[]	PandoraHearts, Vol. 13	Vessalius makes his high-society debut at the manor of Isla Yura intending to investigate the potential location of one of the stone seals that Pandora seeks. But over the festivities and the secrets that swirl behind the masks of the merrymakers hangs a cloying scent of intrigue. And when the blood-blackened hand of a demon unexpectedly descends on those gathered, a waltz of madness begins... as if heralding anew an all-too-familiar tragedy...	01KG97Y4NXSCA5R3KHGD46M462	13.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 13	2016-06-30T15:00:00.000Z
PRD_292SV4M0K57G	CNT_1CAZ5MYT0030	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 9	[]	PandoraHearts, Vol. 9	The incuse on Oz Vessalius's chest ticks onward, but the young heir to one of the four great dukedoms directs his gaze back, seeking the facts behind a centuries-old tragedy. Intent on examining the ruins of Sablier despite warnings to scare him away, Oz and his makeshift party of explorers wander through the remnants of the former capital in search of clues to shed light upon the consuming darkness of the past. But in the yawning void where the opulent city once stood, will Oz come face-to-face with the truth? Or will he find misery the only resident...?	01KG97XZP0F0FHR4NZZYYTZ10Q	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 9	2016-06-30T15:00:00.000Z
PRD_2AC99HTYQ60G	CNT_3D01T98HN120	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 11	[]	PandoraHearts, Vol. 11	Once, following the tragedy of Sablier, Jack Vessalius made a valiant sacrifice to stop his best friend, Glen Baskerville, by allowing his body to anchor a set of seals by which Glen's soul was confined. But now these seals, long guarded by mages under the watchful gaze of Pandora, are being smashed one by one at the hands of the Crimson Shinigami, whose aim is to return their master to his once-whole state. And so, the fragile peace achieved over the last century begins to writhe, like a horror released from Pandora's forbidden box...	01KG97Y0Z6A07JSTDFVVA4B3PH	11.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 11	2016-06-30T15:00:00.000Z
PRD_2DCZYPEZ8P10	CNT_1G4VDBH6W12G	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 20	[]	PandoraHearts, Vol. 20	The pathetic farce that has unfolded in earnest is no more than an absurd yarn spun by the man who caused the Tragedy of Sablier by following his heart's desires. The players in his tale begin dancing with abandon, their emotions bottled up inside, as though they are marionettes manipulated by a master puppeteer . . .	01KG97ZT5HGHJGQBGHS915S5CV	20.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 20	2016-06-30T15:00:00.000Z
PRD_2DK86QPAZ46G	CNT_3FNC56K2FZC0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 7	[]	PandoraHearts, Vol. 7	The past holds everyone in its thrall, and Oz, Alice, Raven, Break, and their acquaintances are no exception, especially as recollections of the tragedy of Sablier elude even those who were present. Indeed, with his own body playing host to Jack Vessalius, the hero of Sablier, the likelihood of Oz escaping the past seems nigh impossible. But given a renewed lease on life by Elliot Nightray - the legitimate heir to the Nightray dukedom, of all people - Oz is eager to keep moving forward by learning all that he can about the events that came to pass all those years ago. To this end, he and his friends seek an audience with another of the four great dukes - Duke Rufus Barma. But it is not a glimpse into a hundredyear-old disaster that is revealed to them in the Duke's presence, but rather one into Break's lamentable, shockingly unforgettable past...	01KG97XYBQBBRWAZS5TF77M7BN	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 7	2016-06-30T15:00:00.000Z
PRD_2WRZ1RX82S3G	CNT_1B1AV27RC470	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 17	[]	PandoraHearts, Vol. 17	The earnest emotions of one man cross the divides of space and time, laying bare his life, which was long hidden in the depths of memory. But when these revelations come to pass, the reality Oz has known begins to change and shift into something wholly bewildering. Could the desire in one man's heart have been the very darkness gnawing at everything all along...?	01KG97YC62JKG3HVV7QVG9GPDN	17.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 17	2016-06-30T15:00:00.000Z
PRD_3G1RGAGCV35G	CNT_1EZS4G9ATYD0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 5	[]	PandoraHearts, Vol. 5	Guided by Jack Vessalius, the man from Alice's memories, Oz wanders back into the world of lost memories in search of Alice. There, he stumbles upon the devastating tragedy of Sablier, the century-old disaster which sent the old capital into the Abyss, an incident of which no one has any recollection...except Alice, who was there?! When Oz discovers the truth of the memories Alice so desperately wants to forget, the powers of the B-Rabbit will spiral out of control and threaten the lives of all who are trapped within the dreamlike dimension, including Alice herself...	01KG97XV0DST3TGC5W7K2FF58C	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 5	2016-06-30T15:00:00.000Z
PRD_3HXE8981MN00	CNT_3KF8CN7FB03G	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 19	[]	PandoraHearts, Vol. 19	Pandora, now under the control of Leo and the Baskervilles, bears witness as the truth of the being known as Oz Vessalius is exposed for all to see. Amidst the warped tragedy that plays out mercilessly, one who has lost everything catches a glimpse of the ridiculous fairy tale contrived by a living ghost, as though a forbidden box has just been opened...	01KG97ZRV47BAYC8XBW84VS8NA	19.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 19	2016-06-30T15:00:00.000Z
PRD_3MPB3XDQ724G	CNT_3E9P43ZK9XE0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 3	[]	PandoraHearts, Vol. 3	Having returned from the infernal Abyss only to find his whole world changed, young "sinner" Oz Vessalius embarks on an attempt at normalcy after being reunited with his best friend and valet, Gilbert, whom he had presumed dead. But during a trip into town with Gil and Alice, an unexpected encounter leads Oz down memory lane . . . For Oz, however, the path is one covered with the most menacing of thorns. And lying in wait to assail him there . . . The baleful eye of his father and the echoes of cursed words Oz would much rather forget . . .	01KG97XS6C9S6A67CRGB5M7HMF	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 3	2016-06-30T15:00:00.000Z
PRD_3V4TEGFS31BG	CNT_11M34DNVMWF0	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 1	[]	PandoraHearts, Vol. 1	The air of celebration surrounding fifteen-year-old Oz Vessalius's coming-of-age ceremony quickly turns to horror when he is condemned for a sin about which he knows nothing. He is thrown into an eternal, inescapable prison known as the Abyss from which there is no escape. There, he meets a young girl named Alice, who is not what she seems. Now that the relentless cogs of fate have begun to turn, do they lead only to crushing despair for Oz, or is there some shred of hope for him to grasp on to?	01KG6ZFQ5ABWZ2AHNK7V9DNS86	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 1	2016-06-30T15:00:00.000Z
PRD_3X6KBW487GXG	CNT_04D37HH8SB50	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 23	[]	PandoraHearts, Vol. 23	REMEMBER...WHAT IT IS YOU TRULY DESIRE--! Duldum and Duldee, two hearts struggling against each other. They are interchangeable, but far from ordinary, reverberations. The irreversible final moment closes in, a result of a seemingly hopeless wish. As if it was the beginning of the end...	01KG95HBB4YS0RG5VQ4NJBC4XY	23.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 23	2016-06-30T15:00:00.000Z
PRD_3ZNAR393F0AG	CNT_30YG7ZA43V80	PandoraHearts CNT_2XE4AGPS646G	CNT_2XE4AGPS646G	2	1	1	Volume 18	[]	PandoraHearts, Vol. 18	The tragedy that befell a bustling city a hundred years earlier. Eyes of ill omen. Stone seals. The warped gears that began turning long ago play out a requiem for one who was much loved. The solemn sound of the dirge colors the world that hears its notes a melancholy gray...as though it was always meant to be...	01KG97XMKEFKQGJJ7PVZM2ZJBT	18.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	PandoraHearts, Vol. 18	2016-06-30T15: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);