products

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

3 rows where series_id = "CNT_2BK8P5520MH0"

✎ 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_0CAJ4SFEXX60 CNT_1YVX3GDHFJEG Mark of the Succubus CNT_2BK8P5520MH0 CNT_2BK8P5520MH0 2 1 1 Volume 1 []   Mark of the Succubus Volume 1   Maeve, a succubus-in-training, is sent to the human world by her mentor, Veril, to learn how to blend in and hone her skills of seduction. However, things get a little complicated after she meets Aiden, a smart but unmotivated student at her new high school. Unfortunately for her, Sylne, the head succubus of the Demon World, has set a spy on her former protege to catch any missteps.   01KG9C65DEH910BGR9MJC5G8F6 1.0 2020-06-17T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Mark of the Succubus Volume 1     2020-06-23T07:00:00.000Z   0 0
PRD_1GV2PC8GSW50 CNT_3Y6A323STHFG Mark of the Succubus CNT_2BK8P5520MH0 CNT_2BK8P5520MH0 2 1 1 Volume 3 []   Mark of the Succubus Volume 3   The race is on for Maeve, Aiden and Devin to find a way to trick Sylne into betraying herself, but without Veril around, their efforts might be futile. Junael adds a formidable and highly knowledgeable component to the odd team, but even his advice and skill may not be enough. As a newly licensed and still-inexperienced demon, Maeve and her magical skills may be their best hope!   01KG9CMBQ1ZJPVSZHTCCBJMRG3 3.0 2020-06-17T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Mark of the Succubus Volume 3     2020-06-23T07:00:00.000Z   0 0
PRD_3JKTX3SKVXNG CNT_2YGKKS8NM1Y0 Mark of the Succubus CNT_2BK8P5520MH0 CNT_2BK8P5520MH0 2 1 1 Volume 2 []   Mark of the Succubus Volume 2   Maeve unfortunately must hurt the one person that she cares for. She now has a choice to save her first target or defy demon law! If she tries to bend the Rules, there may be a chance that neither of them will survive.   01KG9CMC7P9DJHSEHC4E53PWNK 2.0 2020-06-17T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Mark of the Succubus Volume 2     2020-06-23T07: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);