products

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

3 rows where series_id = "CNT_0484RGZ11KXG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_0X72P9JTSCA0 CNT_18WBGCH9Q1AG Scarlet Soul CNT_0484RGZ11KXG CNT_0484RGZ11KXG 2 1 1 Volume 2 []   Scarlet Soul Volume 2   After their search for the missing Great Priestess Lys leads Rin and Aghyr into trouble and an unexpected battle at the Water Sanctuary, they take some time to regroup among their friends of the Kaishin Clan. There, they meet up with the Fire Oracles Kara and Koru, who have prophesied the arrival of the Scarlet Soul— none other than Rin Shirano herself. With the Fire Oracles' help, Rin reclaims her sister's sword Hitaken, which has chosen her as its wielder. Whether she feels ready to take on the responsibility or not, she is the only one who can carry the ancient exorcist blade now. With demon activity increasing throughout the land, it's more important than ever that the Great Priestess is found as quickly as possible... even as forces gather that will stop at nothing to make sure Rin can never see her sister again!   01KG9D44V72HH9C3VQRRBXYKZV 2.0 2020-08-25T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Scarlet Soul Volume 2 ｺﾋﾟｰﾗｲﾄなし   2020-09-15T07:00:00.000Z   0 0
PRD_2W4WWKS2RWM0 CNT_2DEF5XWBKBQG Scarlet Soul CNT_0484RGZ11KXG CNT_0484RGZ11KXG 2 1 1 Volume 3 []   Scarlet Soul, Volume 3   After being separated from her companion and held captive, Rin finally broke the enchantment and was able to reunite with Aghyr. Now their only chance at getting answers about the sacred sword lies with the very same wind oracle who trapped Rin—Buren! Can they trust Buren when he says he's seen Rin's missing sister, Lys? Not only that, but Buren claims Hitaken actually has a sister sword! Everything that's happened so far seems to be connected in ways Rin doesn't yet understand, but Aghyr might have a vital clue he's been hiding from Rin all this time...   01KGB6G0FV83RFGE8PG30HKMW4 3.0 2023-05-15T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Scarlet Soul, Volume 3     2023-05-31T07:00:00.000Z   0 0
PRD_3X3WPT13X9N0 CNT_2C6G8RVB5AQG Scarlet Soul CNT_0484RGZ11KXG CNT_0484RGZ11KXG 2 1 1 Volume 1 []   Scarlet Soul Volume 1   The kingdom of Nohmur has been a peaceful land for humans since the exorcist Eron Shirano repelled the demons and sealed the way to the underworld of Ruhmon. Generations later, sisters Lys and Rin are the heirs of the illustrious Shirano family, the most powerful exorcist clan charged with watching over the barrier and maintaining balance between the two worlds with the aid of Hikaten, the Sword of a Hundred Souls. Until one day, for unknown reasons, demons begin slipping through once more... and suddenly, Lys vanishes without a trace, leaving the sacred sword behind for her little sister to take up. As the underworld threat grows, Rin sets out alongside her companion, the mysterious Aghyr, to find her missing sister and figure out how to fortify the weakening barrier between her world and that of the monstrous creatures that threaten her kingdom once again.   01KG9BPQ4RCQN47VXHSRJCBTD4 1.0 2020-01-17T08:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Scarlet Soul Volume 1     2020-01-22T08: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);