BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_0TKQXEBGX3HG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_09TETK1DJ7YG,CON_0TKQXEBGX3HG,1 Time of the Temptress PRD_09TETK1DJ7YG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_0Y82QM9DFVGG,CON_0TKQXEBGX3HG,1 Beloved Castaway PRD_0Y82QM9DFVGG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_0ZS02XZMKMSG,CON_0TKQXEBGX3HG,1 Love Is The Honey PRD_0ZS02XZMKMSG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_11HTMSHMP07G,CON_0TKQXEBGX3HG,1 The Burning Sands PRD_11HTMSHMP07G Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_1H11S02A33K0,CON_0TKQXEBGX3HG,1 A Silken Barbarity PRD_1H11S02A33K0 Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_1HDH6Q7Q8V4G,CON_0TKQXEBGX3HG,1 Tawny Sands PRD_1HDH6Q7Q8V4G Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_1KSDBXYC7FEG,CON_0TKQXEBGX3HG,1 Lucifer's Angel PRD_1KSDBXYC7FEG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_1X6RJFHS6E2G,CON_0TKQXEBGX3HG,1 Dragon Bay PRD_1X6RJFHS6E2G Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_2DHTJKFES0Z0,CON_0TKQXEBGX3HG,1 The Passionate Sinner PRD_2DHTJKFES0Z0 Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_32KX7MK0EQ50,CON_0TKQXEBGX3HG,1 No Man of Her Own PRD_32KX7MK0EQ50 Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_3DGN0GWGWTG0,CON_0TKQXEBGX3HG,1 Bride'S Lace PRD_3DGN0GWGWTG0 Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_3ESK28MT9GQG,CON_0TKQXEBGX3HG,1 The Child of Judas PRD_3ESK28MT9GQG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_3SPX11P3ATSG,CON_0TKQXEBGX3HG,1 The Sun Tower PRD_3SPX11P3ATSG Violet Winspear CON_0TKQXEBGX3HG 1  
PRD_3XD4FVQP1PYG,CON_0TKQXEBGX3HG,1 Love's Agony PRD_3XD4FVQP1PYG Violet Winspear CON_0TKQXEBGX3HG 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 8.9ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS