BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_37YPZDFBD1R0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04D8YN2YMTYG,CON_37YPZDFBD1R0,1 Volume 16 PRD_04D8YN2YMTYG Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0B6NG94C7Q30,CON_37YPZDFBD1R0,1 Volume 14 PRD_0B6NG94C7Q30 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0FGBVWYAWRWG,CON_37YPZDFBD1R0,1 Volume 7 PRD_0FGBVWYAWRWG Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0K8SP4Q53ET0,CON_37YPZDFBD1R0,1 Volume 10 PRD_0K8SP4Q53ET0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0QS81QHFFDS0,CON_37YPZDFBD1R0,1 Volume 3 PRD_0QS81QHFFDS0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0TFRKAJHBCR0,CON_37YPZDFBD1R0,1 Volume 22 PRD_0TFRKAJHBCR0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_0XJT9GEXKAY0,CON_37YPZDFBD1R0,1 Volume 19 PRD_0XJT9GEXKAY0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_10SQAEDFN26G,CON_37YPZDFBD1R0,1 Volume 18 PRD_10SQAEDFN26G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1BWP0M8VX04G,CON_37YPZDFBD1R0,1 Volume 13 PRD_1BWP0M8VX04G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1D3HXT405EAG,CON_37YPZDFBD1R0,1 Volume 1 PRD_1D3HXT405EAG Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1ED6J7AXSFBG,CON_37YPZDFBD1R0,1 Volume 11 PRD_1ED6J7AXSFBG Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1J6T5FRCS73G,CON_37YPZDFBD1R0,1 Volume 6 PRD_1J6T5FRCS73G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1PQAG2NQ562G,CON_37YPZDFBD1R0,1 Volume 4 PRD_1PQAG2NQ562G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_1STMD8H3D40G,CON_37YPZDFBD1R0,1 Volume 21 PRD_1STMD8H3D40G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_2ATGQZD3JSE0,CON_37YPZDFBD1R0,1 Volume 15 PRD_2ATGQZD3JSE0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_2DSJC59FV7C0,CON_37YPZDFBD1R0,1 Volume 8 PRD_2DSJC59FV7C0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_2HG0FD6A1D9G,CON_37YPZDFBD1R0,1 Volume 23 PRD_2HG0FD6A1D9G Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_2Z5KQ7ZRNAEG,CON_37YPZDFBD1R0,1 Volume 2 PRD_2Z5KQ7ZRNAEG Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_316ZWRWCK2P0,CON_37YPZDFBD1R0,1 Volume 17 PRD_316ZWRWCK2P0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_385YSYVRV0M0,CON_37YPZDFBD1R0,1 Volume 9 PRD_385YSYVRV0M0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_3CT94HN37FV0,CON_37YPZDFBD1R0,1 Volume 12 PRD_3CT94HN37FV0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_3GE2ZRAJ77K0,CON_37YPZDFBD1R0,1 Volume 5 PRD_3GE2ZRAJ77K0 Yumi Hotta CON_37YPZDFBD1R0 1  
PRD_3Y3W7H00B4G0,CON_37YPZDFBD1R0,1 Volume 20 PRD_3Y3W7H00B4G0 Yumi Hotta CON_37YPZDFBD1R0 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.671ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS