BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_05PGT3K8W9Z0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01FNTNYS0NYG,CON_05PGT3K8W9Z0,1 Volume 4 PRD_01FNTNYS0NYG Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_03PK3DG2BVEG,CON_05PGT3K8W9Z0,1 Volume 6 PRD_03PK3DG2BVEG Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_04363EZ8ME50,CON_05PGT3K8W9Z0,1 Volume 11 PRD_04363EZ8ME50 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_0ACKN5486EN0,CON_05PGT3K8W9Z0,1 Volume 8 PRD_0ACKN5486EN0 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_0SG9Y0G00ZQ0,CON_05PGT3K8W9Z0,1 Volume 7 PRD_0SG9Y0G00ZQ0 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_11CPVD57EA80,CON_05PGT3K8W9Z0,1 Volume 1 PRD_11CPVD57EA80 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_11TPSAP8THRG,CON_05PGT3K8W9Z0,1 Volume G1 PRD_11TPSAP8THRG Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_19E7PRP9CFV0,CON_05PGT3K8W9Z0,1 Volume 5 PRD_19E7PRP9CFV0 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_1A7F6CVQTXT0,CON_05PGT3K8W9Z0,1 Volume 3 PRD_1A7F6CVQTXT0 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_24PNHK63MNWG,CON_05PGT3K8W9Z0,1 Volume 9 PRD_24PNHK63MNWG Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_25ZV99PADP40,CON_05PGT3K8W9Z0,1 Volume 1 PRD_25ZV99PADP40 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_38CQRNAMRW9G,CON_05PGT3K8W9Z0,1 Volume 2 PRD_38CQRNAMRW9G Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_3P0AKT4WYZJ0,CON_05PGT3K8W9Z0,1 Volume 10 PRD_3P0AKT4WYZJ0 Sankakuhead CON_05PGT3K8W9Z0 1  
PRD_3XY64X755QPG,CON_05PGT3K8W9Z0,1 Volume 12 PRD_3XY64X755QPG Sankakuhead CON_05PGT3K8W9Z0 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 8.667ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS