BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_3GRZEGPPPWC0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_07TJ55SG5ZF0,CON_3GRZEGPPPWC0,1 Volume 10 PRD_07TJ55SG5ZF0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_082FYG48WEDG,CON_3GRZEGPPPWC0,1 Volume 4 PRD_082FYG48WEDG Hamuo CON_3GRZEGPPPWC0 1  
PRD_09H9BBKSYMSG,CON_3GRZEGPPPWC0,1 Volume 3 PRD_09H9BBKSYMSG Hamuo CON_3GRZEGPPPWC0 1  
PRD_0BKQ8HR3NV6G,CON_3GRZEGPPPWC0,1 Volume 7 PRD_0BKQ8HR3NV6G Hamuo CON_3GRZEGPPPWC0 1  
PRD_0DQMY6H4W5KG,CON_3GRZEGPPPWC0,1 Volume 1 PRD_0DQMY6H4W5KG Hamuo CON_3GRZEGPPPWC0 1  
PRD_10TQGAE2T1EG,CON_3GRZEGPPPWC0,1 Volume 9 PRD_10TQGAE2T1EG Hamuo CON_3GRZEGPPPWC0 1  
PRD_131023G8GMQG,CON_3GRZEGPPPWC0,1 Volume 11 PRD_131023G8GMQG Hamuo CON_3GRZEGPPPWC0 1  
PRD_17QKKH8J2FB0,CON_3GRZEGPPPWC0,1 Volume 5 PRD_17QKKH8J2FB0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_1DWDNFSKER2G,CON_3GRZEGPPPWC0,1 Volume 10 PRD_1DWDNFSKER2G Hamuo CON_3GRZEGPPPWC0 1  
PRD_1PP552FGFZS0,CON_3GRZEGPPPWC0,1 Volume 2 PRD_1PP552FGFZS0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_1REMDJY91NVG,CON_3GRZEGPPPWC0,1 Volume 6 PRD_1REMDJY91NVG Hamuo CON_3GRZEGPPPWC0 1  
PRD_1V06R2ZXM8CG,CON_3GRZEGPPPWC0,1 Volume 1 PRD_1V06R2ZXM8CG Hamuo CON_3GRZEGPPPWC0 1  
PRD_265QG5MZ55NG,CON_3GRZEGPPPWC0,1 Volume 2 PRD_265QG5MZ55NG Hamuo CON_3GRZEGPPPWC0 1  
PRD_27T3PCC5N5VG,CON_3GRZEGPPPWC0,1 Volume 8 PRD_27T3PCC5N5VG Hamuo CON_3GRZEGPPPWC0 1  
PRD_2B86J10MGMA0,CON_3GRZEGPPPWC0,1 Volume 2 PRD_2B86J10MGMA0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_2BXH26J0KSV0,CON_3GRZEGPPPWC0,1 Volume 9 PRD_2BXH26J0KSV0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_2FBXW23NJMSG,CON_3GRZEGPPPWC0,1 Volume 8 PRD_2FBXW23NJMSG Hamuo CON_3GRZEGPPPWC0 1  
PRD_2N0VDPJJT6NG,CON_3GRZEGPPPWC0,1 Volume 4 PRD_2N0VDPJJT6NG Hamuo CON_3GRZEGPPPWC0 1  
PRD_30581MTHEXY0,CON_3GRZEGPPPWC0,1 Volume 5 PRD_30581MTHEXY0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_33AFM8SEVCGG,CON_3GRZEGPPPWC0,1 Volume 1 PRD_33AFM8SEVCGG Hamuo CON_3GRZEGPPPWC0 1  
PRD_3BFDETN909N0,CON_3GRZEGPPPWC0,1 Volume 6 PRD_3BFDETN909N0 Hamuo CON_3GRZEGPPPWC0 1  
PRD_3EKJ266G36VG,CON_3GRZEGPPPWC0,1 Volume 3 PRD_3EKJ266G36VG Hamuo CON_3GRZEGPPPWC0 1  
PRD_3GVEV2Z22460,CON_3GRZEGPPPWC0,1 Volume 3 PRD_3GVEV2Z22460 Hamuo CON_3GRZEGPPPWC0 1  
PRD_3J8SC8KP9XDG,CON_3GRZEGPPPWC0,1 Volume 7 PRD_3J8SC8KP9XDG Hamuo CON_3GRZEGPPPWC0 1  
PRD_3N2JEYHHBHXG,CON_3GRZEGPPPWC0,24 Volume 1 Short Story PRD_3N2JEYHHBHXG Hamuo CON_3GRZEGPPPWC0 24  

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