BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_1G8RBC73NGX0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_019BY9AGX6PG,CON_1G8RBC73NGX0,1 Chapter 10 PRD_019BY9AGX6PG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_01SHJR2E3YH0,CON_1G8RBC73NGX0,1 Chapter 4 PRD_01SHJR2E3YH0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_0JMJ6DH8ZMD0,CON_1G8RBC73NGX0,1 Chapter 14 PRD_0JMJ6DH8ZMD0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_10A6PNQBSDXG,CON_1G8RBC73NGX0,1 Chapter 9 PRD_10A6PNQBSDXG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_178ZMQ8B84Z0,CON_1G8RBC73NGX0,1 Chapter 2 PRD_178ZMQ8B84Z0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_1CFAD36BHNXG,CON_1G8RBC73NGX0,1 Chapter 15 PRD_1CFAD36BHNXG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_1W5WZHCZ06S0,CON_1G8RBC73NGX0,1 Chapter 6 PRD_1W5WZHCZ06S0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_1XNPB2N1XEYG,CON_1G8RBC73NGX0,1 Chapter 12 PRD_1XNPB2N1XEYG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_2A7226QR7450,CON_1G8RBC73NGX0,1 Chapter 7 PRD_2A7226QR7450 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_2GXTRP0DXMWG,CON_1G8RBC73NGX0,1 Chapter 13 PRD_2GXTRP0DXMWG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_313Q2ES6A4FG,CON_1G8RBC73NGX0,1 Chapter 3 PRD_313Q2ES6A4FG Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_322YWB46VDE0,CON_1G8RBC73NGX0,1 Chapter 11 PRD_322YWB46VDE0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_32D4GVZWE58G,CON_1G8RBC73NGX0,1 Chapter 5 PRD_32D4GVZWE58G Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_351STH3K3BC0,CON_1G8RBC73NGX0,1 Chapter 8 PRD_351STH3K3BC0 Ten Amanatsu CON_1G8RBC73NGX0 1  
PRD_35G6D1V8P3EG,CON_1G8RBC73NGX0,1 Chapter 1 PRD_35G6D1V8P3EG Ten Amanatsu CON_1G8RBC73NGX0 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.715ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS