BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_3510V1FPY5BG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0F4Q07EZEJH0,CON_3510V1FPY5BG,2 Volume 10 PRD_0F4Q07EZEJH0 Jaian CON_3510V1FPY5BG 2  
PRD_0G8MD03HZBHG,CON_3510V1FPY5BG,2 Volume 8 PRD_0G8MD03HZBHG Jaian CON_3510V1FPY5BG 2  
PRD_0K4ECYAS2C90,CON_3510V1FPY5BG,2 Volume 7 PRD_0K4ECYAS2C90 Jaian CON_3510V1FPY5BG 2  
PRD_10ZYESZGFH20,CON_3510V1FPY5BG,2 Volume 4 PRD_10ZYESZGFH20 Jaian CON_3510V1FPY5BG 2  
PRD_18441908JHY0,CON_3510V1FPY5BG,2 Volume 2 PRD_18441908JHY0 Jaian CON_3510V1FPY5BG 2  
PRD_1NZ841NCPPVG,CON_3510V1FPY5BG,2 Volume 6 PRD_1NZ841NCPPVG Jaian CON_3510V1FPY5BG 2  
PRD_20JSMF79V78G,CON_3510V1FPY5BG,2 Volume 14 PRD_20JSMF79V78G Jaian CON_3510V1FPY5BG 2  
PRD_21AZQNCMTS7G,CON_3510V1FPY5BG,2 Volume 1 PRD_21AZQNCMTS7G Jaian CON_3510V1FPY5BG 2  
PRD_21WVHHJ4A6XG,CON_3510V1FPY5BG,2 Volume 12 PRD_21WVHHJ4A6XG Jaian CON_3510V1FPY5BG 2  
PRD_26WM4Q4JASC0,CON_3510V1FPY5BG,12 Volume 1-2 PRD_26WM4Q4JASC0 Jaian CON_3510V1FPY5BG 12  
PRD_2KFH1N80VGD0,CON_3510V1FPY5BG,2 Volume 13 PRD_2KFH1N80VGD0 Jaian CON_3510V1FPY5BG 2  
PRD_3GKTBCQ1DJ8G,CON_3510V1FPY5BG,2 Volume 5 PRD_3GKTBCQ1DJ8G Jaian CON_3510V1FPY5BG 2  
PRD_3QHZ86P5PTDG,CON_3510V1FPY5BG,2 Volume 3 PRD_3QHZ86P5PTDG Jaian CON_3510V1FPY5BG 2  
PRD_3TESHR94MK9G,CON_3510V1FPY5BG,2 Volume 11 PRD_3TESHR94MK9G Jaian CON_3510V1FPY5BG 2  
PRD_3WDEQKXFKSRG,CON_3510V1FPY5BG,2 Volume 9 PRD_3WDEQKXFKSRG Jaian CON_3510V1FPY5BG 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 8.603ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS