BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_2TPXW05QBNK0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_054FY525B41G,CON_2TPXW05QBNK0,24 Volume 2 PRD_054FY525B41G Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_06SBKSEVXDFG,CON_2TPXW05QBNK0,24 Volume 10 PRD_06SBKSEVXDFG Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_07J68ZZSRSQ0,CON_2TPXW05QBNK0,24 Volume 3 PRD_07J68ZZSRSQ0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_0DRXPSBTVRJG,CON_2TPXW05QBNK0,24 Volume 8 PRD_0DRXPSBTVRJG Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_0E13SV0A8B90,CON_2TPXW05QBNK0,24 Volume 17 PRD_0E13SV0A8B90 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_0WHC6650GSQG,CON_2TPXW05QBNK0,24 Volume 16 PRD_0WHC6650GSQG Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_0YV073H40BX0,CON_2TPXW05QBNK0,24 Volume 12 PRD_0YV073H40BX0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_1H9C4HPBYSF0,CON_2TPXW05QBNK0,24 Volume 7 PRD_1H9C4HPBYSF0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_1NT5A92XD0NG,CON_2TPXW05QBNK0,24 Volume 1 PRD_1NT5A92XD0NG Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_1PESXJ7H5AJ0,CON_2TPXW05QBNK0,24 Volume 11 PRD_1PESXJ7H5AJ0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_1RSVC6X271A0,CON_2TPXW05QBNK0,24 Volume 5 PRD_1RSVC6X271A0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_1V4R8129E65G,CON_2TPXW05QBNK0,24 Volume 13 PRD_1V4R8129E65G Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_23GK6GE9SQ4G,CON_2TPXW05QBNK0,24 Volume 14 PRD_23GK6GE9SQ4G Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_2G468G5PTH1G,CON_2TPXW05QBNK0,24 Volume 9 PRD_2G468G5PTH1G Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_2W8859EJ91DG,CON_2TPXW05QBNK0,24 Volume 15 PRD_2W8859EJ91DG Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_320RRQRFEXP0,CON_2TPXW05QBNK0,24 Volume 6 PRD_320RRQRFEXP0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_37EJFQQW42X0,CON_2TPXW05QBNK0,24 Volume 18 PRD_37EJFQQW42X0 Shirow Shiratori CON_2TPXW05QBNK0 24  
PRD_3AMS05A2TMX0,CON_2TPXW05QBNK0,24 Volume 4 PRD_3AMS05A2TMX0 Shirow Shiratori CON_2TPXW05QBNK0 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.494ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS