BookWalker

home / database

product_contributors

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

10 rows where contributor_id = "CON_2ZFJR8X6GQ20"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_012VCQA41G8G,CON_2ZFJR8X6GQ20,2 Zane: the Wild One PRD_012VCQA41G8G Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_0BCBKGYQ4MAG,CON_2ZFJR8X6GQ20,2 To Tame a Proud Heart PRD_0BCBKGYQ4MAG Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_0JXJ4Z283MG0,CON_2ZFJR8X6GQ20,2 The Boss's Baby Affair PRD_0JXJ4Z283MG0 Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_16KT3SKM4HG0,CON_2ZFJR8X6GQ20,2 The Italian's Pregnancy Proposal PRD_16KT3SKM4HG0 Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_21D9FSEJQ680,CON_2ZFJR8X6GQ20,2 Mistress by Mistake PRD_21D9FSEJQ680 Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_2FCKFNZATYNG,CON_2ZFJR8X6GQ20,2 Bride of the Bad Boy PRD_2FCKFNZATYNG Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_2NR2BTQ85PAG,CON_2ZFJR8X6GQ20,2 The Marriage Debt PRD_2NR2BTQ85PAG Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_2QH7CFEW6MCG,CON_2ZFJR8X6GQ20,2 Wealthy Australian, Secret Son PRD_2QH7CFEW6MCG Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_2VJ7FYYT3F2G,CON_2ZFJR8X6GQ20,2 The Billionaire's Pregnant Mistress PRD_2VJ7FYYT3F2G Yumi Eko CON_2ZFJR8X6GQ20 2  
PRD_34ESMZ0BW8SG,CON_2ZFJR8X6GQ20,2 About Last Night... PRD_34ESMZ0BW8SG Yumi Eko CON_2ZFJR8X6GQ20 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.519ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS