BookWalker

home / database

product_contributors

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

17 rows where contributor_id = "CON_1TWHN1DCNA0G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01K95PHASBJ0,CON_1TWHN1DCNA0G,1 Chapter 4 PRD_01K95PHASBJ0 TAKA CON_1TWHN1DCNA0G 1  
PRD_041SQ9KD5AH0,CON_1TWHN1DCNA0G,1 Chapter 3 PRD_041SQ9KD5AH0 TAKA CON_1TWHN1DCNA0G 1  
PRD_06CRBQH605E0,CON_1TWHN1DCNA0G,1 Hooked on Being Dumped Extra Edition PRD_06CRBQH605E0 TAKA CON_1TWHN1DCNA0G 1  
PRD_0F4VCFESD8Q0,CON_1TWHN1DCNA0G,1 Chapter 5 Part 1 PRD_0F4VCFESD8Q0 TAKA CON_1TWHN1DCNA0G 1  
PRD_0GHPGNCHG340,CON_1TWHN1DCNA0G,1 Chapter 6 Part 2 PRD_0GHPGNCHG340 TAKA CON_1TWHN1DCNA0G 1  
PRD_0GZ98Q7VKXCG,CON_1TWHN1DCNA0G,1 Chapter 1 PRD_0GZ98Q7VKXCG TAKA CON_1TWHN1DCNA0G 1  
PRD_1BCAH7HZ72SG,CON_1TWHN1DCNA0G,1 Chapter 2 PRD_1BCAH7HZ72SG TAKA CON_1TWHN1DCNA0G 1  
PRD_1RX41WRGCY50,CON_1TWHN1DCNA0G,1 Chapter 5 PRD_1RX41WRGCY50 TAKA CON_1TWHN1DCNA0G 1  
PRD_1V212RBNHKM0,CON_1TWHN1DCNA0G,1 Chapter 7 Part 1 PRD_1V212RBNHKM0 TAKA CON_1TWHN1DCNA0G 1  
PRD_1ZKMKFTT8X40,CON_1TWHN1DCNA0G,1 Chapter 3 PRD_1ZKMKFTT8X40 TAKA CON_1TWHN1DCNA0G 1  
PRD_27SV7VEDZE40,CON_1TWHN1DCNA0G,1 Chapter 7 Part 3 PRD_27SV7VEDZE40 TAKA CON_1TWHN1DCNA0G 1  
PRD_2A909KXJ390G,CON_1TWHN1DCNA0G,1 Chapter 5 Part 2 PRD_2A909KXJ390G TAKA CON_1TWHN1DCNA0G 1  
PRD_3M84KXAC691G,CON_1TWHN1DCNA0G,1 Chapter 6 Part 1 PRD_3M84KXAC691G TAKA CON_1TWHN1DCNA0G 1  
PRD_3SACT5BNAYMG,CON_1TWHN1DCNA0G,1 Chapter 4 PRD_3SACT5BNAYMG TAKA CON_1TWHN1DCNA0G 1  
PRD_3SB9V2TTZJBG,CON_1TWHN1DCNA0G,1 Chapter 7 Part 2 PRD_3SB9V2TTZJBG TAKA CON_1TWHN1DCNA0G 1  
PRD_3TNW8J9KEZNG,CON_1TWHN1DCNA0G,1 Chapter 1 PRD_3TNW8J9KEZNG TAKA CON_1TWHN1DCNA0G 1  
PRD_3XRZ5R5ZPXVG,CON_1TWHN1DCNA0G,1 Chapter 2 PRD_3XRZ5R5ZPXVG TAKA CON_1TWHN1DCNA0G 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.27ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS