BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_2XVFE3Q3D1M0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01F8NKYRKVF0,CON_2XVFE3Q3D1M0,0 Volume 17 PRD_01F8NKYRKVF0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_040MF60E29KG,CON_2XVFE3Q3D1M0,0 Volume 18 PRD_040MF60E29KG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_05XV76R2ZTE0,CON_2XVFE3Q3D1M0,0 Volume 15 PRD_05XV76R2ZTE0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_0806JPVQNH70,CON_2XVFE3Q3D1M0,0 Volume 3 PRD_0806JPVQNH70 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_08JBJST4VSD0,CON_2XVFE3Q3D1M0,0 Volume 13 PRD_08JBJST4VSD0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_0CPHW9NSHG60,CON_2XVFE3Q3D1M0,0 Volume 1 PRD_0CPHW9NSHG60 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_0F0TWCMF7RC0,CON_2XVFE3Q3D1M0,0 Volume 11 PRD_0F0TWCMF7RC0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_1KHNFZHH3RK0,CON_2XVFE3Q3D1M0,0 Volume 9 PRD_1KHNFZHH3RK0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_1P65TJKVC7J0,CON_2XVFE3Q3D1M0,0 Volume 7 PRD_1P65TJKVC7J0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_23AXBAQ6RAX0,CON_2XVFE3Q3D1M0,0 Volume 19 PRD_23AXBAQ6RAX0 Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_27MKEW9XHVYG,CON_2XVFE3Q3D1M0,0 Volume 16 PRD_27MKEW9XHVYG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_2A53RFB7XTXG,CON_2XVFE3Q3D1M0,0 Volume 14 PRD_2A53RFB7XTXG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_2BRYRC8JQJQG,CON_2XVFE3Q3D1M0,0 Volume 4 PRD_2BRYRC8JQJQG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_2D82PN7C5R3G,CON_2XVFE3Q3D1M0,0 Volume 10 PRD_2D82PN7C5R3G Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_2E99BZAMKHPG,CON_2XVFE3Q3D1M0,0 Volume 2 PRD_2E99BZAMKHPG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_2EVJB259SSWG,CON_2XVFE3Q3D1M0,0 Volume 12 PRD_2EVJB259SSWG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_3CQDD4DMM8GG,CON_2XVFE3Q3D1M0,0 Volume 20 PRD_3CQDD4DMM8GG Jack Wiedrick CON_2XVFE3Q3D1M0 0  
PRD_3HYX080PE72G,CON_2XVFE3Q3D1M0,0 Volume 8 PRD_3HYX080PE72G Jack Wiedrick CON_2XVFE3Q3D1M0 0  

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