products

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

3 rows where series_id = "CNT_1WG7D75CW0HG"

✎ 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_1CK0MWQVYM6G CNT_0725KV834G6G The Wolf Never Sleeps CNT_1WG7D75CW0HG CNT_1WG7D75CW0HG 2 1 1 Volume 3 []   The Wolf Never Sleeps, Vol. 3   After overcoming countless trials, Lecan has proven himself worthy to Sheila, a “humble” apothecary of immense magic power. While her knowledge of pharmacy is more than valuable enough, Lecan also learns how to use an entirely new form of magic under her tutelage, a discovery that has the stoic, hardened adventurer grinning with childish delight. Armed with more abilities than ever before, Lecan resolves to take on the greatest challenge he’s faced in this world—Golbul dungeon...   01KGB2N3E0W9TY5K5JHY827BGJ 3.0 2022-12-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Wolf Never Sleeps, Vol. 3     2023-02-21T00:00:00.000Z   0 0
PRD_2K22X6QQEPBG CNT_0R9HERAJ63J0 The Wolf Never Sleeps CNT_1WG7D75CW0HG CNT_1WG7D75CW0HG 2 1 1 Volume 2 []   The Wolf Never Sleeps, Vol. 2   After leaving Zeidmoore Manor and returning to the life of a traveling adventurer, Lecan’s first order of business is to find an apothecary capable of replenishing his limited stock of effective medicine. His best bet lies in the city of Volka, and he is soon hired as a bodyguard for a wagon headed there—a position he will share with the (self-professed) master adventurer Eda. Can Lecan survive attacks by monsters and bandits with only someone who couldn’t fight her way out of a paper bag watching his back?!   01KGAJKTDAXKR4M2ER07CK548G 2.0 2022-09-01T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Wolf Never Sleeps, Vol. 2     2022-09-20T00:00:00.000Z   0 0
PRD_3VJ1CGC1B960 CNT_1E7AB8G7CC7G The Wolf Never Sleeps CNT_1WG7D75CW0HG CNT_1WG7D75CW0HG 2 1 1 Volume 1 []   The Wolf Never Sleeps, Vol. 1   Seeking strength and glory, the adventurer Lecan challenges monster and maze alike. Until one day, he finds a mysterious black hole…leading to another world! But even in a different world, the path of the “One-Eyed Wolf” remains unchanged. The only question is—can he survive the new world?   01KGAGYNV4RTH93W8DZQ1ZTZZZ 1.0 2022-04-25T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Wolf Never Sleeps, Vol. 1     2022-05-24T00: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);