BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_00P8VQTYWJ20"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0146WSN2TXKG,CON_00P8VQTYWJ20,1 Protecting the Desert Heir PRD_0146WSN2TXKG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_01AZGD460VWG,CON_00P8VQTYWJ20,1 Heiress Behind the Headlines PRD_01AZGD460VWG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_087ZWAYRPE30,CON_00P8VQTYWJ20,1 At The Count'S Bidding PRD_087ZWAYRPE30 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_0EA51G0ZTF10,CON_00P8VQTYWJ20,1 Katrakis's Last Mistress PRD_0EA51G0ZTF10 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_0EME1K3D0QF0,CON_00P8VQTYWJ20,1 His for a Price PRD_0EME1K3D0QF0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_0NQ1PQEAB8S0,CON_00P8VQTYWJ20,1 Majesty, Mistress...Missing Heir PRD_0NQ1PQEAB8S0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_0PZBV3X9JDQ0,CON_00P8VQTYWJ20,1 A Devil in Disguise PRD_0PZBV3X9JDQ0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_149MEN8P39H0,CON_00P8VQTYWJ20,1 Traded to the Desert Sheikh PRD_149MEN8P39H0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_151221W1PY00,CON_00P8VQTYWJ20,1 In Defiance of Duty PRD_151221W1PY00 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_1AM51NBGV7XG,CON_00P8VQTYWJ20,1 The Prince'S Nine-Month Scandal PRD_1AM51NBGV7XG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_1C6WPYY72Z40,CON_00P8VQTYWJ20,1 Bride by Royal Decree PRD_1C6WPYY72Z40 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_1GRNSDVQ84V0,CON_00P8VQTYWJ20,1 The Reluctant Queen PRD_1GRNSDVQ84V0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_21K2257TQPWG,CON_00P8VQTYWJ20,1 Not Just the Boss's Plaything PRD_21K2257TQPWG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_228BKS91243G,CON_00P8VQTYWJ20,1 The Billionaire'S Secret Princess PRD_228BKS91243G CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_22RDM55X49BG,CON_00P8VQTYWJ20,1 The Replacement Wife PRD_22RDM55X49BG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_2BEEGHMY5QH0,CON_00P8VQTYWJ20,1 Pure Princess, Bartered Bride PRD_2BEEGHMY5QH0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_2BKKC6FCY37G,CON_00P8VQTYWJ20,1 The Man Behind the Scars PRD_2BKKC6FCY37G CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_2CTBAV2VNBVG,CON_00P8VQTYWJ20,1 His Christmas Captive PRD_2CTBAV2VNBVG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_2RN224TZQE30,CON_00P8VQTYWJ20,1 Princess From the Past PRD_2RN224TZQE30 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_30SN5Z3ZG70G,CON_00P8VQTYWJ20,1 Secrets Of His Forbidden Cinderella PRD_30SN5Z3ZG70G CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_327DTX9TRZKG,CON_00P8VQTYWJ20,1 His for Revenge PRD_327DTX9TRZKG CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_34WMHRNFZDP0,CON_00P8VQTYWJ20,1 A Royal Without Rules PRD_34WMHRNFZDP0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_3EHHNS0SAJB0,CON_00P8VQTYWJ20,1 My Bought Virgin Wife PRD_3EHHNS0SAJB0 CAITLIN CREWS CON_00P8VQTYWJ20 1  
PRD_3N2WD5TJJYRG,CON_00P8VQTYWJ20,1 The Guardian's Virgin Ward PRD_3N2WD5TJJYRG CAITLIN CREWS CON_00P8VQTYWJ20 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.209ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS