products

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

6 rows where series_id = "CNT_1ZRHKBRSFSHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_0G2XNY9FZG90 CNT_02XCKA33TV5G The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 3 []   The Eminence in Shadow, Vol. 3   THE RED MOON HANGS LOW IN THE NIGHT--AN OMEN OF WHAT’S TO COME Deep within the Lawless City lies the Blood Queen, a Progenitor Vampire, slumbering in her coffin for many moons. An expert at landing himself in trouble, Cid should know better than to go after her…but he’s dying to get a piece of the action. It’s time he shed his daytime persona to take on the role of Shadow! It seems, however, that he’s not the only one with this idea. Soon enough, he finds the three rulers of the Lawless City-Juggernaut the Tyrant, Yukime the Spirit Fox, and Crimson the vampire-are all on his tail. To complicate things even further, the Shadow Garden descends on the scene as the hour of the Blood Queen’s awakening looms closer and closer…   01KG9E0E6FS32DM8VR34B3SKFW 3.0 2021-03-26T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Eminence in Shadow, Vol. 3     2021-04-27T07:00:00.000Z   0 0
PRD_0XZKVP4CA5YG CNT_1JQ9Y6E1BRYG The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 6 []   The Eminence in Shadow, Vol. 6   A mysterious cabal called the Thirteen Nightblades has been running things in the Midgar Kingdom from the shadows, and its members have concealed all manner of crimes through their connections to the Cult of Diablos. How impressi—no, how terrible. These dastardly nobles commit so many evil deeds, and yet justice always evades them. That’s when a serial killer known only as “Jack the Ripper” appears, plunging the corrupt capital into chaos! In order to eradicate evil, an even greater evil is needed…   01KGBC8DQKPYHSWB8Y0PEJ3ARD 6.0 2024-08-14T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Eminence in Shadow, Vol. 6     2025-02-04T00:00:00.000Z   0 0
PRD_27RGWVZFD7P0 CNT_3R6S9656VSQG The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 4 []   The Eminence in Shadow, Vol. 4   THE DOOR OF DARKNESS IS CAST OPEN&mdash;THE WORLD ADVANCES TO A NEW FIELD<BR /><BR /> The specter of war hangs thick in the air of the Oriana Kingdom, where Princess Rose is expected to wed Duke Perv. This supposed marriage cannot and will not stand, though, as it would throw a major wrench in a certain shadowbroker&rsquo;s plans. Not one to miss an opportunity for sleuthing, Cid makes his way to the royal capital to put a stop to the ceremony, but are there even bigger schemes at work behind this unholy matrimony?   01KGAGK1RK5ZWAQMW1D6JZKK20 4.0 2022-05-10T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Eminence in Shadow, Vol. 4     2022-06-07T00:00:00.000Z   0 0
PRD_33WZ7VFXXBTG CNT_2WCMFY7BFFS0 The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 2 []   The Eminence in Shadow, Vol. 2   NOTHING COULD BE FURTHER FROM THE TRUTH Cid pays a visit to the Sacred Land, where he finds himself getting roped into the Goddess’s Trial. It’s a ritual event that summons warriors from the past to engage with only the most worthy from the present. When Cid squares off against the witch who brought devastation to the world, the door to the Sanctuary creaks open, granting the Shadow Garden valuable insight into the possessed and the Cult of Diablos. That is until Cid, blissfully ignorant of the conspiracies playing out behind the scenes, runs amok!   01KG9CCPR3W0ME6Z642YGGS4WT 2.0 2020-09-18T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Eminence in Shadow, Vol. 2     2020-11-10T08:00:00.000Z   0 0
PRD_39C0HQR2FCCG CNT_37B40QZEZYF0 The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 1 []   The Eminence in Shadow, Vol. 1   ONE BIG FAT LIE AND A FEW TWISTED TRUTHSEven in his past life, Cid’s dream wasn’t to become a protagonist or a final boss. He’d rather lie low as a minor character until it’s prime time to reveal he’s a mastermind…or at least, do the next best thing—pretend to be one! And now that he’s been reborn into another world, he’s ready to set the perfect conditions to live out his dreams to the fullest. Armed with his overactive imagination, Cid jokingly recruits members to his organization and makes up a whole backstory about an evil cult that they need to take down. Well, as luck would have it, these imaginary adversaries turn out to be the real deal—and everyone knows the truth but him!   01KGA63T8BM16AWXPKN6MJWZHF 1.0 2019-09-01T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Eminence in Shadow, Vol. 1     2020-08-11T07:00:00.000Z   0 0
PRD_3D4HDVD5EK4G CNT_0JAFN69YR3JG The Eminence in Shadow CNT_1ZRHKBRSFSHG CNT_1ZRHKBRSFSHG 2 2 1 Volume 5 []   The Eminence in Shadow, Vol. 5   All is well at the Midgar Academy for Dark Knights, but then something wicked suddenly draws near: The students are vanishing one by one—even Cid’s older sister Claire! Zeta of the Seven Shadows sets off to investigate while Cid and Alexia embark for Claire’s room where they find...ancient scripts, a cool magic circle, and spells that seem like they have great meaning and yet absolutely no meaning whatsoever?!   01KGAXZN8WNTGRGTGC2XKFCW7P 5.0 2024-01-25T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Eminence in Shadow, Vol. 5     2024-07-23T00:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);