BookWalker

home / database

product_contributors

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

35 rows where contributor_id = "CON_0VNCBZ3AQ3D0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03SFSKJRMJ6G,CON_0VNCBZ3AQ3D0,1 Chapter 35 PRD_03SFSKJRMJ6G Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_06FYB6C2GH5G,CON_0VNCBZ3AQ3D0,1 Chapter 33 PRD_06FYB6C2GH5G Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_09JS0C8ERZBG,CON_0VNCBZ3AQ3D0,1 Chapter 29 PRD_09JS0C8ERZBG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_0AWEPSE4WG4G,CON_0VNCBZ3AQ3D0,1 Chapter 31 PRD_0AWEPSE4WG4G Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_0C39KZ5H4YAG,CON_0VNCBZ3AQ3D0,1 Chapter 27 PRD_0C39KZ5H4YAG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_0HVYE72KB400,CON_0VNCBZ3AQ3D0,1 Chapter 6 PRD_0HVYE72KB400 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_0M8ESVWNQ370,CON_0VNCBZ3AQ3D0,1 Chapter 4 PRD_0M8ESVWNQ370 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_0RYSBEYZK260,CON_0VNCBZ3AQ3D0,1 Chapter 2 PRD_0RYSBEYZK260 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_118N3JRNWRCG,CON_0VNCBZ3AQ3D0,1 Chapter 15 PRD_118N3JRNWRCG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_12VTGZYKGSDG,CON_0VNCBZ3AQ3D0,1 Chapter 17 PRD_12VTGZYKGSDG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_15S4D5TZRRKG,CON_0VNCBZ3AQ3D0,1 Chapter 13 PRD_15S4D5TZRRKG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_18FMRRM257JG,CON_0VNCBZ3AQ3D0,1 Chapter 11 PRD_18FMRRM257JG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_1CW7ABP416HG,CON_0VNCBZ3AQ3D0,1 Chapter 9 PRD_1CW7ABP416HG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_1GHRYJ7V0X9G,CON_0VNCBZ3AQ3D0,1 Chapter 25 PRD_1GHRYJ7V0X9G Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_1Q6B851XCW8G,CON_0VNCBZ3AQ3D0,1 Chapter 23 PRD_1Q6B851XCW8G Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_1VMVVR378VFG,CON_0VNCBZ3AQ3D0,1 Chapter 21 PRD_1VMVVR378VFG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_1Y5A5CX9MTEG,CON_0VNCBZ3AQ3D0,1 Chapter 19 PRD_1Y5A5CX9MTEG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_206QJXXXJJP0,CON_0VNCBZ3AQ3D0,1 Chapter 34 PRD_206QJXXXJJP0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_24Q6XGZ7YHN0,CON_0VNCBZ3AQ3D0,1 Chapter 32 PRD_24Q6XGZ7YHN0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2B5HF3S9TGM0,CON_0VNCBZ3AQ3D0,1 Chapter 30 PRD_2B5HF3S9TGM0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2FT1TPVC6ZV0,CON_0VNCBZ3AQ3D0,1 Chapter 28 PRD_2FT1TPVC6ZV0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2KJQNYGED5GG,CON_0VNCBZ3AQ3D0,1 Chapter 7 PRD_2KJQNYGED5GG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2P360HDG94QG,CON_0VNCBZ3AQ3D0,1 Chapter 5 PRD_2P360HDG94QG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2S61XQ9WH2NG,CON_0VNCBZ3AQ3D0,1 Chapter 1 PRD_2S61XQ9WH2NG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_2THPJ4FTN3PG,CON_0VNCBZ3AQ3D0,1 Chapter 3 PRD_2THPJ4FTN3PG Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_333D989GYSX0,CON_0VNCBZ3AQ3D0,1 Chapter 16 PRD_333D989GYSX0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_37HXMVBTTRW0,CON_0VNCBZ3AQ3D0,1 Chapter 14 PRD_37HXMVBTTRW0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3A6C6E5X7730,CON_0VNCBZ3AQ3D0,1 Chapter 12 PRD_3A6C6E5X7730 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3D5FWM19F510,CON_0VNCBZ3AQ3D0,1 Chapter 8 PRD_3D5FWM19F510 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3EMWH1773620,CON_0VNCBZ3AQ3D0,1 Chapter 10 PRD_3EMWH1773620 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3J8G49MP2YT0,CON_0VNCBZ3AQ3D0,1 Chapter 26 PRD_3J8G49MP2YT0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3NFK1FG2AWR0,CON_0VNCBZ3AQ3D0,1 Chapter 22 PRD_3NFK1FG2AWR0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3PS0QWPREXS0,CON_0VNCBZ3AQ3D0,1 Chapter 24 PRD_3PS0QWPREXS0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3SW2C2J4PVZ0,CON_0VNCBZ3AQ3D0,1 Chapter 20 PRD_3SW2C2J4PVZ0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 1  
PRD_3WJJZNCEJTY0,CON_0VNCBZ3AQ3D0,1 Chapter 18 PRD_3WJJZNCEJTY0 Mutsuko Shiki CON_0VNCBZ3AQ3D0 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.162ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS