BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_2E58X4MXARX0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03HJ1YFZ91NG,CON_2E58X4MXARX0,1 Just Once PRD_03HJ1YFZ91NG SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_0716GYCBNHEG,CON_2E58X4MXARX0,1 Vendetta PRD_0716GYCBNHEG SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_0ATPJG3KHY80,CON_2E58X4MXARX0,1 The Mistress Deception PRD_0ATPJG3KHY80 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_0G4AVCR1N6H0,CON_2E58X4MXARX0,1 Honeymoon Baby PRD_0G4AVCR1N6H0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_0GAEFRH9NN5G,CON_2E58X4MXARX0,1 The Love Conspiracy PRD_0GAEFRH9NN5G SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_146EYMSZPCE0,CON_2E58X4MXARX0,1 Savage Courtship PRD_146EYMSZPCE0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_25X05RSHD7Y0,CON_2E58X4MXARX0,1 The Hawk and the Lamb PRD_25X05RSHD7Y0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_267PTV0QEFX0,CON_2E58X4MXARX0,1 Secret Seduction PRD_267PTV0QEFX0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_2QF5355A7SD0,CON_2E58X4MXARX0,1 Public Scandal, Private Mistress PRD_2QF5355A7SD0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_2XKHRPFH4D90,CON_2E58X4MXARX0,1 Phantom Lover PRD_2XKHRPFH4D90 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_2ZGXG5W0CSSG,CON_2E58X4MXARX0,1 No Reprieve PRD_2ZGXG5W0CSSG SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_36CX123YB2V0,CON_2E58X4MXARX0,1 Mistress for a Weekend PRD_36CX123YB2V0 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_37G71W6VYH70,CON_2E58X4MXARX0,1 Mistress of the Groom PRD_37G71W6VYH70 SUSAN NAPIER CON_2E58X4MXARX0 1  
PRD_3R6VNG9RHJM0,CON_2E58X4MXARX0,1 A Lesson in Seduction PRD_3R6VNG9RHJM0 SUSAN NAPIER CON_2E58X4MXARX0 1  

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