BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_01TNX5PS3750"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0259TVKAM8Z0,CON_01TNX5PS3750,1 Volume 5 PRD_0259TVKAM8Z0 NAOE CON_01TNX5PS3750 1  
PRD_033QN1ZSN0Q0,CON_01TNX5PS3750,1 Volume 09 PRD_033QN1ZSN0Q0 NAOE CON_01TNX5PS3750 1  
PRD_06148Q3WA51G,CON_01TNX5PS3750,1 Volume 04 PRD_06148Q3WA51G NAOE CON_01TNX5PS3750 1  
PRD_0AGVJANV3P30,CON_01TNX5PS3750,1 Volume 06 PRD_0AGVJANV3P30 NAOE CON_01TNX5PS3750 1  
PRD_0EGMNSDWJZPG,CON_01TNX5PS3750,1 Volume 10 PRD_0EGMNSDWJZPG NAOE CON_01TNX5PS3750 1  
PRD_0WRZ3GMS8VRG,CON_01TNX5PS3750,1 Volume 07 PRD_0WRZ3GMS8VRG NAOE CON_01TNX5PS3750 1  
PRD_122EEKTMAKTG,CON_01TNX5PS3750,1 Volume 8 PRD_122EEKTMAKTG NAOE CON_01TNX5PS3750 1  
PRD_12GATGATEMS0,CON_01TNX5PS3750,1 Volume 12 PRD_12GATGATEMS0 NAOE CON_01TNX5PS3750 1  
PRD_12ME5JX479CG,CON_01TNX5PS3750,1 Volume 01 PRD_12ME5JX479CG NAOE CON_01TNX5PS3750 1  
PRD_13JM47YR8EJG,CON_01TNX5PS3750,1 Volume 2 PRD_13JM47YR8EJG NAOE CON_01TNX5PS3750 1  
PRD_14PWZXAM9HGG,CON_01TNX5PS3750,1 Volume 11 PRD_14PWZXAM9HGG NAOE CON_01TNX5PS3750 1  
PRD_163HB1QX62B0,CON_01TNX5PS3750,1 Volume 18 PRD_163HB1QX62B0 NAOE CON_01TNX5PS3750 1  
PRD_19M9W69E820G,CON_01TNX5PS3750,1 Volume 08 PRD_19M9W69E820G NAOE CON_01TNX5PS3750 1  
PRD_1AJTSCJSDYK0,CON_01TNX5PS3750,1 Volume 1 PRD_1AJTSCJSDYK0 NAOE CON_01TNX5PS3750 1  
PRD_1DHJAHK4Y2E0,CON_01TNX5PS3750,1 Volume 16 PRD_1DHJAHK4Y2E0 NAOE CON_01TNX5PS3750 1  
PRD_1GY1BEFX03DG,CON_01TNX5PS3750,1 Volume 7 PRD_1GY1BEFX03DG NAOE CON_01TNX5PS3750 1  
PRD_1V2YZRRQFB60,CON_01TNX5PS3750,1 Volume 17 PRD_1V2YZRRQFB60 NAOE CON_01TNX5PS3750 1  
PRD_1Y32JYVPMW80,CON_01TNX5PS3750,1 Volume 02 PRD_1Y32JYVPMW80 NAOE CON_01TNX5PS3750 1  
PRD_221M9JGA5M0G,CON_01TNX5PS3750,1 Volume 13 PRD_221M9JGA5M0G NAOE CON_01TNX5PS3750 1  
PRD_24EC11J185H0,CON_01TNX5PS3750,1 Volume 03 PRD_24EC11J185H0 NAOE CON_01TNX5PS3750 1  
PRD_2E9A81AN0A60,CON_01TNX5PS3750,1 Volume 14 PRD_2E9A81AN0A60 NAOE CON_01TNX5PS3750 1  
PRD_2EZ15TZS3F2G,CON_01TNX5PS3750,1 Volume 15 PRD_2EZ15TZS3F2G NAOE CON_01TNX5PS3750 1  
PRD_2JD40KM7NYPG,CON_01TNX5PS3750,1 Volume 10 PRD_2JD40KM7NYPG NAOE CON_01TNX5PS3750 1  
PRD_2W8HD85JW110,CON_01TNX5PS3750,1 Volume 6 PRD_2W8HD85JW110 NAOE CON_01TNX5PS3750 1  
PRD_3041YKBJWN80,CON_01TNX5PS3750,1 Volume 3 PRD_3041YKBJWN80 NAOE CON_01TNX5PS3750 1  
PRD_3GMF2QQM07K0,CON_01TNX5PS3750,1 Volume 9 PRD_3GMF2QQM07K0 NAOE CON_01TNX5PS3750 1  
PRD_3PGEVD5SR1N0,CON_01TNX5PS3750,1 Volume 05 PRD_3PGEVD5SR1N0 NAOE CON_01TNX5PS3750 1  
PRD_3T986R35ZC00,CON_01TNX5PS3750,1 Volume 4 PRD_3T986R35ZC00 NAOE CON_01TNX5PS3750 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 9.544ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS