products

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

1 row where series_id = "CNT_3WXR0SFR8C20"

✎ 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_0698WKRRECZG CNT_1DFJ0ZG43TX0 Bartered Bride CNT_3WXR0SFR8C20 CNT_3WXR0SFR8C20 2 1 1 Bartered Bride []   Bartered Bride   Charlotte is about to be married to a British marquis she's never even met before. When her father's gambling habits caught up with him, he offered the hand of Clarice, Charlotte's twin sister, to pay off his debt to the marquis. There's just one problem—Clarice has gone missing! So Charlotte ends up disguising herself as her twin sister to become the infamous old lecher's bride in her place. She can't believe her misfortune...until she meets him face-to-face and learns he's nothing like she'd imagined. He's young—and shockingly handsome. But his eyes are full of contempt for Charlotte and his words are full of scorn. It's true their marriage was born of obligation, but why is the marquis so cruel to her?   01KGBXQXNR0JVQ1KX30SNARYQV 1.0 2025-10-10T07:00:00.000Z Harlequin LAB_0X8RR7JMBCBG GEO_1PQM5BDYSMG0 Bartered Bride ©RIHO SACHIMI/ANNE HERRIES   2025-10-01T07: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);