BookWalker

home / database

product_contributors

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

34 rows where contributor_id = "CON_0WDJZWPT03XG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_070H94Q7RF5G,CON_0WDJZWPT03XG,1 Volume 5 PRD_070H94Q7RF5G Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_09D3K82F2530,CON_0WDJZWPT03XG,2 Volume 12 PRD_09D3K82F2530 Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_09D3K82F2530,CON_0WDJZWPT03XG,24 Volume 12 PRD_09D3K82F2530 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_0CAFTPGD9BKG,CON_0WDJZWPT03XG,24 Volume 5 PRD_0CAFTPGD9BKG Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_0DGRGAJT3TSG,CON_0WDJZWPT03XG,2 Volume 18 PRD_0DGRGAJT3TSG Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_0DGRGAJT3TSG,CON_0WDJZWPT03XG,24 Volume 18 PRD_0DGRGAJT3TSG Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_0F307GM85CK0,CON_0WDJZWPT03XG,24 Volume 7 PRD_0F307GM85CK0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_0NYQCKK0H040,CON_0WDJZWPT03XG,1 Volume 8 PRD_0NYQCKK0H040 Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_0W0GB4Y0VVF0,CON_0WDJZWPT03XG,24 Volume 1 PRD_0W0GB4Y0VVF0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_0Z3M177NPQE0,CON_0WDJZWPT03XG,24 Volume 8 PRD_0Z3M177NPQE0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_11G7SVHN6TQ0,CON_0WDJZWPT03XG,1 Volume 4 PRD_11G7SVHN6TQ0 Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_1262YF85952G,CON_0WDJZWPT03XG,24 Volume 6 PRD_1262YF85952G Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_1BDV3VH3TSMG,CON_0WDJZWPT03XG,1 Volume 6 PRD_1BDV3VH3TSMG Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_1E1ZCTPCWZHG,CON_0WDJZWPT03XG,2 Volume 15 PRD_1E1ZCTPCWZHG Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_1E1ZCTPCWZHG,CON_0WDJZWPT03XG,24 Volume 15 PRD_1E1ZCTPCWZHG Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_1FN845C07ZFG,CON_0WDJZWPT03XG,2 Volume 17 PRD_1FN845C07ZFG Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_1FN845C07ZFG,CON_0WDJZWPT03XG,24 Volume 17 PRD_1FN845C07ZFG Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_2109V8C1QVDG,CON_0WDJZWPT03XG,1 Volume 1 PRD_2109V8C1QVDG Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_29GE8XJ4ET8G,CON_0WDJZWPT03XG,24 Volume 10 PRD_29GE8XJ4ET8G Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_2DGSHQW9MB80,CON_0WDJZWPT03XG,2 Volume 13 PRD_2DGSHQW9MB80 Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_2DGSHQW9MB80,CON_0WDJZWPT03XG,24 Volume 13 PRD_2DGSHQW9MB80 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_2PHG3DQQ74X0,CON_0WDJZWPT03XG,2 Volume 16 PRD_2PHG3DQQ74X0 Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_2PHG3DQQ74X0,CON_0WDJZWPT03XG,24 Volume 16 PRD_2PHG3DQQ74X0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_2PSP6YCGFV5G,CON_0WDJZWPT03XG,1 Volume 3 PRD_2PSP6YCGFV5G Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_2YK3XY5TC5B0,CON_0WDJZWPT03XG,24 Volume 11 PRD_2YK3XY5TC5B0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_310W677BNF2G,CON_0WDJZWPT03XG,2 Volume 14 PRD_310W677BNF2G Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_310W677BNF2G,CON_0WDJZWPT03XG,24 Volume 14 PRD_310W677BNF2G Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_31W8319HTYV0,CON_0WDJZWPT03XG,24 Volume 3 PRD_31W8319HTYV0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_32CH87BSZG2G,CON_0WDJZWPT03XG,24 Volume 4 PRD_32CH87BSZG2G Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_36Z32CCVAPXG,CON_0WDJZWPT03XG,1 Volume 2 PRD_36Z32CCVAPXG Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_36Z32CCVAPXG,CON_0WDJZWPT03XG,2 Volume 2 PRD_36Z32CCVAPXG Ren Kawahara CON_0WDJZWPT03XG 2  
PRD_3HAMS0X86QM0,CON_0WDJZWPT03XG,24 Volume 2 PRD_3HAMS0X86QM0 Ren Kawahara CON_0WDJZWPT03XG 24  
PRD_3NZ0WEB3QRPG,CON_0WDJZWPT03XG,1 Volume 7 PRD_3NZ0WEB3QRPG Ren Kawahara CON_0WDJZWPT03XG 1  
PRD_3Y2CMJT1NWEG,CON_0WDJZWPT03XG,24 Volume 9 PRD_3Y2CMJT1NWEG Ren Kawahara CON_0WDJZWPT03XG 24  

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.839ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS