BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_1ZHEFWX06PSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_08R713VFZHX0,CON_1ZHEFWX06PSG,2 Lover's Reunion PRD_08R713VFZHX0 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_0WGCACT3WYG0,CON_1ZHEFWX06PSG,2 Bought by Her Husband PRD_0WGCACT3WYG0 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_10XBVA2RKMEG,CON_1ZHEFWX06PSG,2 A Proper Wife PRD_10XBVA2RKMEG Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_163WFARYHSNG,CON_1ZHEFWX06PSG,2 The Bitter Price of Love PRD_163WFARYHSNG Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_1GSDE1ATY240,CON_1ZHEFWX06PSG,2 The Last Illusion PRD_1GSDE1ATY240 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_1YEZ0WJZQ4HG,CON_1ZHEFWX06PSG,1 Kunoichi: Hatsume's Tragedy PRD_1YEZ0WJZQ4HG Chikae Ide CON_1ZHEFWX06PSG 1  
PRD_2FRCT3EMTRJG,CON_1ZHEFWX06PSG,2 Pregnant with the De Rossi Heir PRD_2FRCT3EMTRJG Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_2TMN76J6ZAZ0,CON_1ZHEFWX06PSG,2 Pirate Tycoon, Forbidden Baby PRD_2TMN76J6ZAZ0 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_310DH7DAAP40,CON_1ZHEFWX06PSG,2 Drive Me Wild PRD_310DH7DAAP40 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_33KXASWESA2G,CON_1ZHEFWX06PSG,2 Accidental Fiancee PRD_33KXASWESA2G Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_3AES29SSEDCG,CON_1ZHEFWX06PSG,2 The Nanny And The Ceo PRD_3AES29SSEDCG Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_3C3QM7E990F0,CON_1ZHEFWX06PSG,2 Wedding Night with a Stranger PRD_3C3QM7E990F0 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_3EGNP2TMG17G,CON_1ZHEFWX06PSG,2 The Italian's Mistress PRD_3EGNP2TMG17G Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_3FVK98PT4000,CON_1ZHEFWX06PSG,2 A Sicilian Marriage PRD_3FVK98PT4000 Chikae Ide CON_1ZHEFWX06PSG 2  
PRD_3SWNS395AM20,CON_1ZHEFWX06PSG,2 Honky-Tonk Cinderella PRD_3SWNS395AM20 Chikae Ide CON_1ZHEFWX06PSG 2  

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.572ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS