products

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

9 rows where series_id = "CNT_0SFFXRN39YFG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_0AEBGPG6NBE0 CNT_3H3M7A2ZWFT0 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 3 []   The Saint's Magic Power is Omnipotent Vol. 3   The Saint's unique magic dwells within Sei, though she lacks full control and doesn't know why. She finds distraction in a sanctuary for rare herbs, where she can indulge her real passions. But the truth always catches up with Sei in the end, and this time, it will come through the words of a former Saint herself. She Can't Hide...From Herself 01KG9DXX22AB9ND9BPTZ1QFXTV 3.0 2021-01-15T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 3 Yuka Tachibana, Yasuyuki Syuri 2018   2021-02-04T08:00:00.000Z   0 0
PRD_0D2P282VEPM0 CNT_2QARJXKN2RG0 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 8 []   The Saint's Magic Power is Omnipotent Vol. 8   For over two years, Sei has traveled the lands of the Kingdom of Salutania to purify the miasma and subdue the monsters that plague her new home. However, while Sei may soon bring this chapter of her life to a close, the next has already begun. The time has come for the Saint to choose her future husband. While Sei's heart has long since belonged to a certain icy-eyed knight, many others seek her hand in marriage. Now Sei and Albert must find a way to confess their feelings before a certain noble's ambitions tear them apart forever. Hearts Entwined 01KGB69QCXZFEFDTJW6TV9KZ3T 8.0 2023-04-20T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 8 Yuka Tachibana, Yasuyuki Syuri 2022   2023-05-25T07:00:00.000Z   0 0
PRD_0DJHCMNQQVQG CNT_3P7QV4YGPZW0 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 1 []   The Saint's Magic Power is Omnipotent Vol. 1   Could workaholic office lady Sei be a legendary Saint? Not according to the crown prince of another world who summoned her and quickly declared a different girl was the real Saint! That suits Sei just fine--she would much rather spend her days quietly helping people with her unbelievably powerful magic. But how long can Sei live her ideal life of leisure before her true nature is revealed? This is Not the Saint You're Looking For 01KG9C8TGS56WD9XBAXHEQBAT4 1.0 2020-07-14T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 1 Yuka Tachibana, Yasuyuki Syuri 2017   2020-08-27T07:00:00.000Z   0 0
PRD_0PB5AFM12CEG CNT_2Y0XCRD651NG The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 6 []   The Saint's Magic Power is Omnipotent Vol. 6   Sei's life has just returned to a semblance of normal when she's once more summoned to the palace. A foreign prince is coming to the kingdom, ostensibly to study abroad, but his true intentions are shrouded in mystery. In order to protect Sei, the kingdom instructs her to hide her true identity as the Saint and retreat to the safety of the palace. While she complies at first, she soon finds herself drawn to the prince--especially when it becomes clear that she might be the only person who can help him. Potions and Politics 01KGADZPFXYYKGZQ3DTB0M1GDN 6.0 2021-12-15T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 6 Yuka Tachibana, Yasuyuki Syuri 2020   2022-02-24T08:00:00.000Z   0 0
PRD_1C98GK92KJA0 CNT_0SHR1CBNT6Y0 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 2 []   The Saint's Magic Power is Omnipotent Vol. 2   Grand Magus Yuri Drewes has risen from his coma, and he wants to teach Sei how to wield her magic. Just one problem: Yuri definitely suspects Sei's the Saint, but Sei's not ready to be outed. Even worse, under Yuri's tutelage, Sei's power continues to grow, and soon her true strength may be impossible to conceal. True Power Awakens 01KG9DF9YYHN4W4R0KD1XPBTCY 2.0 2020-11-13T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 2 Yuka Tachibana, Yasuyuki Syuri 2017   2020-11-26T08:00:00.000Z   0 0
PRD_1GZ427Y1QNXG CNT_2XKA828XSS20 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 5 []   The Saint's Magic Power is Omnipotent Vol. 5   Now that Sei has performed multiple miracles in the capital and beyond, her reputation is on the rise, as are her business ventures. Unfortunately, not everyone harbors entirely noble intentions for the Saint. Some would use her for their own ends. That's why Sei's friends and benefactors want to help her start her own company, as well as to secure her official place in high society--before someone tries to claim everything she's made, and everything she is, for themselves. MERCHANT, LADY, SAINT 01KG9HCVFJR38V37T33867A2EV 5.0 2021-11-08T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 5 Yuka Tachibana, Yasuyuki Syuri 2020   2021-11-25T08:00:00.000Z   0 0
PRD_1NJC8Q0WB80G CNT_2DFERGHG0WF0 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 4 []   The Saint's Magic Power is Omnipotent Vol. 4   At long last, Sei knows how to control the power of the Saint that resides within her...which means it's time to wield it. She must cleanse the forest of Klausner's Domain, or her new friends will never again know peace and prosperity. But Sei's first foray into the forest depths nearly ends in disaster. While she and the knights await reinforcements from the capital, Sei has to wonder: what if the Saint's magic isn't enough? What must she be ready to sacrifice to save the people of Klausner? Dark Heart of the Forest 01KG9FTFK4FHJZMS0XBKK125QW 4.0 2021-09-29T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 4 Yuka Tachibana, Yasuyuki Syuri 2019   2021-10-28T07:00:00.000Z   0 0
PRD_1SA4KKY480QG CNT_15QRZKB7RD60 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 7 []   The Saint's Magic Power is OmnipotentVol. 7   Sei's many accomplishments as the Saint have earned her a slew of marriage proposals, and it's honestly kind of a nightmare. Fortunately, she has the opportunity to escape all that with a trip to the Hawke Borderlands, the ancestral home of her dear Ice Knight, Albert Hawke. Less fortunately, she must go there in order to cleanse a new wellspring of miasma and the accompanying swarm of monsters. Little does she know, Albert is hoping the expedition will bear fruits beyond mere monster hunting. Will the Ice Knight finally make his move? Melting Hearts 01KGAJT9Y5YGMF5P0R3XG10PYQ 7.0 2022-10-13T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is OmnipotentVol. 7 Yuka Tachibana, Yasuyuki Syuri 2021   2022-10-27T07:00:00.000Z   0 0
PRD_1Y3Y40DGCFP0 CNT_3PJ24PM94S90 The Saint's Magic Power is Omnipotent CNT_0SFFXRN39YFG CNT_0SFFXRN39YFG 2 2 1 Volume 9 []   The Saint's Magic Power is Omnipotent Vol. 9   Sei's first journey abroad in this other world is to Zaidera and she's trying her hand at making magical amulets! She's also over the moon about her engagement to Albert. While busy with wedding preparations, Sei overhears how one of the members of First Prince Kyle's delegation to Zaidera is now bedridden with an unknown illness. Naturally, Sei can't just stand idly by, and, with that, her trip to Zaidera is hurriedly assured. However, upon her arrival, Kyle informs Sei that no one is sick and to make matters worse, the port has been closed, so they're now stuck abroad! AMULETS AND ADVENTURE 01KGAT6CZWAGB0YJZBWVYEWH7G 9.0 2023-10-31T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Saint's Magic Power is Omnipotent Vol. 9 Yuka Tachibana, Yasuyuki Syuri 2023   2023-12-07T08: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);