BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_0ZE49R86VZYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01Z803TNKMP0,CON_0ZE49R86VZYG,1 Volume 16 PRD_01Z803TNKMP0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_02SV8HVKN2Q0,CON_0ZE49R86VZYG,1 Volume 22 PRD_02SV8HVKN2Q0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_03C03YGEM450,CON_0ZE49R86VZYG,1 Volume 2 PRD_03C03YGEM450 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0AF67839AGFG,CON_0ZE49R86VZYG,1 Volume 7 PRD_0AF67839AGFG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0FZDJFNGC6DG,CON_0ZE49R86VZYG,1 Volume 3 PRD_0FZDJFNGC6DG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0FZX2MGJ13QG,CON_0ZE49R86VZYG,1 Volume 8 PRD_0FZX2MGJ13QG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0JRDB16ZZ1Q0,CON_0ZE49R86VZYG,1 Volume 3 PRD_0JRDB16ZZ1Q0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0PHV9VW7FFPG,CON_0ZE49R86VZYG,1 Volume 10 PRD_0PHV9VW7FFPG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0PNMDPPQ9RVG,CON_0ZE49R86VZYG,1 Volume 11 PRD_0PNMDPPQ9RVG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0PNRZSDGTAE0,CON_0ZE49R86VZYG,1 Volume 20 PRD_0PNRZSDGTAE0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0QR23R69DZTG,CON_0ZE49R86VZYG,1 Volume 6 PRD_0QR23R69DZTG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0S2S6G0XSG50,CON_0ZE49R86VZYG,1 Volume 2 PRD_0S2S6G0XSG50 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_0XJ1D3K1K8P0,CON_0ZE49R86VZYG,1 Volume 11 PRD_0XJ1D3K1K8P0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1AFKT7GKZ4G0,CON_0ZE49R86VZYG,1 Volume 14 PRD_1AFKT7GKZ4G0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1FAMZDYFY840,CON_0ZE49R86VZYG,1 Volume 10 PRD_1FAMZDYFY840 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1PF274VV758G,CON_0ZE49R86VZYG,1 Volume 7 PRD_1PF274VV758G Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1QXG37K09JFG,CON_0ZE49R86VZYG,1 Volume 9 PRD_1QXG37K09JFG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1VR8R6FN1BPG,CON_0ZE49R86VZYG,1 Volume 6 PRD_1VR8R6FN1BPG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1X26XMME74N0,CON_0ZE49R86VZYG,1 Volume 1 PRD_1X26XMME74N0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1XHF828QA9W0,CON_0ZE49R86VZYG,1 Volume 8 PRD_1XHF828QA9W0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_1XQ23NARJ6KG,CON_0ZE49R86VZYG,1 Volume 13 PRD_1XQ23NARJ6KG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_22WBJ3PF6NPG,CON_0ZE49R86VZYG,1 Volume 14 PRD_22WBJ3PF6NPG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2BN747NBYFY0,CON_0ZE49R86VZYG,1 Volume 12 PRD_2BN747NBYFY0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2CM8J60HX5MG,CON_0ZE49R86VZYG,1 Volume 5 PRD_2CM8J60HX5MG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2EK8M9CEJCP0,CON_0ZE49R86VZYG,1 Volume 1 PRD_2EK8M9CEJCP0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2GQRVKJB61H0,CON_0ZE49R86VZYG,1 Volume 21 PRD_2GQRVKJB61H0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2MXWA5PQKWBG,CON_0ZE49R86VZYG,1 Volume 2 PRD_2MXWA5PQKWBG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2NDXWY825A5G,CON_0ZE49R86VZYG,1 Volume 19 PRD_2NDXWY825A5G Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2TCM39FBN280,CON_0ZE49R86VZYG,1 Volume 17 PRD_2TCM39FBN280 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_2WV9NZRAMZN0,CON_0ZE49R86VZYG,1 Volume 13 PRD_2WV9NZRAMZN0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3039N5CYNZK0,CON_0ZE49R86VZYG,1 Volume 12 PRD_3039N5CYNZK0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_367AMAPX961G,CON_0ZE49R86VZYG,1 Volume 4 PRD_367AMAPX961G Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3791ZN9WY140,CON_0ZE49R86VZYG,1 Volume 1 PRD_3791ZN9WY140 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3CEKSV0QZR30,CON_0ZE49R86VZYG,1 Volume 5 PRD_3CEKSV0QZR30 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3FZZ0ZYAZFG0,CON_0ZE49R86VZYG,1 Volume 18 PRD_3FZZ0ZYAZFG0 Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3GVS82H3CXWG,CON_0ZE49R86VZYG,1 Volume 4 PRD_3GVS82H3CXWG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3H2DA64CJSDG,CON_0ZE49R86VZYG,1 Volume 15 PRD_3H2DA64CJSDG Sakon Kaidou CON_0ZE49R86VZYG 1  
PRD_3T4X2C7J5FTG,CON_0ZE49R86VZYG,1 Volume 9 PRD_3T4X2C7J5FTG Sakon Kaidou CON_0ZE49R86VZYG 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 10.984ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS