BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_1KFQZR8SJ6A0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_06HF09TT1QKG,CON_1KFQZR8SJ6A0,1 At His Majesty's Convenience PRD_06HF09TT1QKG Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_15AV9SDHQX90,CON_1KFQZR8SJ6A0,1 The Heir's Scandalous affair PRD_15AV9SDHQX90 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_1CZH3Q21YGBG,CON_1KFQZR8SJ6A0,1 The Boss's Demand PRD_1CZH3Q21YGBG Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_1MNNMV8DMY90,CON_1KFQZR8SJ6A0,1 In the argentine's Bed PRD_1MNNMV8DMY90 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_1QB0HMWHQK5G,CON_1KFQZR8SJ6A0,1 Bachelor's Bought Bride PRD_1QB0HMWHQK5G Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_1Y0BPQ1VW730,CON_1KFQZR8SJ6A0,1 The Maverick's Virgin Mistress PRD_1Y0BPQ1VW730 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_20QZ712Z314G,CON_1KFQZR8SJ6A0,1 The Desert Prince PRD_20QZ712Z314G Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_24Q8AHT0JAR0,CON_1KFQZR8SJ6A0,1 Claiming His Royal Heir PRD_24Q8AHT0JAR0 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_2BZCRNYYYDWG,CON_1KFQZR8SJ6A0,1 A High Stakes Seduction PRD_2BZCRNYYYDWG Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_37XKCBP5YVW0,CON_1KFQZR8SJ6A0,1 Millionaire's Secret Seduction PRD_37XKCBP5YVW0 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_3B431N0JDKP0,CON_1KFQZR8SJ6A0,1 Prince of Midtown PRD_3B431N0JDKP0 Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_3KT4969PDHHG,CON_1KFQZR8SJ6A0,1 The Prince's Pregnant Bride PRD_3KT4969PDHHG Jennifer Lewis CON_1KFQZR8SJ6A0 1  
PRD_3QTSZ1PMPVM0,CON_1KFQZR8SJ6A0,1 Her Desert Knight PRD_3QTSZ1PMPVM0 Jennifer Lewis CON_1KFQZR8SJ6A0 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 11.07ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS