BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_00KQMDFT98V0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0BK4VG62B280,CON_00KQMDFT98V0,1 The Sultan's Bed PRD_0BK4VG62B280 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_0J4HPVMKF3PG,CON_00KQMDFT98V0,1 Rich Man's Vengeful Seduction PRD_0J4HPVMKF3PG LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_1AWVFCPDFK6G,CON_00KQMDFT98V0,1 Millionaire's Calculated Baby Bid PRD_1AWVFCPDFK6G LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_1MVNG0TMH1P0,CON_00KQMDFT98V0,1 A Bed of Sand PRD_1MVNG0TMH1P0 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_1QMWW2C3QX2G,CON_00KQMDFT98V0,1 Redwolf'S Woman PRD_1QMWW2C3QX2G LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_22P2BV0B5Y40,CON_00KQMDFT98V0,1 Cinderella & The Playboy PRD_22P2BV0B5Y40 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_2B1EC3CZBVSG,CON_00KQMDFT98V0,1 Hearts Are Wild PRD_2B1EC3CZBVSG LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_2C5N2RRTRM80,CON_00KQMDFT98V0,1 Front Page Engagement PRD_2C5N2RRTRM80 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_2TST5MYMQS60,CON_00KQMDFT98V0,1 Her Royal Bed PRD_2TST5MYMQS60 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_35PWWTFCPNB0,CON_00KQMDFT98V0,1 Charming the Prince PRD_35PWWTFCPNB0 LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_3D74XS75RKKG,CON_00KQMDFT98V0,1 Ruling Passions PRD_3D74XS75RKKG LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_3FBAPSZWH85G,CON_00KQMDFT98V0,1 Sleeping with Beauty PRD_3FBAPSZWH85G LAURA WRIGHT CON_00KQMDFT98V0 1  
PRD_3TDPWPFQH8K0,CON_00KQMDFT98V0,1 Playboy's Ruthless Payback PRD_3TDPWPFQH8K0 LAURA WRIGHT CON_00KQMDFT98V0 1  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE product_contributors (
      product_id TEXT NOT NULL,
      contributor_id TEXT NOT NULL,
      role INTEGER NOT NULL,
      name_override TEXT,
      PRIMARY KEY (product_id, contributor_id, role),
      FOREIGN KEY (product_id) REFERENCES products(id),
      FOREIGN KEY (contributor_id) REFERENCES contributors(id)
    );
CREATE INDEX idx_product_contributors_contributor ON product_contributors(contributor_id);
Powered by Datasette · Queries took 8.637ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS