BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_21DW67HK7X6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_071GBTX427SG,CON_21DW67HK7X6G,1 Volume 6 PRD_071GBTX427SG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_0J3RDDSZ4CSG,CON_21DW67HK7X6G,1 Volume 4 PRD_0J3RDDSZ4CSG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_0TEG893JS4A0,CON_21DW67HK7X6G,1 Volume 11 PRD_0TEG893JS4A0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_0W5T0SGQM8XG,CON_21DW67HK7X6G,1 Volume 2 PRD_0W5T0SGQM8XG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_0XVBYJP10XGG,CON_21DW67HK7X6G,1 Volume 7 PRD_0XVBYJP10XGG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_13MT0MYKZB4G,CON_21DW67HK7X6G,1 Volume 1 PRD_13MT0MYKZB4G Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_1D2ETTN1K7MG,CON_21DW67HK7X6G,1 Volume 12 PRD_1D2ETTN1K7MG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_1EAGZ580XWJG,CON_21DW67HK7X6G,1 Volume 16 PRD_1EAGZ580XWJG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_1KX6TD130180,CON_21DW67HK7X6G,1 Volume 14 PRD_1KX6TD130180 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_1NJAGQZWY8M0,CON_21DW67HK7X6G,1 Volume 10 PRD_1NJAGQZWY8M0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_1PKH5035C0F0,CON_21DW67HK7X6G,1 Volume 13 PRD_1PKH5035C0F0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_213X4PXYYPC0,CON_21DW67HK7X6G,1 Volume 3 PRD_213X4PXYYPC0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_26WTTHNJANFG,CON_21DW67HK7X6G,1 Volume 3 PRD_26WTTHNJANFG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_2GB07P8W2B90,CON_21DW67HK7X6G,1 Volume 5 PRD_2GB07P8W2B90 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_2MW7Q6DGQNEG,CON_21DW67HK7X6G,1 Volume 2 PRD_2MW7Q6DGQNEG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_2NDS7V71VG9G,CON_21DW67HK7X6G,1 Volume 17 PRD_2NDS7V71VG9G Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_2P7DW3G09ZM0,CON_21DW67HK7X6G,1 Volume 20 PRD_2P7DW3G09ZM0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_2ZJ3487W2X10,CON_21DW67HK7X6G,1 Volume 8 PRD_2ZJ3487W2X10 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_34EE6K08GFMG,CON_21DW67HK7X6G,1 Volume 1 PRD_34EE6K08GFMG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3K17CXDATJKG,CON_21DW67HK7X6G,1 Volume 4 PRD_3K17CXDATJKG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3MMCP9AZ7JS0,CON_21DW67HK7X6G,1 Volume 15 PRD_3MMCP9AZ7JS0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3QGTPF71G2D0,CON_21DW67HK7X6G,1 Volume 5 PRD_3QGTPF71G2D0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3RHCHRTN0CF0,CON_21DW67HK7X6G,1 Volume 19 PRD_3RHCHRTN0CF0 Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3VVX90E1WQBG,CON_21DW67HK7X6G,1 Volume 9 PRD_3VVX90E1WQBG Mine Yoshizaki CON_21DW67HK7X6G 1  
PRD_3Z7Z3BMZCBE0,CON_21DW67HK7X6G,1 Volume 18 PRD_3Z7Z3BMZCBE0 Mine Yoshizaki CON_21DW67HK7X6G 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.048ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS