BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_26FTQVSTCKAG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0D24E17RWG2G,CON_26FTQVSTCKAG,1 Chapter 2 PRD_0D24E17RWG2G Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_0D93JW30ANHG,CON_26FTQVSTCKAG,1 Chapter 2 PRD_0D93JW30ANHG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_0ERK791YEPJG,CON_26FTQVSTCKAG,1 Chapter 4 PRD_0ERK791YEPJG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_0NKQGQJSPB8G,CON_26FTQVSTCKAG,1 Chapter 6 PRD_0NKQGQJSPB8G Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_0R062AC3JAFG,CON_26FTQVSTCKAG,1 Chapter 4 PRD_0R062AC3JAFG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_0WPHDXE5Y9EG,CON_26FTQVSTCKAG,1 Chapter 2 PRD_0WPHDXE5Y9EG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_1HZJXGXAPMGG,CON_26FTQVSTCKAG,1 Chapter 6 PRD_1HZJXGXAPMGG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_1MCDF3ZCJKQG,CON_26FTQVSTCKAG,1 Chapter 4 PRD_1MCDF3ZCJKQG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_1Q699ZWW5ZDG,CON_26FTQVSTCKAG,1 Chapter 2 PRD_1Q699ZWW5ZDG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_1V2XTPRPYJPG,CON_26FTQVSTCKAG,1 Chapter 2 PRD_1V2XTPRPYJPG Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_1X9WNF5PZH2G,CON_26FTQVSTCKAG,1 Chapter 1 PRD_1X9WNF5PZH2G Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_22ZS67SAW9Y0,CON_26FTQVSTCKAG,1 Chapter 1 PRD_22ZS67SAW9Y0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_2CTXNRMVYHK0,CON_26FTQVSTCKAG,1 Chapter 3 PRD_2CTXNRMVYHK0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_2F1VSKG3CN20,CON_26FTQVSTCKAG,1 Chapter 3 PRD_2F1VSKG3CN20 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_2VRY91XYMBR0,CON_26FTQVSTCKAG,1 Chapter 5 PRD_2VRY91XYMBR0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_2Y9EMMZ0GAZ0,CON_26FTQVSTCKAG,1 Chapter 3 PRD_2Y9EMMZ0GAZ0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3KBC7BPXTGJ0,CON_26FTQVSTCKAG,1 Chapter 1 PRD_3KBC7BPXTGJ0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3KPAB6J58M10,CON_26FTQVSTCKAG,1 Chapter 1 PRD_3KPAB6J58M10 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3NFH28F13ZX0,CON_26FTQVSTCKAG,1 Chapter 1 PRD_3NFH28F13ZX0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3P4TPSCFMK00,CON_26FTQVSTCKAG,1 Chapter 5 PRD_3P4TPSCFMK00 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3PS6GNDZ7GY0,CON_26FTQVSTCKAG,1 Chapter 3 PRD_3PS6GNDZ7GY0 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3SA5KZBVWH60,CON_26FTQVSTCKAG,1 Chapter 1 PRD_3SA5KZBVWH60 Suguru Takeura CON_26FTQVSTCKAG 1  
PRD_3TNN0C9HGJ70,CON_26FTQVSTCKAG,1 Chapter 3 PRD_3TNN0C9HGJ70 Suguru Takeura CON_26FTQVSTCKAG 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 10.981ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS