BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_2SG8VNNVD4P0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0520AZXKJ3Y0,CON_2SG8VNNVD4P0,2 Volume 6 PRD_0520AZXKJ3Y0 Yappen CON_2SG8VNNVD4P0 2  
PRD_06KVW2SC2310,CON_2SG8VNNVD4P0,2 Volume 9 PRD_06KVW2SC2310 Yappen CON_2SG8VNNVD4P0 2  
PRD_073PFE93Y8HG,CON_2SG8VNNVD4P0,2 Volume 1 PRD_073PFE93Y8HG Yappen CON_2SG8VNNVD4P0 2  
PRD_0J4JVXMKZW60,CON_2SG8VNNVD4P0,2 Volume 3 PRD_0J4JVXMKZW60 Yappen CON_2SG8VNNVD4P0 2  
PRD_0M1JWM2ZACF0,CON_2SG8VNNVD4P0,2 Volume 2 PRD_0M1JWM2ZACF0 Yappen CON_2SG8VNNVD4P0 2  
PRD_0PD5PX2VZBSG,CON_2SG8VNNVD4P0,2 Volume 8 PRD_0PD5PX2VZBSG Yappen CON_2SG8VNNVD4P0 2  
PRD_1B7C4N9ZC330,CON_2SG8VNNVD4P0,2 Volume 9 PRD_1B7C4N9ZC330 Yappen CON_2SG8VNNVD4P0 2  
PRD_1HXADZYJGX10,CON_2SG8VNNVD4P0,2 Volume 5 PRD_1HXADZYJGX10 Yappen CON_2SG8VNNVD4P0 2  
PRD_1JVZWAEXSWBG,CON_2SG8VNNVD4P0,2 Volume 4 PRD_1JVZWAEXSWBG Yappen CON_2SG8VNNVD4P0 2  
PRD_1QADTVJD02NG,CON_2SG8VNNVD4P0,2 Volume 7 PRD_1QADTVJD02NG Yappen CON_2SG8VNNVD4P0 2  
PRD_1X17QRTTY4D0,CON_2SG8VNNVD4P0,2 Volume 7 PRD_1X17QRTTY4D0 Yappen CON_2SG8VNNVD4P0 2  
PRD_1Y0CCK1TYMW0,CON_2SG8VNNVD4P0,2 Volume 2 PRD_1Y0CCK1TYMW0 Yappen CON_2SG8VNNVD4P0 2  
PRD_218A22EWM90G,CON_2SG8VNNVD4P0,2 Volume 3 PRD_218A22EWM90G Yappen CON_2SG8VNNVD4P0 2  
PRD_2TC8RCGBYW40,CON_2SG8VNNVD4P0,2 Volume 1 PRD_2TC8RCGBYW40 Yappen CON_2SG8VNNVD4P0 2  
PRD_31CWWSDPSWJ0,CON_2SG8VNNVD4P0,2 Volume 8 PRD_31CWWSDPSWJ0 Yappen CON_2SG8VNNVD4P0 2  
PRD_31KGHVG303TG,CON_2SG8VNNVD4P0,2 Volume 7 PRD_31KGHVG303TG Yappen CON_2SG8VNNVD4P0 2  
PRD_32MNF2EM9E20,CON_2SG8VNNVD4P0,2 Volume 3 PRD_32MNF2EM9E20 Yappen CON_2SG8VNNVD4P0 2  
PRD_33F88JE3F850,CON_2SG8VNNVD4P0,2 Volume 1 PRD_33F88JE3F850 Yappen CON_2SG8VNNVD4P0 2  
PRD_3EF4N4Z4FY6G,CON_2SG8VNNVD4P0,2 Volume 4 PRD_3EF4N4Z4FY6G Yappen CON_2SG8VNNVD4P0 2  
PRD_3HCTMDX3DME0,CON_2SG8VNNVD4P0,2 Volume 5 PRD_3HCTMDX3DME0 Yappen CON_2SG8VNNVD4P0 2  
PRD_3J58BZPFXHKG,CON_2SG8VNNVD4P0,2 Volume 10 PRD_3J58BZPFXHKG Yappen CON_2SG8VNNVD4P0 2  
PRD_3M34FF2DCXA0,CON_2SG8VNNVD4P0,2 Volume 8 PRD_3M34FF2DCXA0 Yappen CON_2SG8VNNVD4P0 2  
PRD_3SWBTW443Q70,CON_2SG8VNNVD4P0,2 Volume 2 PRD_3SWBTW443Q70 Yappen CON_2SG8VNNVD4P0 2  
PRD_3V9QK1CDQJWG,CON_2SG8VNNVD4P0,2 Volume 6 PRD_3V9QK1CDQJWG Yappen CON_2SG8VNNVD4P0 2  
PRD_3WSZXEBNG5XG,CON_2SG8VNNVD4P0,2 Volume 6 PRD_3WSZXEBNG5XG Yappen CON_2SG8VNNVD4P0 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 9.16ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS