BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_16XV3S4JMXD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_15MNDPT450A0,CON_16XV3S4JMXD0,1 Chapter 11 PRD_15MNDPT450A0 SELEN CON_16XV3S4JMXD0 1  
PRD_1855Z9ME1F90,CON_16XV3S4JMXD0,1 Chapter 6 PRD_1855Z9ME1F90 SELEN CON_16XV3S4JMXD0 1  
PRD_19XWJQCEP1JG,CON_16XV3S4JMXD0,2 Volume 3 PRD_19XWJQCEP1JG SELEN CON_16XV3S4JMXD0 2  
PRD_1CVMAWHGDE80,CON_16XV3S4JMXD0,1 Chapter 5 PRD_1CVMAWHGDE80 SELEN CON_16XV3S4JMXD0 1  
PRD_1VJ8T92KN460,CON_16XV3S4JMXD0,1 Chapter 12 PRD_1VJ8T92KN460 SELEN CON_16XV3S4JMXD0 1  
PRD_1WV0E8A2F2JG,CON_16XV3S4JMXD0,2 Volume 1 PRD_1WV0E8A2F2JG SELEN CON_16XV3S4JMXD0 2  
PRD_1Y0V5XWNH350,CON_16XV3S4JMXD0,1 Chapter 8 PRD_1Y0V5XWNH350 SELEN CON_16XV3S4JMXD0 1  
PRD_2AKSH1S6A0XG,CON_16XV3S4JMXD0,2 Volume 2 PRD_2AKSH1S6A0XG SELEN CON_16XV3S4JMXD0 2  
PRD_2K84MFKT9DF0,CON_16XV3S4JMXD0,1 Chapter 10 PRD_2K84MFKT9DF0 SELEN CON_16XV3S4JMXD0 1  
PRD_2QYQ72DWNCE0,CON_16XV3S4JMXD0,1 Chapter 3 PRD_2QYQ72DWNCE0 SELEN CON_16XV3S4JMXD0 1  
PRD_30YJ9S9WV2VG,CON_16XV3S4JMXD0,1 Chapter 4 PRD_30YJ9S9WV2VG SELEN CON_16XV3S4JMXD0 1  
PRD_36V09Q5B01X0,CON_16XV3S4JMXD0,2 Volume 4 PRD_36V09Q5B01X0 SELEN CON_16XV3S4JMXD0 2  
PRD_3D0W350NBEZG,CON_16XV3S4JMXD0,1 Chapter 1 PRD_3D0W350NBEZG SELEN CON_16XV3S4JMXD0 1  
PRD_3EJDHJ6KFFRG,CON_16XV3S4JMXD0,1 Chapter 7 PRD_3EJDHJ6KFFRG SELEN CON_16XV3S4JMXD0 1  
PRD_3EKAMCCGPAKG,CON_16XV3S4JMXD0,1 Chapter 14 PRD_3EKAMCCGPAKG SELEN CON_16XV3S4JMXD0 1  
PRD_3N5010GEQ5PG,CON_16XV3S4JMXD0,1 Chapter 9 PRD_3N5010GEQ5PG SELEN CON_16XV3S4JMXD0 1  
PRD_3SVKCKDGK4NG,CON_16XV3S4JMXD0,1 Chapter 13 PRD_3SVKCKDGK4NG SELEN CON_16XV3S4JMXD0 1  
PRD_3W83Y6FTZ3MG,CON_16XV3S4JMXD0,1 Chapter 2 PRD_3W83Y6FTZ3MG SELEN CON_16XV3S4JMXD0 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 9.675ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS