products

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

9 rows where series_id = "CNT_1W2SDT0FY8ZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, 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_0HPBJB73QBPG CNT_2YPWT3K8ZAM0 The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGB6VM905VKC7SNG6411RAP3 1.0 2023-05-26T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 1 Yuka Tachibana, Yasuyuki Syuri 2017   2023-06-20T07:00:00.000Z   0 0
PRD_0YXSAPHS5N5G CNT_2MJ4KVVR2ZTG The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 Volume 7 []   The Saint's Magic Power is Omnipotent Vol. 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 01KGATD9SXQD410Y1PMRRMX4KG 7.0 2023-12-04T08:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 7 Yuka Tachibana, Yasuyuki Syuri 2021   2024-02-15T08:00:00.000Z   0 0
PRD_19KGTK8SPRR0 CNT_2EKPNESZ32Q0 The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGASKXXA3X4DY9CM0QEPTMGE 6.0 2023-09-15T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 6 Yuka Tachibana, Yasuyuki Syuri 2020   2024-01-11T08:00:00.000Z   0 0
PRD_1WJ46R234WBG CNT_0FAWYVW5DQ0G The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KH3FY5F7KHEPR7J3G1A5KXA2 3.0 2023-07-24T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 3 Yuka Tachibana, Yasuyuki Syuri 2018   2023-10-05T07:00:00.000Z   0 0
PRD_2GPKQS45Z6Y0 CNT_218GMA4FX0H0 The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGASKV5S6N03G398F0M6N9Q5 4.0 2023-09-15T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 4 Yuka Tachibana, Yasuyuki Syuri 2019   2023-11-02T07:00:00.000Z   0 0
PRD_2Q721C6FV5X0 CNT_00KDQNTR8ZJ0 The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGASKS6SNZW5CNR4CTAJR0QF 5.0 2023-09-15T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 5 Yuka Tachibana, Yasuyuki Syuri 2020   2023-12-14T08:00:00.000Z   0 0
PRD_2RMPGC6M7PP0 CNT_1MXE3H0KXG90 The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGAVBFQX1BW70ER0RKM09D7B 8.0 2023-12-04T08:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 8 Yuka Tachibana, Yasuyuki Syuri 2022   2024-03-14T07:00:00.000Z   0 0
PRD_2TC2P8GAH950 CNT_1HP0NP4NGS6G The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KGB7X2FHRJDEB7EDTJ75FN2F 2.0 2023-05-26T07:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 2 Yuka Tachibana, Yasuyuki Syuri 2017   2023-07-06T07:00:00.000Z   0 0
PRD_2X830FWRX5QG CNT_1GQ7Z8MJ1N7G The Saint's Magic Power is Omnipotent CNT_1W2SDT0FY8ZG CNT_1W2SDT0FY8ZG 2 4 2 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 01KG9PPFT40YD64KR3MQGMK5SW 9.0 2024-02-01T08:00:00.000Z Seven Seas Siren LAB_13Q4428H6SGG GEO_1PKAG51AEAQG The Saint's Magic Power is Omnipotent Vol. 9 Yuka Tachibana, Yasuyuki Syuri 2023   2024-05-16T07: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);