product_contributors

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

14 rows where contributor_id = "CON_34PM1X8QHKMG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02BT6Q8EYMQG,CON_34PM1X8QHKMG,2 Di Cesare's Pregnant Mistress PRD_02BT6Q8EYMQG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0A3DE0SZHTAG,CON_34PM1X8QHKMG,2 Taken by the Tycoon PRD_0A3DE0SZHTAG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0A8DHD1YBP20,CON_34PM1X8QHKMG,2 Messing with Mac PRD_0A8DHD1YBP20 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0D1FD616BAXG,CON_34PM1X8QHKMG,2 The Spaniard's Virgin Housekeeper PRD_0D1FD616BAXG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0DHERX6WJF7G,CON_34PM1X8QHKMG,2 Lovers Touch PRD_0DHERX6WJF7G Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0WXE3ZNDCJ20,CON_34PM1X8QHKMG,2 Bought by Her Latin Lover PRD_0WXE3ZNDCJ20 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_0ZG1YFQNSR20,CON_34PM1X8QHKMG,2 Passionate Relationship PRD_0ZG1YFQNSR20 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_1BTJRE72VR40,CON_34PM1X8QHKMG,2 Seduction PRD_1BTJRE72VR40 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_1HS9TY90MRT0,CON_34PM1X8QHKMG,2 The Master's Mistress PRD_1HS9TY90MRT0 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_1XMZHJFZ1KS0,CON_34PM1X8QHKMG,2 L.a. Confidential PRD_1XMZHJFZ1KS0 Juri Nakao CON_34PM1X8QHKMG 2  
PRD_24GZ2GJNFWTG,CON_34PM1X8QHKMG,2 Beguiled PRD_24GZ2GJNFWTG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_3KWA5KE9GYBG,CON_34PM1X8QHKMG,2 An Exception to His Rule PRD_3KWA5KE9GYBG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_3RCJDJ02HCWG,CON_34PM1X8QHKMG,2 One Night with the Enemy PRD_3RCJDJ02HCWG Juri Nakao CON_34PM1X8QHKMG 2  
PRD_3T02TJ17SYG0,CON_34PM1X8QHKMG,2 The Secretary's Secret PRD_3T02TJ17SYG0 Juri Nakao CON_34PM1X8QHKMG 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);