BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_2XM9DEJ3YH90"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04ZXYSWKV24G,CON_2XM9DEJ3YH90,1 Volume 8 PRD_04ZXYSWKV24G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0BCC8CYP71BG,CON_2XM9DEJ3YH90,1 Volume 5 PRD_0BCC8CYP71BG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0E2WVZRR30AG,CON_2XM9DEJ3YH90,1 Volume 4 PRD_0E2WVZRR30AG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0KN2P7HT9P00,CON_2XM9DEJ3YH90,1 Volume 14 PRD_0KN2P7HT9P00 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0KPGE6EF2R2G,CON_2XM9DEJ3YH90,1 Volume 30 PRD_0KPGE6EF2R2G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0MK4TQGJF300,CON_2XM9DEJ3YH90,1 Volume 5 PRD_0MK4TQGJF300 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0P0QHR05R9W0,CON_2XM9DEJ3YH90,1 Volume 11 PRD_0P0QHR05R9W0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_0P70SSBHF71G,CON_2XM9DEJ3YH90,1 Volume 12 PRD_0P70SSBHF71G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_17HD53Y8AD8G,CON_2XM9DEJ3YH90,1 Volume 21 PRD_17HD53Y8AD8G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_17R8N4977AKG,CON_2XM9DEJ3YH90,1 Volume 2 PRD_17R8N4977AKG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1AEV0QB939JG,CON_2XM9DEJ3YH90,1 Volume 18 PRD_1AEV0QB939JG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1DDTXX6NBQGG,CON_2XM9DEJ3YH90,1 Volume 13 PRD_1DDTXX6NBQGG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1H1ZG5M4BE8G,CON_2XM9DEJ3YH90,1 Volume 28 PRD_1H1ZG5M4BE8G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1NPE3RPEQDFG,CON_2XM9DEJ3YH90,1 Volume 26 PRD_1NPE3RPEQDFG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1R4SDBKGKCEG,CON_2XM9DEJ3YH90,1 Volume 25 PRD_1R4SDBKGKCEG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_1WN9RYDTZBDG,CON_2XM9DEJ3YH90,1 Volume 23 PRD_1WN9RYDTZBDG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_221TTWG4H4P0,CON_2XM9DEJ3YH90,1 Volume 22 PRD_221TTWG4H4P0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2575Q2FGS2M0,CON_2XM9DEJ3YH90,1 Volume 7 PRD_2575Q2FGS2M0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_26PN4FJEX3N0,CON_2XM9DEJ3YH90,1 Volume 9 PRD_26PN4FJEX3N0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_29NM2N9V51V0,CON_2XM9DEJ3YH90,1 Volume 6 PRD_29NM2N9V51V0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2C7A473HTJMG,CON_2XM9DEJ3YH90,1 Volume 16 PRD_2C7A473HTJMG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2CA7C8BX10T0,CON_2XM9DEJ3YH90,1 Volume 31 PRD_2CA7C8BX10T0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2KA5ZZTHBBVG,CON_2XM9DEJ3YH90,1 Volume 1 PRD_2KA5ZZTHBBVG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2MK5T321KNPG,CON_2XM9DEJ3YH90,1 Volume 10 PRD_2MK5T321KNPG Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2V2VXPMR96G0,CON_2XM9DEJ3YH90,1 Volume 1 PRD_2V2VXPMR96G0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2Y5871QH6YE0,CON_2XM9DEJ3YH90,1 Volume 3 PRD_2Y5871QH6YE0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_2ZH80QFB2EV0,CON_2XM9DEJ3YH90,1 Volume 2 PRD_2ZH80QFB2EV0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_31K0WVY1SAW0,CON_2XM9DEJ3YH90,1 Volume 20 PRD_31K0WVY1SAW0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_341KEER45930,CON_2XM9DEJ3YH90,1 Volume 19 PRD_341KEER45930 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_38P3S1TE1820,CON_2XM9DEJ3YH90,1 Volume 17 PRD_38P3S1TE1820 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3F01WKC56S3G,CON_2XM9DEJ3YH90,1 Volume 15 PRD_3F01WKC56S3G Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3GRQZV57DFS0,CON_2XM9DEJ3YH90,1 Volume 3 PRD_3GRQZV57DFS0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3Q969E799ER0,CON_2XM9DEJ3YH90,1 Volume 29 PRD_3Q969E799ER0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3VZPM10KNDZ0,CON_2XM9DEJ3YH90,1 Volume 27 PRD_3VZPM10KNDZ0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3YC17M2NHCY0,CON_2XM9DEJ3YH90,1 Volume 24 PRD_3YC17M2NHCY0 Satoru Noda CON_2XM9DEJ3YH90 1  
PRD_3YTV23FM7R20,CON_2XM9DEJ3YH90,1 Volume 4 PRD_3YTV23FM7R20 Satoru Noda CON_2XM9DEJ3YH90 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 11.53ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS