BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_0NZZFG9TQMHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02K9V8FEWJ1G,CON_0NZZFG9TQMHG,1 Chapter 11 PRD_02K9V8FEWJ1G Kyaru CON_0NZZFG9TQMHG 1  
PRD_02QT39PT3070,CON_0NZZFG9TQMHG,1 Chapter 9 PRD_02QT39PT3070 Kyaru CON_0NZZFG9TQMHG 1  
PRD_05KY8D3FY220,CON_0NZZFG9TQMHG,1 Chapter 25 PRD_05KY8D3FY220 Kyaru CON_0NZZFG9TQMHG 1  
PRD_05N5RFJ6BE50,CON_0NZZFG9TQMHG,1 Chapter 5 PRD_05N5RFJ6BE50 Kyaru CON_0NZZFG9TQMHG 1  
PRD_05P8GEAV4G7G,CON_0NZZFG9TQMHG,1 Chapter 24 PRD_05P8GEAV4G7G Kyaru CON_0NZZFG9TQMHG 1  
PRD_080EV1WHT110,CON_0NZZFG9TQMHG,1 Chapter 23 PRD_080EV1WHT110 Kyaru CON_0NZZFG9TQMHG 1  
PRD_08BMB2C8QD40,CON_0NZZFG9TQMHG,1 Chapter 3 PRD_08BMB2C8QD40 Kyaru CON_0NZZFG9TQMHG 1  
PRD_0CR4PN9JKCB0,CON_0NZZFG9TQMHG,1 Chapter 1 PRD_0CR4PN9JKCB0 Kyaru CON_0NZZFG9TQMHG 1  
PRD_0GDR9XZ1K430,CON_0NZZFG9TQMHG,1 Chapter 17 PRD_0GDR9XZ1K430 Kyaru CON_0NZZFG9TQMHG 1  
PRD_0VGV63VDV210,CON_0NZZFG9TQMHG,1 Chapter 12 PRD_0VGV63VDV210 Kyaru CON_0NZZFG9TQMHG 1  
PRD_1FP150JT95CG,CON_0NZZFG9TQMHG,1 Chapter 20 PRD_1FP150JT95CG Kyaru CON_0NZZFG9TQMHG 1  
PRD_1TABDDMAAD50,CON_0NZZFG9TQMHG,1 Chapter 14 PRD_1TABDDMAAD50 Kyaru CON_0NZZFG9TQMHG 1  
PRD_20Z2NJ1Z10PG,CON_0NZZFG9TQMHG,1 Chapter 8 PRD_20Z2NJ1Z10PG Kyaru CON_0NZZFG9TQMHG 1  
PRD_27DX7531DFNG,CON_0NZZFG9TQMHG,1 Chapter 6 PRD_27DX7531DFNG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2A2DJSXB9EMG,CON_0NZZFG9TQMHG,1 Chapter 4 PRD_2A2DJSXB9EMG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2EGWWCZDNDVG,CON_0NZZFG9TQMHG,1 Chapter 2 PRD_2EGWWCZDNDVG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2J078J4HEPE0,CON_0NZZFG9TQMHG,1 Chapter 19 PRD_2J078J4HEPE0 Kyaru CON_0NZZFG9TQMHG 1  
PRD_2J4HGKCWN5KG,CON_0NZZFG9TQMHG,1 Chapter 18 PRD_2J4HGKCWN5KG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2NBKDS88X3HG,CON_0NZZFG9TQMHG,1 Chapter 15 PRD_2NBKDS88X3HG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2PN026E6H4JG,CON_0NZZFG9TQMHG,1 Chapter 16 PRD_2PN026E6H4JG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2SR3ZC5JS2GG,CON_0NZZFG9TQMHG,1 Chapter 13 PRD_2SR3ZC5JS2GG Kyaru CON_0NZZFG9TQMHG 1  
PRD_2WEJAZ7N51QG,CON_0NZZFG9TQMHG,1 Chapter 10 PRD_2WEJAZ7N51QG Kyaru CON_0NZZFG9TQMHG 1  
PRD_36BZQG492RZ0,CON_0NZZFG9TQMHG,1 Chapter 7 PRD_36BZQG492RZ0 Kyaru CON_0NZZFG9TQMHG 1  
PRD_39AC4PRA48ZG,CON_0NZZFG9TQMHG,1 Chapter 22 PRD_39AC4PRA48ZG Kyaru CON_0NZZFG9TQMHG 1  
PRD_39ESCP3NB6X0,CON_0NZZFG9TQMHG,1 Chapter 21 PRD_39ESCP3NB6X0 Kyaru CON_0NZZFG9TQMHG 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.639ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS