BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_174RMHFGEBQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00KA7K4WZ140,CON_174RMHFGEBQ0,9 Volume 6 PRD_00KA7K4WZ140 airco CON_174RMHFGEBQ0 9  
PRD_02WKTN3ZS3VG,CON_174RMHFGEBQ0,0 Chapter 40 PRD_02WKTN3ZS3VG airco CON_174RMHFGEBQ0 0  
PRD_058Y3GKJ29Y0,CON_174RMHFGEBQ0,9 Chapter 46.1 PRD_058Y3GKJ29Y0 airco CON_174RMHFGEBQ0 9  
PRD_09X7MV34FQ60,CON_174RMHFGEBQ0,9 Chapter 45 PRD_09X7MV34FQ60 airco CON_174RMHFGEBQ0 9  
PRD_0BM7A5XG06VG,CON_174RMHFGEBQ0,9 Chapter 46.2 PRD_0BM7A5XG06VG airco CON_174RMHFGEBQ0 9  
PRD_0G4QRER25Z0G,CON_174RMHFGEBQ0,0 Chapter 44 PRD_0G4QRER25Z0G airco CON_174RMHFGEBQ0 0  
PRD_0G67CR4Z2GB0,CON_174RMHFGEBQ0,0 Volume 4 PRD_0G67CR4Z2GB0 airco CON_174RMHFGEBQ0 0  
PRD_1FEWNHFTVHJ0,CON_174RMHFGEBQ0,0 Chapter 41 PRD_1FEWNHFTVHJ0 airco CON_174RMHFGEBQ0 0  
PRD_1SZJ70CJ3BK0,CON_174RMHFGEBQ0,9 Chapter 42 PRD_1SZJ70CJ3BK0 airco CON_174RMHFGEBQ0 9  
PRD_2AKCZY74JYQG,CON_174RMHFGEBQ0,9 Volume 3 PRD_2AKCZY74JYQG airco CON_174RMHFGEBQ0 9  
PRD_2HQ89Q4GPBG0,CON_174RMHFGEBQ0,0 Chapter 39 PRD_2HQ89Q4GPBG0 airco CON_174RMHFGEBQ0 0  
PRD_2KZF749X7GH0,CON_174RMHFGEBQ0,0 Chapter 43 PRD_2KZF749X7GH0 airco CON_174RMHFGEBQ0 0  
PRD_2XH61Z9ZGAB0,CON_174RMHFGEBQ0,0 Volume 2 PRD_2XH61Z9ZGAB0 airco CON_174RMHFGEBQ0 0  
PRD_2YS86BWYVF10,CON_174RMHFGEBQ0,0 Volume 5 PRD_2YS86BWYVF10 airco CON_174RMHFGEBQ0 0  
PRD_31MDHHNGF7Z0,CON_174RMHFGEBQ0,0 Chapter 38 PRD_31MDHHNGF7Z0 airco CON_174RMHFGEBQ0 0  
PRD_3R73T0X22M30,CON_174RMHFGEBQ0,0 Volume 1 PRD_3R73T0X22M30 airco CON_174RMHFGEBQ0 0  
PRD_3SGRENSVAA50,CON_174RMHFGEBQ0,9 Volume 3 PRD_3SGRENSVAA50 airco CON_174RMHFGEBQ0 9  
PRD_3XM87V2D1JN0,CON_174RMHFGEBQ0,0 Volume 3 PRD_3XM87V2D1JN0 airco CON_174RMHFGEBQ0 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.821ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS