BookWalker

home / database

product_contributors

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

20 rows where contributor_id = "CON_0EJ8K0W99H60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0KVGYT5WVVE0,CON_0EJ8K0W99H60,1 Chapter 9 PRD_0KVGYT5WVVE0 yos CON_0EJ8K0W99H60 1  
PRD_0S8HYKV7SADG,CON_0EJ8K0W99H60,1 Chapter 19 PRD_0S8HYKV7SADG yos CON_0EJ8K0W99H60 1  
PRD_0XXJG7WNBRJ0,CON_0EJ8K0W99H60,1 Chapter 7 PRD_0XXJG7WNBRJ0 yos CON_0EJ8K0W99H60 1  
PRD_138FJ437DGTG,CON_0EJ8K0W99H60,1 Chapter 15 PRD_138FJ437DGTG yos CON_0EJ8K0W99H60 1  
PRD_17YYXRX99ZSG,CON_0EJ8K0W99H60,1 Chapter 12 PRD_17YYXRX99ZSG yos CON_0EJ8K0W99H60 1  
PRD_1AF9FBYKNYRG,CON_0EJ8K0W99H60,1 Chapter 11 PRD_1AF9FBYKNYRG yos CON_0EJ8K0W99H60 1  
PRD_1R5CNY7V5JMG,CON_0EJ8K0W99H60,1 Chapter 1 PRD_1R5CNY7V5JMG yos CON_0EJ8K0W99H60 1  
PRD_1WVZ0H1X1HVG,CON_0EJ8K0W99H60,1 Chapter 17 PRD_1WVZ0H1X1HVG yos CON_0EJ8K0W99H60 1  
PRD_2255AGFTP71G,CON_0EJ8K0W99H60,1 Chapter 6 PRD_2255AGFTP71G yos CON_0EJ8K0W99H60 1  
PRD_22681F4F39W0,CON_0EJ8K0W99H60,1 Chapter 16 PRD_22681F4F39W0 yos CON_0EJ8K0W99H60 1  
PRD_26MVC21HF830,CON_0EJ8K0W99H60,1 Chapter 14 PRD_26MVC21HF830 yos CON_0EJ8K0W99H60 1  
PRD_26VNM39WJ60G,CON_0EJ8K0W99H60,1 Chapter 4 PRD_26VNM39WJ60G yos CON_0EJ8K0W99H60 1  
PRD_2C8AMWZ7KN00,CON_0EJ8K0W99H60,1 Chapter 8 PRD_2C8AMWZ7KN00 yos CON_0EJ8K0W99H60 1  
PRD_2G0RQ4M1SVXG,CON_0EJ8K0W99H60,1 Chapter 5 PRD_2G0RQ4M1SVXG yos CON_0EJ8K0W99H60 1  
PRD_2MHB2QP45TWG,CON_0EJ8K0W99H60,1 Chapter 10 PRD_2MHB2QP45TWG yos CON_0EJ8K0W99H60 1  
PRD_2V7TCAGE1S3G,CON_0EJ8K0W99H60,1 Chapter 13 PRD_2V7TCAGE1S3G yos CON_0EJ8K0W99H60 1  
PRD_31HPBEJ4BZA0,CON_0EJ8K0W99H60,1 Chapter 2 PRD_31HPBEJ4BZA0 yos CON_0EJ8K0W99H60 1  
PRD_38MH1M9GKX80,CON_0EJ8K0W99H60,1 Chapter 3 PRD_38MH1M9GKX80 yos CON_0EJ8K0W99H60 1  
PRD_3VW4WNMP7J50,CON_0EJ8K0W99H60,1 Chapter 20 PRD_3VW4WNMP7J50 yos CON_0EJ8K0W99H60 1  
PRD_3YJQE8PR3H40,CON_0EJ8K0W99H60,1 Chapter 18 PRD_3YJQE8PR3H40 yos CON_0EJ8K0W99H60 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.035ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS