BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_05A5VJKK9T30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_067T4B907360,CON_05A5VJKK9T30,10 Volume 12 PRD_067T4B907360 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0AMAQYBA3250,CON_05A5VJKK9T30,10 Volume 17 PRD_0AMAQYBA3250 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0BKE0JX3EWK0,CON_05A5VJKK9T30,10 Volume 1 PRD_0BKE0JX3EWK0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0GKQT5M8J1GG,CON_05A5VJKK9T30,10 Volume 19 PRD_0GKQT5M8J1GG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0K8F2XRAH80G,CON_05A5VJKK9T30,10 Volume 10 PRD_0K8F2XRAH80G Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0N8DZX93HCD0,CON_05A5VJKK9T30,10 Volume 6 PRD_0N8DZX93HCD0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0PZT83QAX5DG,CON_05A5VJKK9T30,10 Volume 3 PRD_0PZT83QAX5DG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0Q065RHJY0QG,CON_05A5VJKK9T30,10 Volume 23 PRD_0Q065RHJY0QG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0RJ8XJKHK610,CON_05A5VJKK9T30,10 Volume 15 PRD_0RJ8XJKHK610 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0XJ9M9K31M4G,CON_05A5VJKK9T30,10 Volume 9 PRD_0XJ9M9K31M4G Cliff Kirk CON_05A5VJKK9T30 10  
PRD_0Y712YDZ6ENG,CON_05A5VJKK9T30,10 Volume 18 PRD_0Y712YDZ6ENG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_1C0346A3K7Z0,CON_05A5VJKK9T30,10 Volume 5 PRD_1C0346A3K7Z0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_1N8K8RZ54DPG,CON_05A5VJKK9T30,10 Volume 3 PRD_1N8K8RZ54DPG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_1RZDDP59QCKG,CON_05A5VJKK9T30,10 Volume 8 PRD_1RZDDP59QCKG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_1ZX9ZH3EMDVG,CON_05A5VJKK9T30,10 Volume 4 PRD_1ZX9ZH3EMDVG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_232R6VY60C40,CON_05A5VJKK9T30,10 Volume 20 PRD_232R6VY60C40 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_28XX88TF12MG,CON_05A5VJKK9T30,10 Volume 14 PRD_28XX88TF12MG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2AYKBSYCQJT0,CON_05A5VJKK9T30,10 Volume 8 PRD_2AYKBSYCQJT0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2EPAEMQMM990,CON_05A5VJKK9T30,10 Volume 21 PRD_2EPAEMQMM990 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2FJDVVQHD1VG,CON_05A5VJKK9T30,10 Volume 13 PRD_2FJDVVQHD1VG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2GSGZWRW52DG,CON_05A5VJKK9T30,10 Volume 2 PRD_2GSGZWRW52DG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2H47DTVYC7AG,CON_05A5VJKK9T30,10 Recollections PRD_2H47DTVYC7AG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2JAF1V5BM110,CON_05A5VJKK9T30,10 Volume 22 PRD_2JAF1V5BM110 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2K9936MZPY60,CON_05A5VJKK9T30,10 Volume 1 PRD_2K9936MZPY60 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2PRZKE7DG000,CON_05A5VJKK9T30,10 Volume 26 PRD_2PRZKE7DG000 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2SRKFH1CTETG,CON_05A5VJKK9T30,10 Volume 5 PRD_2SRKFH1CTETG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2T50B81CN7HG,CON_05A5VJKK9T30,10 Volume 16 PRD_2T50B81CN7HG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2VNXCZ3J74W0,CON_05A5VJKK9T30,10 Volume 7 PRD_2VNXCZ3J74W0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2WC9V8WW4D50,CON_05A5VJKK9T30,10 Volume 24 PRD_2WC9V8WW4D50 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_2Z513Z0Y3NN0,CON_05A5VJKK9T30,10 Volume 11 PRD_2Z513Z0Y3NN0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_32VCZ2D02WV0,CON_05A5VJKK9T30,10 Volume 1 PRD_32VCZ2D02WV0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3BA80ASM8R8G,CON_05A5VJKK9T30,10 Volume 6 PRD_3BA80ASM8R8G Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3BJGH8VGPS2G,CON_05A5VJKK9T30,10 Volume 3 PRD_3BJGH8VGPS2G Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3DX78JT6P2HG,CON_05A5VJKK9T30,10 Volume 25 PRD_3DX78JT6P2HG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3FMF51MKRXNG,CON_05A5VJKK9T30,10 Volume 7 PRD_3FMF51MKRXNG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3FRRKXVYN7FG,CON_05A5VJKK9T30,10 Volume 4 PRD_3FRRKXVYN7FG Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3XC3N44JAYY0,CON_05A5VJKK9T30,10 Volume 2 PRD_3XC3N44JAYY0 Cliff Kirk CON_05A5VJKK9T30 10  
PRD_3YAWCFKY6XM0,CON_05A5VJKK9T30,10 Volume 2 PRD_3YAWCFKY6XM0 Cliff Kirk CON_05A5VJKK9T30 10  

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