BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_36SHSHGKD370"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_02CZH222ZHGG,CON_36SHSHGKD370,24 Volume 1 PRD_02CZH222ZHGG Hisashi Kakoyama CON_36SHSHGKD370 24  
PRD_0MB7PTDQ4WH0,CON_36SHSHGKD370,2 Volume 3 PRD_0MB7PTDQ4WH0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_0QF71MPSS5K0,CON_36SHSHGKD370,2 Volume 14 PRD_0QF71MPSS5K0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_0XBQGF06KE7G,CON_36SHSHGKD370,2 Volume 16 PRD_0XBQGF06KE7G Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_0YR7YV08QWD0,CON_36SHSHGKD370,2 Volume 7 PRD_0YR7YV08QWD0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_11TW3EP9R4ZG,CON_36SHSHGKD370,2 Volume 9 PRD_11TW3EP9R4ZG Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_1JF2DP9GXXE0,CON_36SHSHGKD370,2 Volume 15 PRD_1JF2DP9GXXE0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_1KSBKWNCAF20,CON_36SHSHGKD370,2 Volume 13 PRD_1KSBKWNCAF20 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_1RJB39ASNMG0,CON_36SHSHGKD370,2 Volume 10 PRD_1RJB39ASNMG0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_1RV0TPQZBP4G,CON_36SHSHGKD370,2 Volume 12 PRD_1RV0TPQZBP4G Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_24SASPTSTHC0,CON_36SHSHGKD370,2 Volume 8 PRD_24SASPTSTHC0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_3046RRCKPSVG,CON_36SHSHGKD370,2 Volume 11 PRD_3046RRCKPSVG Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_340ZQWJ0S4E0,CON_36SHSHGKD370,2 Volume 18 PRD_340ZQWJ0S4E0 Hisashi Kakoyama CON_36SHSHGKD370 2  
PRD_3F2511Q38DRG,CON_36SHSHGKD370,24 Volume 2 PRD_3F2511Q38DRG Hisashi Kakoyama CON_36SHSHGKD370 24  
PRD_3RMKPA2X1000,CON_36SHSHGKD370,2 Volume 17 PRD_3RMKPA2X1000 Hisashi Kakoyama CON_36SHSHGKD370 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 10.339ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS