BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_3AE58KKFZGY0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01ZKF9TQ1G4G,CON_3AE58KKFZGY0,2 Volume 1 PRD_01ZKF9TQ1G4G Yuunagi CON_3AE58KKFZGY0 2  
PRD_0E74EDXK3E90,CON_3AE58KKFZGY0,2 Volume 7 PRD_0E74EDXK3E90 Yuunagi CON_3AE58KKFZGY0 2  
PRD_0EWAD9RFPJPG,CON_3AE58KKFZGY0,2 Volume 10 PRD_0EWAD9RFPJPG Yuunagi CON_3AE58KKFZGY0 2  
PRD_0F7H4K0VNKCG,CON_3AE58KKFZGY0,2 Volume 2 PRD_0F7H4K0VNKCG Yuunagi CON_3AE58KKFZGY0 2  
PRD_0FK1C5N5ZQ5G,CON_3AE58KKFZGY0,2 Volume 8 PRD_0FK1C5N5ZQ5G Yuunagi CON_3AE58KKFZGY0 2  
PRD_0GGFFS6KRF1G,CON_3AE58KKFZGY0,2 Volume 1 PRD_0GGFFS6KRF1G Yuunagi CON_3AE58KKFZGY0 2  
PRD_0SMV06XC1G00,CON_3AE58KKFZGY0,2 Volume 3 PRD_0SMV06XC1G00 Yuunagi CON_3AE58KKFZGY0 2  
PRD_163TQ9QZ4R90,CON_3AE58KKFZGY0,2 Volume 2 PRD_163TQ9QZ4R90 Yuunagi CON_3AE58KKFZGY0 2  
PRD_1D074ERAQMGG,CON_3AE58KKFZGY0,2 Volume 6 PRD_1D074ERAQMGG Yuunagi CON_3AE58KKFZGY0 2  
PRD_1JCR0NJG64B0,CON_3AE58KKFZGY0,2 Volume 4 PRD_1JCR0NJG64B0 Yuunagi CON_3AE58KKFZGY0 2  
PRD_1K1Q3PYNBC70,CON_3AE58KKFZGY0,2 These Legs Don't Lie! Harumi's Legacy as the Strongest Mimic PRD_1K1Q3PYNBC70 Yuunagi CON_3AE58KKFZGY0 2  
PRD_26TK2DYRZE00,CON_3AE58KKFZGY0,2 Volume 3 PRD_26TK2DYRZE00 Yuunagi CON_3AE58KKFZGY0 2  
PRD_34QZTB89SA1G,CON_3AE58KKFZGY0,2 Volume 5 PRD_34QZTB89SA1G Yuunagi CON_3AE58KKFZGY0 2  
PRD_3B1KYQS7QY00,CON_3AE58KKFZGY0,2 Volume 9 PRD_3B1KYQS7QY00 Yuunagi CON_3AE58KKFZGY0 2  
PRD_3VP37HXKQED0,CON_3AE58KKFZGY0,2 Volume 4 PRD_3VP37HXKQED0 Yuunagi CON_3AE58KKFZGY0 2  

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 8.092ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS