products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
12 rows where series_id = "CNT_2H452NKRD810"
This data as json, CSV (advanced)
Suggested facets: listed_at, copyright, on_sale_at, listed_at (date), on_sale_at (date)
| id ▼ | content_id | series_id | parent_content_id | level | content_type | product_type | title | alt_titles | subtitle | display_title | display_title_short | description | description_short | image_id | display_order | listed_at | label_id | geoblock_id | display_name | copyright | on_presale_at | on_sale_at | off_sale_at | add_on | add_on_campaign_only |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRD_03B2GCMSFT90 | CNT_0J4FENMQ1NAG | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 7 | [] | Trinity Blood, Vol. 7 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, lead by the Vatican, and the Methuselah Empire, the domain of the vampires! Astharoshe and Abel prepare to present their case to the Diwan, but the royal court is full of backstabbing intrigue, conspiracy and unpleasant surprises! Meanwhile, Ion and Esther get lost in the Methuselah capital, meet a strange young tea-seller and learn the horrifying truth that Radu may not be dead after all... | 01K5FYNASB2J3KPCFVWY5XB3N5 | 7.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 7 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2006 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_0JGHKC3YKZ60 | CNT_2HGECH7CYTDG | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 2 | [] | Trinity Blood, Vol. 2 | All roads lead to Rome and the Vatican, as Abel, Tres, and Esther set off to meet up with the rest of AX after the death of Gyula and the destruction of Esther's home church in Istavan. Esther's on a new mission, seeking to find herself and the source of her suffering, and new orders from the Vatican may lead to the answer. But the journey is filled with many twisted turns, including a formidable vampire, a bloodsucking tree, and a dangerously beautiful mermaid! In these original, never-before-told stories - which you will not find in the Trinity Bloodnovels or anime - all's fair in blood and war! | 01K5FYPMEM707C9BSEZ6J1E1N5 | 2.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 2 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2004 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_0WP1YRKBXD4G | CNT_1791Q8WK3RE0 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 1 | [] | Trinity Blood, Vol. 1 | In a dark and distant future, Armageddon has given rise to the fabled Second Moon - and a perpetual war between the vampires and the humans! Esther is a nun in the city of Istavan. When she crosses paths with Abel Nightroad, a priest sent from the Vatican to combat the local order of vampires, the two form a holy alliance to battle the most evil of threats. In this gorgeous, gothic-action series - part of the super-popular Trinity Blood franchise - the very survival of the human race is at stake! | 01K5FVJ8340RR8T8JJEG0NNFV6 | 1.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 1 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2004 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_165AJ7RNVABG | CNT_2DSXJD21CNF0 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 10 | [] | Trinity Blood, Vol. 10 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, led by the Vatican, and the Methuselah Empire, the domain of the vampires! When Abel and Esther arrive at Istvan, they are shocked to find the paparazzi descending on Esther. The Church has made her a ""Lady Saint"" for having saved Istvan from vampires a year ago. On this, the one-year anniversary of Esther's battle against Gyula Ka'Da'r, the town is staging an opera in her honor. But just as Esther is about to give the opening speech, she's kidnapped by an unexpected friend turned foe... | 01K5GA4PQEJWV8FJSW0RT29X3A | 10.0 | 2015-01-30T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 10 | (C) Kiyo KYUJYO 2008 (C)Sunao YOSHIDA 2008 | 2015-01-30T15:00:00.000Z | 0 | 0 | |||||
| PRD_198MFDM2389G | CNT_2CE7XAEJ6K90 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 11 | [] | Trinity Blood, Vol. 11 | In the damaged city of Istvan, where the populace clings to the hope of their Holy Saint Esther, intrigue and vengeance lurk around every corner. Ester and Schera are on the run from both AX and the Department of Inquisition, framed for a kidnapping and attempted assassination. A new member of the AX is hot on their tail-Sister Monica Argento, the Black Widow-and her powers are formidable. But it's not only the Vatican who has taken an interest in the proceedings in Istvan. The mysterious man from Albion has his own plans for Esther and co., and he may prove to be the most formidable of all. | 01K5GA4E8RQTVM6KXQV3CH87Z4 | 11.0 | 2015-01-30T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 11 | (C) Kiyo KYUJYO 2008 (C)Sunao YOSHIDA 2008 | 2015-01-30T15:00:00.000Z | 0 | 0 | |||||
| PRD_2160AJ597JJG | CNT_03Q2YA6D2CG0 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 12 | [] | Trinity Blood, Vol. 12 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, led by the Vatican, and the Methuselah Empire, the domain of the vampires! With the Pope injured and what seems like the entire Vatican turned against them, Esther and Schera must fight for their lives while trying to reveal Cardinal D'Annuncio's fiendish plot. But with so much blood already shed, can even the Lady Saint and her powerful ally escape unscathed? Then, as the curtain closes on the story of Istvan, a new story begins as Esther and co. head towards the island nation of Albion! | 01KKTXZDJRCJSY6EG4QPA22493 | 12.0 | 2015-01-30T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 12 | (C) Kiyo KYUJYO 2009 (C)Sunao YOSHIDA 2009 | 2015-01-30T15:00:00.000Z | 0 | 0 | |||||
| PRD_286PZRS9S2K0 | CNT_2PVW14F2DCGG | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 9 | [] | Trinity Blood, Vol. 9 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, led by the Vatican, and the Methuselah Empire, the domain of the vampires! The faith of Radu's body lies within the intensifying battle between Abel and Dietrich. As the fight ensues, Seth provides some much-needed assistance to Abel, revealing a new twist in their relationship...Will their ""tie that bonds"" be strong enough to help Abel as he pursues vengenance on Cain and attempts to forget his past sins? | 01K5GA5V754YYE86KC6CDTX58J | 9.0 | 2015-01-30T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 9 | (C) Kiyo KYUJYO 2007 (C)Sunao YOSHIDA 2007 | 2015-01-30T15:00:00.000Z | 0 | 0 | |||||
| PRD_2F1A9EN1B9R0 | CNT_2R8C1AERW3VG | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 8 | [] | Trinity Blood, Vol. 8 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, lead by the Vatican, and the Methuselah Empire, the domain of the vampires! A plot to assassinate the Methuselah Emperor is revealed at last, but it's not Radu who is accused of the crime-Ion, Esther and company are suddenly the main suspects! Astharoshe struggles with her own immortality, and how feelings of loyalty and love can change over the course of centuries. Meanwhile, Deitrich has yet another cruel twist of fate in store for his beloved Esther... | 01KKTXW3F6QRDGJ3GW1521W9DB | 8.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 8 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2006 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_2VRETV6WKFP0 | CNT_249Y7MB6E9XG | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 6 | [] | Trinity Blood, Vol. 6 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, led by the Vatican, and the Methuselah Empire, the domain of the vampires! Sister Esther and Abel finally reconcile in the aftermath of Radu's devastating attack. As Ion slowly recovers and copes with his best friend's betrayal, the party finally reaches the capital of the Methuselah Empire...only to discover that even within the glorious city, they are anything but safe! Deception, intrigue and bloodshed lurk around every corner, and many secrets and mysteries are about to be revealed in this next thrilling volume ofTrinity Blood! | 01KKTXWMNZRMQ05PP3GAJBQZYZ | 6.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 6 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2006 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_3PB6FNRS653G | CNT_3PD6R2V59070 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 5 | [] | Trinity Blood, Vol. 5 | In the dark and distant future, Armageddon has given rise to an eternal war between the humans, led by the Vatican, and the Methuselah Empire, the domain of the vampires! Esther is left terrified by Abel's form as the Crusnik while the Vatican agents, along with the injured Petros, head east to return Ion to the Empire. But an enormous artificial sandstorm is unleashed by Radu in a final attempt to destroy the city of Carthage. New alliances must be forged in order to halt its devastating path. Meanwhile, while an old friend is waiting for Abel in a secret underground chamber... The manga that inspired the anime continues! | 01K5FYFX14VZ5FHTWF9TBTZDDA | 5.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 5 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2005 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_3XR7EDEW7M30 | CNT_0WWD3ET2ZZ0G | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 3 | [] | Trinity Blood, Vol. 3 | The Gothic-action masterpiece continues as Esther remembers the cold, cruel day when a heartless Dietrich betrayed her. And now, among the flames, Radu is about to do the same to Ion...until Brother Petros and his Department of Inquisition arrive. Weakened after his previous fight with Petros, Abel is just barely keeping himself under control and, as the battle rages, Esther may once again find herself betrayed by someone she trusted... | 01K5FYRGVXT0V0B13BY2AR3H9H | 3.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 3 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2005 | 2014-10-28T15:00:00.000Z | 0 | 0 | |||||
| PRD_3XWHPEPFA20G | CNT_28CXV9XYEX20 | Trinity Blood CNT_2H452NKRD810 | CNT_2H452NKRD810 | 2 | 1 | 1 | Volume 4 | [] | Trinity Blood, Vol. 4 | The newly initiated Sister Esther has joined up with the warriors of the Vatican, but distrusts the relationship between the Cardinal Caterina and Abel...especially when Caterina starts to make friendly diplomatic gestures towards the Empire in the East, where vampires rule! When two emmisaries appear, suspicions are deepened once again - but just who are these mysterious men? | 01K5FYDG5FJQHM7T9S3QR684P0 | 4.0 | 2014-10-28T15:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Trinity Blood, Vol. 4 | (C) Kiyo KYUJYO 2004(C)Sunao YOSHIDA 2005 | 2014-10-28T15:00:00.000Z | 0 | 0 |
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);