BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_0HF8YG7MXYR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03XHSETAD4NG,CON_0HF8YG7MXYR0,1 Volume 20 PRD_03XHSETAD4NG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_083M1AJE790G,CON_0HF8YG7MXYR0,1 Volume 31 PRD_083M1AJE790G Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_09H317KRH1TG,CON_0HF8YG7MXYR0,1 Volume 1 PRD_09H317KRH1TG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_0G8NF54J9YX0,CON_0HF8YG7MXYR0,1 Volume 16 PRD_0G8NF54J9YX0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_0MS5TR6MNXW0,CON_0HF8YG7MXYR0,1 Volume 19 PRD_0MS5TR6MNXW0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_0VFM4B0YHW30,CON_0HF8YG7MXYR0,1 Volume 6 PRD_0VFM4B0YHW30 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_0ZF1FVR015PG,CON_0HF8YG7MXYR0,1 Volume 5 PRD_0ZF1FVR015PG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_0ZW4QY20XV20,CON_0HF8YG7MXYR0,1 Volume 25 PRD_0ZW4QY20XV20 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_10V8A1S6GSF0,CON_0HF8YG7MXYR0,1 Volume 35 PRD_10V8A1S6GSF0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_14FKE3WZ7H8G,CON_0HF8YG7MXYR0,1 Volume 3 PRD_14FKE3WZ7H8G Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_15QQPXB7HZT0,CON_0HF8YG7MXYR0,1 Volume 11 PRD_15QQPXB7HZT0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_18W3SPY13GFG,CON_0HF8YG7MXYR0,1 Volume 23 PRD_18W3SPY13GFG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_1RWQVDEEMWAG,CON_0HF8YG7MXYR0,1 Volume 27 PRD_1RWQVDEEMWAG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_1X1A1VHM2Q7G,CON_0HF8YG7MXYR0,1 Volume 13 PRD_1X1A1VHM2Q7G Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_1X479WS79550,CON_0HF8YG7MXYR0,1 Volume 12 PRD_1X479WS79550 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_1Y9W664VDCXG,CON_0HF8YG7MXYR0,1 Volume 15 PRD_1Y9W664VDCXG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_20ASKQ5FB350,CON_0HF8YG7MXYR0,1 Volume 21 PRD_20ASKQ5FB350 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_275XXD16XBJ0,CON_0HF8YG7MXYR0,1 Volume 14 PRD_275XXD16XBJ0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_28ZP8T66CSX0,CON_0HF8YG7MXYR0,1 Volume 24 PRD_28ZP8T66CSX0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2ATXM1DW3KXG,CON_0HF8YG7MXYR0,1 Volume 34 PRD_2ATXM1DW3KXG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2J32PWTDBYDG,CON_0HF8YG7MXYR0,1 Volume 9 PRD_2J32PWTDBYDG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2K4MPPSAZESG,CON_0HF8YG7MXYR0,1 Volume 26 PRD_2K4MPPSAZESG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2KDGY519SK0G,CON_0HF8YG7MXYR0,1 Volume 1 PRD_2KDGY519SK0G Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2N6DK2HSKXKG,CON_0HF8YG7MXYR0,1 Volume 7 PRD_2N6DK2HSKXKG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2P0ZRBDPV710,CON_0HF8YG7MXYR0,1 Volume 2 PRD_2P0ZRBDPV710 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2PHX0FQQQXCG,CON_0HF8YG7MXYR0,1 Volume 28 PRD_2PHX0FQQQXCG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2SMWYNK3ZWJG,CON_0HF8YG7MXYR0,1 Volume 22 PRD_2SMWYNK3ZWJG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2W5F88D5VVHG,CON_0HF8YG7MXYR0,1 Volume 8 PRD_2W5F88D5VVHG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_2XM904B5F460,CON_0HF8YG7MXYR0,1 Volume 4 PRD_2XM904B5F460 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_33DF2584Q5MG,CON_0HF8YG7MXYR0,1 Volume 10 PRD_33DF2584Q5MG Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_3668NSDSSJS0,CON_0HF8YG7MXYR0,1 Volume 18 PRD_3668NSDSSJS0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_395BJZ961GZ0,CON_0HF8YG7MXYR0,1 Volume 29 PRD_395BJZ961GZ0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_3DVTXJB8DZY0,CON_0HF8YG7MXYR0,1 Volume 17 PRD_3DVTXJB8DZY0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_3JSF57YN18Q0,CON_0HF8YG7MXYR0,1 Volume 30 PRD_3JSF57YN18Q0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_3MPP76PGYSQ0,CON_0HF8YG7MXYR0,1 Volume 32 PRD_3MPP76PGYSQ0 Yoshiaki Sukeno CON_0HF8YG7MXYR0 1  
PRD_3P0VW44ZAE7G,CON_0HF8YG7MXYR0,1 Volume 33 PRD_3P0VW44ZAE7G Yoshiaki Sukeno CON_0HF8YG7MXYR0 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.522ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS