BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_3JAR2BY35NZ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_12B2888VRCSG,CON_3JAR2BY35NZ0,2 One Night of Love PRD_12B2888VRCSG Midori Seto CON_3JAR2BY35NZ0 2  
PRD_16YA8GN1A99G,CON_3JAR2BY35NZ0,2 A Night with the Society Playboy PRD_16YA8GN1A99G Midori Seto CON_3JAR2BY35NZ0 2  
PRD_1P4P5E8ZP2AG,CON_3JAR2BY35NZ0,2 The Life Saver PRD_1P4P5E8ZP2AG Midori Seto CON_3JAR2BY35NZ0 2  
PRD_1PJEYG319XK0,CON_3JAR2BY35NZ0,2 Naughty Nights in the Millionaire's Mansion PRD_1PJEYG319XK0 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_1S9AP1WKYGX0,CON_3JAR2BY35NZ0,2 His Girl Monday to Friday PRD_1S9AP1WKYGX0 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_1T7BV9HXKCD0,CON_3JAR2BY35NZ0,2 To Wear His Ring again PRD_1T7BV9HXKCD0 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_1V9N8Q7YCTA0,CON_3JAR2BY35NZ0,2 Acquired: The CEO's Small-Town Bride PRD_1V9N8Q7YCTA0 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_24WQPQM6BR80,CON_3JAR2BY35NZ0,2 Christmas in His Royal Bed PRD_24WQPQM6BR80 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_288N798WZTT0,CON_3JAR2BY35NZ0,2 The Disobedient Bride PRD_288N798WZTT0 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_28HMBQG39PHG,CON_3JAR2BY35NZ0,2 The Greek Doctor's New-Year Baby PRD_28HMBQG39PHG Midori Seto CON_3JAR2BY35NZ0 2  
PRD_2N61FSCZR610,CON_3JAR2BY35NZ0,2 The Greek Billionaire's Love-Child PRD_2N61FSCZR610 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_2P5Y8Z94KTCG,CON_3JAR2BY35NZ0,2 A Little office Romance PRD_2P5Y8Z94KTCG Midori Seto CON_3JAR2BY35NZ0 2  
PRD_30TGMMPJ4S10,CON_3JAR2BY35NZ0,2 The Italian Tycoon and the Nanny PRD_30TGMMPJ4S10 Midori Seto CON_3JAR2BY35NZ0 2  
PRD_35WMMW1PP0KG,CON_3JAR2BY35NZ0,2 Mistress Under Contract PRD_35WMMW1PP0KG Midori Seto CON_3JAR2BY35NZ0 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.907ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS