BookWalker

home / database

product_contributors

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

27 rows where contributor_id = "CON_3V29AT8V3JAG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03Q65595MM00,CON_3V29AT8V3JAG,1 Volume 09 PRD_03Q65595MM00 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_051STEZVWCEG,CON_3V29AT8V3JAG,1 Volume 01 PRD_051STEZVWCEG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_0AQMTBX6P40G,CON_3V29AT8V3JAG,1 Volume 08 PRD_0AQMTBX6P40G Toshio Satou CON_3V29AT8V3JAG 1  
PRD_0DP58GH7BM10,CON_3V29AT8V3JAG,1 Volume 11 PRD_0DP58GH7BM10 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_0VS8V42H8NVG,CON_3V29AT8V3JAG,1 Volume 1 PRD_0VS8V42H8NVG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_0ZCFKM658F9G,CON_3V29AT8V3JAG,1 Volume 02 PRD_0ZCFKM658F9G Toshio Satou CON_3V29AT8V3JAG 1  
PRD_116CF4Q2WTE0,CON_3V29AT8V3JAG,1 Volume 07 PRD_116CF4Q2WTE0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_12SS96JV76PG,CON_3V29AT8V3JAG,1 Volume 15 PRD_12SS96JV76PG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_13N5X4QMXER0,CON_3V29AT8V3JAG,1 Volume 4 PRD_13N5X4QMXER0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_169YJ850TSNG,CON_3V29AT8V3JAG,1 Volume 7 PRD_169YJ850TSNG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_1ZE1JQ0BFQ60,CON_3V29AT8V3JAG,1 Volume 8 PRD_1ZE1JQ0BFQ60 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_24RH14CPYDZ0,CON_3V29AT8V3JAG,1 Volume 03 PRD_24RH14CPYDZ0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_2DRPK9YAP3X0,CON_3V29AT8V3JAG,1 Volume 5 PRD_2DRPK9YAP3X0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_2E3WN1KKH9D0,CON_3V29AT8V3JAG,1 Volume 6 PRD_2E3WN1KKH9D0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_2RQ2AFRNYRW0,CON_3V29AT8V3JAG,1 Volume 3 PRD_2RQ2AFRNYRW0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_30PEVSF0C8J0,CON_3V29AT8V3JAG,1 Volume 11 PRD_30PEVSF0C8J0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_30TBETWJ8DS0,CON_3V29AT8V3JAG,1 Volume 10 PRD_30TBETWJ8DS0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_32H09P8DKQ40,CON_3V29AT8V3JAG,1 Volume 9 PRD_32H09P8DKQ40 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_37CP0YBBAE60,CON_3V29AT8V3JAG,1 Volume 2 PRD_37CP0YBBAE60 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_38AWPH1WMERG,CON_3V29AT8V3JAG,1 Volume 13 PRD_38AWPH1WMERG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3E02YG3YWGNG,CON_3V29AT8V3JAG,1 Volume 12 PRD_3E02YG3YWGNG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3FT3Y88VESYG,CON_3V29AT8V3JAG,1 Volume 14 PRD_3FT3Y88VESYG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3J9P1W2SZWYG,CON_3V29AT8V3JAG,1 Volume 04 PRD_3J9P1W2SZWYG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3KZXPTT5GCF0,CON_3V29AT8V3JAG,1 Volume 12 PRD_3KZXPTT5GCF0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3NCHY3Y67TWG,CON_3V29AT8V3JAG,1 Volume 05 PRD_3NCHY3Y67TWG Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3W297XKQMCH0,CON_3V29AT8V3JAG,1 Volume 10 PRD_3W297XKQMCH0 Toshio Satou CON_3V29AT8V3JAG 1  
PRD_3WF7K8J6SAX0,CON_3V29AT8V3JAG,1 Volume 06 PRD_3WF7K8J6SAX0 Toshio Satou CON_3V29AT8V3JAG 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 10.704ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS