product_contributors

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

9 rows where contributor_id = "CON_1Z69YEKWND50"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03QFKZ351080,CON_1Z69YEKWND50,2 In Her Boss's Arms PRD_03QFKZ351080 Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_0PRYK2NYFZHG,CON_1Z69YEKWND50,2 Driving Him Wild PRD_0PRYK2NYFZHG Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_0SS0MK671Y6G,CON_1Z69YEKWND50,2 Bride of Convenience PRD_0SS0MK671Y6G Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_1CEKVMR15TR0,CON_1Z69YEKWND50,2 Pacific Heat PRD_1CEKVMR15TR0 Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_1SE2BNFQ4YE0,CON_1Z69YEKWND50,2 Bound by Marriage PRD_1SE2BNFQ4YE0 Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_209FPFBRSVR0,CON_1Z69YEKWND50,2 The Passion Bargain PRD_209FPFBRSVR0 Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_25WQSV1D2V5G,CON_1Z69YEKWND50,2 Keeping Her Baby's Secret PRD_25WQSV1D2V5G Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_2XG9CBYMACT0,CON_1Z69YEKWND50,2 A Wife on Paper PRD_2XG9CBYMACT0 Sayuri Nagasaki CON_1Z69YEKWND50 2  
PRD_31E4994CA0CG,CON_1Z69YEKWND50,2 Untamed PRD_31E4994CA0CG Sayuri Nagasaki CON_1Z69YEKWND50 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);