BookWalker

home / database

product_contributors

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

26 rows where contributor_id = "CON_19CSPTXPFN4G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_024J4D509P90,CON_19CSPTXPFN4G,2 Volume 2 PRD_024J4D509P90 cura CON_19CSPTXPFN4G 2  
PRD_083X999EA9M0,CON_19CSPTXPFN4G,2 Volume 9 PRD_083X999EA9M0 cura CON_19CSPTXPFN4G 2  
PRD_0D7B8SY8660G,CON_19CSPTXPFN4G,2 Volume 6 PRD_0D7B8SY8660G cura CON_19CSPTXPFN4G 2  
PRD_0NDKZGYJ0F7G,CON_19CSPTXPFN4G,2 Volume 12 PRD_0NDKZGYJ0F7G cura CON_19CSPTXPFN4G 2  
PRD_0QPJ0VWJQDR0,CON_19CSPTXPFN4G,2 Volume 6 PRD_0QPJ0VWJQDR0 cura CON_19CSPTXPFN4G 2  
PRD_0TCEVX6VXH60,CON_19CSPTXPFN4G,2 Volume 18 PRD_0TCEVX6VXH60 cura CON_19CSPTXPFN4G 2  
PRD_0TJPRDTXEKD0,CON_19CSPTXPFN4G,2 Volume 17 PRD_0TJPRDTXEKD0 cura CON_19CSPTXPFN4G 2  
PRD_0Y53X917DXXG,CON_19CSPTXPFN4G,2 Volume 4 PRD_0Y53X917DXXG cura CON_19CSPTXPFN4G 2  
PRD_1F58SNGB470G,CON_19CSPTXPFN4G,2 Volume 7 PRD_1F58SNGB470G cura CON_19CSPTXPFN4G 2  
PRD_1PVP9X60P8Y0,CON_19CSPTXPFN4G,2 Volume 13 PRD_1PVP9X60P8Y0 cura CON_19CSPTXPFN4G 2  
PRD_1PY6CW9KCCC0,CON_19CSPTXPFN4G,2 Volume 11 PRD_1PY6CW9KCCC0 cura CON_19CSPTXPFN4G 2  
PRD_1VED27D0RNFG,CON_19CSPTXPFN4G,2 Volume 8 PRD_1VED27D0RNFG cura CON_19CSPTXPFN4G 2  
PRD_1VKGWY7G5VDG,CON_19CSPTXPFN4G,2 Volume 1 PRD_1VKGWY7G5VDG cura CON_19CSPTXPFN4G 2  
PRD_20M6ACD7XG00,CON_19CSPTXPFN4G,2 Volume 5 PRD_20M6ACD7XG00 cura CON_19CSPTXPFN4G 2  
PRD_29ZXN3KE5FSG,CON_19CSPTXPFN4G,2 Volume 19 PRD_29ZXN3KE5FSG cura CON_19CSPTXPFN4G 2  
PRD_2A2T9XQ5HAJ0,CON_19CSPTXPFN4G,2 Volume 4 PRD_2A2T9XQ5HAJ0 cura CON_19CSPTXPFN4G 2  
PRD_2GGGS9FWH3AG,CON_19CSPTXPFN4G,2 Volume 2 PRD_2GGGS9FWH3AG cura CON_19CSPTXPFN4G 2  
PRD_2RB9Q1JBBZKG,CON_19CSPTXPFN4G,2 Volume 10 PRD_2RB9Q1JBBZKG cura CON_19CSPTXPFN4G 2  
PRD_2VR1JWBWCF2G,CON_19CSPTXPFN4G,2 Volume 1 PRD_2VR1JWBWCF2G cura CON_19CSPTXPFN4G 2  
PRD_35875D2EGKPG,CON_19CSPTXPFN4G,2 Volume 16 PRD_35875D2EGKPG cura CON_19CSPTXPFN4G 2  
PRD_35GEM7VA40X0,CON_19CSPTXPFN4G,2 Volume 5 PRD_35GEM7VA40X0 cura CON_19CSPTXPFN4G 2  
PRD_3DBW93KK773G,CON_19CSPTXPFN4G,2 Volume 15 PRD_3DBW93KK773G cura CON_19CSPTXPFN4G 2  
PRD_3J7BKHS7CQFG,CON_19CSPTXPFN4G,2 Volume 14 PRD_3J7BKHS7CQFG cura CON_19CSPTXPFN4G 2  
PRD_3NZ5MPHW85Y0,CON_19CSPTXPFN4G,2 Volume 20 PRD_3NZ5MPHW85Y0 cura CON_19CSPTXPFN4G 2  
PRD_3PW55QGBE76G,CON_19CSPTXPFN4G,2 Volume 3 PRD_3PW55QGBE76G cura CON_19CSPTXPFN4G 2  
PRD_3TNVJPECC2MG,CON_19CSPTXPFN4G,2 Volume 3 PRD_3TNVJPECC2MG cura CON_19CSPTXPFN4G 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 12.917ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS