BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_3DTGSHJ3ZK6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01Q0HG6VQ3AG,CON_3DTGSHJ3ZK6G,1 The Sheikh's Virgin PRD_01Q0HG6VQ3AG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_02RREVJFBA30,CON_3DTGSHJ3ZK6G,1 The Greek's Royal Mistress PRD_02RREVJFBA30 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_039ZW8DXP61G,CON_3DTGSHJ3ZK6G,1 Marco's Pride PRD_039ZW8DXP61G Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_03SH6M9S8B9G,CON_3DTGSHJ3ZK6G,1 King of the Desert, Captive Bride PRD_03SH6M9S8B9G Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_0MT15P08BPVG,CON_3DTGSHJ3ZK6G,1 The Fallen Greek Bride PRD_0MT15P08BPVG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_0NMDMFMF5SWG,CON_3DTGSHJ3ZK6G,1 Bought to Carry His Heir PRD_0NMDMFMF5SWG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_14BGT9GE2SWG,CON_3DTGSHJ3ZK6G,1 Duty, Desire and the Desert King PRD_14BGT9GE2SWG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_1B77WPJYS3FG,CON_3DTGSHJ3ZK6G,1 His Merciless Marriage Bargain PRD_1B77WPJYS3FG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_1C1GQ6G28E0G,CON_3DTGSHJ3ZK6G,1 Taken by the Highest Bidder PRD_1C1GQ6G28E0G Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_1JXY8SMGJVPG,CON_3DTGSHJ3ZK6G,1 In Dante's Debt PRD_1JXY8SMGJVPG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_1MZQ55D7Q98G,CON_3DTGSHJ3ZK6G,1 The Italian's Virgin Princess PRD_1MZQ55D7Q98G Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_1W2P9M611D1G,CON_3DTGSHJ3ZK6G,1 The Sheikh's Wife PRD_1W2P9M611D1G Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_24YQTJ5ZFP30,CON_3DTGSHJ3ZK6G,1 His Majesty's Mistake PRD_24YQTJ5ZFP30 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_29E6MF8HEWA0,CON_3DTGSHJ3ZK6G,1 The Sheikh's Disobedient Bride PRD_29E6MF8HEWA0 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_2BF64571BN20,CON_3DTGSHJ3ZK6G,1 Not Fit for a King? PRD_2BF64571BN20 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_2CMQPF5KMV70,CON_3DTGSHJ3ZK6G,1 Lazaro's Revenge PRD_2CMQPF5KMV70 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_2E4W7TG20G40,CON_3DTGSHJ3ZK6G,1 The Sultan's Bought Bride PRD_2E4W7TG20G40 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_2M39VV66YJDG,CON_3DTGSHJ3ZK6G,1 Christos's Promise PRD_2M39VV66YJDG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_3DXJ1VH18HTG,CON_3DTGSHJ3ZK6G,1 At the Greek Boss's Bidding PRD_3DXJ1VH18HTG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_3GNCRPBSYNY0,CON_3DTGSHJ3ZK6G,1 The Secretary'S Seduction PRD_3GNCRPBSYNY0 Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_3JKD038JA4BG,CON_3DTGSHJ3ZK6G,1 The Spaniard'S Passion PRD_3JKD038JA4BG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_3K9K93F178BG,CON_3DTGSHJ3ZK6G,1 A Dark Sicilian Secret PRD_3K9K93F178BG Jane Porter CON_3DTGSHJ3ZK6G 1  
PRD_3TXGEDDDRDN0,CON_3DTGSHJ3ZK6G,1 The Sheikh's Chosen Queen PRD_3TXGEDDDRDN0 Jane Porter CON_3DTGSHJ3ZK6G 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.255ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS