BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_1WA16HP2RB40"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02H0AJ7PC86G,CON_1WA16HP2RB40,1 Volume 7 PRD_02H0AJ7PC86G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_049F5TPD3830,CON_1WA16HP2RB40,1 Volume 16 PRD_049F5TPD3830 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_04FDX8ENGH70,CON_1WA16HP2RB40,1 Volume 19 PRD_04FDX8ENGH70 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_05M37R32MP4G,CON_1WA16HP2RB40,1 Volume 10 PRD_05M37R32MP4G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_0VJ1CC8A4A0G,CON_1WA16HP2RB40,1 Volume 11 PRD_0VJ1CC8A4A0G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_0Y0HZZAC097G,CON_1WA16HP2RB40,1 Volume 9 PRD_0Y0HZZAC097G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_10CZR8QRTQ60,CON_1WA16HP2RB40,1 Volume 14 PRD_10CZR8QRTQ60 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_117QG0X0MZGG,CON_1WA16HP2RB40,1 Volume 22 PRD_117QG0X0MZGG Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_1FHCK93PJDC0,CON_1WA16HP2RB40,1 Volume 12 PRD_1FHCK93PJDC0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_1P1KGC5KFV20,CON_1WA16HP2RB40,1 Volume 23 PRD_1P1KGC5KFV20 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_20Y83WPVA8P0,CON_1WA16HP2RB40,1 Volume 1 PRD_20Y83WPVA8P0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_25G8VH02JCXG,CON_1WA16HP2RB40,1 Volume 20 PRD_25G8VH02JCXG Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_27CVDFGXPQN0,CON_1WA16HP2RB40,1 Volume 3 PRD_27CVDFGXPQN0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2BXBR2J7JPM0,CON_1WA16HP2RB40,1 Volume 4 PRD_2BXBR2J7JPM0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2Q3S7WGSRWT0,CON_1WA16HP2RB40,1 Volume 21 PRD_2Q3S7WGSRWT0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2R942EFK5ECG,CON_1WA16HP2RB40,1 Volume 13 PRD_2R942EFK5ECG Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2SV96PVF2AG0,CON_1WA16HP2RB40,1 Volume 2 PRD_2SV96PVF2AG0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2W9SG9MHE9Q0,CON_1WA16HP2RB40,1 Volume 8 PRD_2W9SG9MHE9Q0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_2Y9RA0Z3WKW0,CON_1WA16HP2RB40,1 Volume 15 PRD_2Y9RA0Z3WKW0 Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_31JMC8FZ052G,CON_1WA16HP2RB40,1 Volume 17 PRD_31JMC8FZ052G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_3984T0GHMEWG,CON_1WA16HP2RB40,1 Volume 6 PRD_3984T0GHMEWG Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_3DYQ5KJVGD3G,CON_1WA16HP2RB40,1 Volume 5 PRD_3DYQ5KJVGD3G Hitsuji Gondaira CON_1WA16HP2RB40 1  
PRD_3WG88X4NJ7KG,CON_1WA16HP2RB40,1 Volume 18 PRD_3WG88X4NJ7KG Hitsuji Gondaira CON_1WA16HP2RB40 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.504ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS