BookWalker

home / database

product_contributors

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

9 rows where contributor_id = "CON_3GHF5Q8GPG4G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0D41ZJJC68X0,CON_3GHF5Q8GPG4G,2 Touch Me In The Morning PRD_0D41ZJJC68X0 Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_0XFK9BCG4G30,CON_3GHF5Q8GPG4G,2 Bride on the Loose PRD_0XFK9BCG4G30 Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_1RTYN0YMZQ2G,CON_3GHF5Q8GPG4G,2 Price to Be Met PRD_1RTYN0YMZQ2G Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_1TEHBA0MC9G0,CON_3GHF5Q8GPG4G,2 The Doctor's Runaway Bride PRD_1TEHBA0MC9G0 Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_2GYAHJB7VTE0,CON_3GHF5Q8GPG4G,2 Hunter's Vow PRD_2GYAHJB7VTE0 Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_2X5S0MNF4K0G,CON_3GHF5Q8GPG4G,2 A Simple Texas Wedding PRD_2X5S0MNF4K0G Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_3529JDB51JXG,CON_3GHF5Q8GPG4G,2 One Good Cowboy PRD_3529JDB51JXG Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_3K56127NGT60,CON_3GHF5Q8GPG4G,2 His Christmas Acquisition PRD_3K56127NGT60 Junko Matsufuji CON_3GHF5Q8GPG4G 2  
PRD_3QGBWMP13X20,CON_3GHF5Q8GPG4G,2 The Substitute Wife PRD_3QGBWMP13X20 Junko Matsufuji CON_3GHF5Q8GPG4G 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.66ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS