BookWalker

home / database

product_contributors

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

45 rows where contributor_id = "CON_3HPMVK78PYNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_06NVE5S4XH5G,CON_3HPMVK78PYNG,9 Volume 6 PRD_06NVE5S4XH5G John Neal CON_3HPMVK78PYNG 9  
PRD_07Y9DPA6VJN0,CON_3HPMVK78PYNG,9 Volume 8 PRD_07Y9DPA6VJN0 John Neal CON_3HPMVK78PYNG 9  
PRD_083EZ6JD661G,CON_3HPMVK78PYNG,9 Volume 2 PRD_083EZ6JD661G John Neal CON_3HPMVK78PYNG 9  
PRD_09S66XDTGBEG,CON_3HPMVK78PYNG,9 Volume 2 PRD_09S66XDTGBEG John Neal CON_3HPMVK78PYNG 9  
PRD_0A3X30KRRK10,CON_3HPMVK78PYNG,9 Volume 2 PRD_0A3X30KRRK10 John Neal CON_3HPMVK78PYNG 9  
PRD_0E7BYBQKXEG0,CON_3HPMVK78PYNG,9 Volume 1 PRD_0E7BYBQKXEG0 John Neal CON_3HPMVK78PYNG 9  
PRD_0JXH7X2FJT0G,CON_3HPMVK78PYNG,0 Volume 1 PRD_0JXH7X2FJT0G John Neal CON_3HPMVK78PYNG 0  
PRD_0SDXG4DNMMX0,CON_3HPMVK78PYNG,0 Volume 5 PRD_0SDXG4DNMMX0 John Neal CON_3HPMVK78PYNG 0  
PRD_0V7Y8NXX5H2G,CON_3HPMVK78PYNG,9 Volume 1 PRD_0V7Y8NXX5H2G John Neal CON_3HPMVK78PYNG 9  
PRD_0ZRV286JME70,CON_3HPMVK78PYNG,9 Volume 1 PRD_0ZRV286JME70 John Neal CON_3HPMVK78PYNG 9  
PRD_121KCZS30AGG,CON_3HPMVK78PYNG,9 Volume 7 PRD_121KCZS30AGG John Neal CON_3HPMVK78PYNG 9  
PRD_13A9TPAYWQPG,CON_3HPMVK78PYNG,9 Volume 1 PRD_13A9TPAYWQPG John Neal CON_3HPMVK78PYNG 9  
PRD_15Q2ANB5JSM0,CON_3HPMVK78PYNG,0 Volume 1 PRD_15Q2ANB5JSM0 John Neal CON_3HPMVK78PYNG 0  
PRD_1KH7Z1ZG9R40,CON_3HPMVK78PYNG,9 Volume 1 PRD_1KH7Z1ZG9R40 John Neal CON_3HPMVK78PYNG 9  
PRD_1N9H4B58HBV0,CON_3HPMVK78PYNG,9 Volume 3 PRD_1N9H4B58HBV0 John Neal CON_3HPMVK78PYNG 9  
PRD_1QG8W03GMFGG,CON_3HPMVK78PYNG,0 Volume 3 PRD_1QG8W03GMFGG John Neal CON_3HPMVK78PYNG 0  
PRD_1R7DZEEJ7Z10,CON_3HPMVK78PYNG,0 Volume 5 PRD_1R7DZEEJ7Z10 John Neal CON_3HPMVK78PYNG 0  
PRD_1R7EXGEJM9GG,CON_3HPMVK78PYNG,0 Volume 6 PRD_1R7EXGEJM9GG John Neal CON_3HPMVK78PYNG 0  
PRD_1WW0YW1G45Y0,CON_3HPMVK78PYNG,0 Volume 6 PRD_1WW0YW1G45Y0 John Neal CON_3HPMVK78PYNG 0  
PRD_1YJBAJ0F79B0,CON_3HPMVK78PYNG,9 Volume 6 PRD_1YJBAJ0F79B0 John Neal CON_3HPMVK78PYNG 9  
PRD_20P3H5SRQMZ0,CON_3HPMVK78PYNG,9 Volume 2 PRD_20P3H5SRQMZ0 John Neal CON_3HPMVK78PYNG 9  
PRD_22ZBP87A2AQ0,CON_3HPMVK78PYNG,0 Volume 2 PRD_22ZBP87A2AQ0 John Neal CON_3HPMVK78PYNG 0  
PRD_25H3D1E5E730,CON_3HPMVK78PYNG,9 Volume 1 PRD_25H3D1E5E730 John Neal CON_3HPMVK78PYNG 9  
PRD_25WBPYADCN1G,CON_3HPMVK78PYNG,9 Volume 5 PRD_25WBPYADCN1G John Neal CON_3HPMVK78PYNG 9  
PRD_26RJRXQ1X1VG,CON_3HPMVK78PYNG,9 Volume 3 PRD_26RJRXQ1X1VG John Neal CON_3HPMVK78PYNG 9  
PRD_28K5Y2WRPQM0,CON_3HPMVK78PYNG,0 Volume 4 PRD_28K5Y2WRPQM0 John Neal CON_3HPMVK78PYNG 0  
PRD_2KE5KR72C37G,CON_3HPMVK78PYNG,9 Volume 4 PRD_2KE5KR72C37G John Neal CON_3HPMVK78PYNG 9  
PRD_2M63BV4J806G,CON_3HPMVK78PYNG,0 Volume 1 PRD_2M63BV4J806G John Neal CON_3HPMVK78PYNG 0  
PRD_2MP5C71EANEG,CON_3HPMVK78PYNG,0 Volume 1 PRD_2MP5C71EANEG John Neal CON_3HPMVK78PYNG 0  
PRD_2PC1ZR6078V0,CON_3HPMVK78PYNG,9 Volume 8 PRD_2PC1ZR6078V0 John Neal CON_3HPMVK78PYNG 9  
PRD_2X8C6HWSDY70,CON_3HPMVK78PYNG,0 Volume 2 PRD_2X8C6HWSDY70 John Neal CON_3HPMVK78PYNG 0  
PRD_2XFRHYY17E00,CON_3HPMVK78PYNG,9 Volume 10 PRD_2XFRHYY17E00 John Neal CON_3HPMVK78PYNG 9  
PRD_2ZXRCEGG86CG,CON_3HPMVK78PYNG,0 Volume 3 PRD_2ZXRCEGG86CG John Neal CON_3HPMVK78PYNG 0  
PRD_31HJEB94E5E0,CON_3HPMVK78PYNG,9 Volume 2 PRD_31HJEB94E5E0 John Neal CON_3HPMVK78PYNG 9  
PRD_32HDER8E01VG,CON_3HPMVK78PYNG,9 Volume 2 PRD_32HDER8E01VG John Neal CON_3HPMVK78PYNG 9  
PRD_333CF34G4PHG,CON_3HPMVK78PYNG,0 Volume 8 PRD_333CF34G4PHG John Neal CON_3HPMVK78PYNG 0  
PRD_36AMENYBB4MG,CON_3HPMVK78PYNG,9 Volume 9 PRD_36AMENYBB4MG John Neal CON_3HPMVK78PYNG 9  
PRD_39NVKGZW81WG,CON_3HPMVK78PYNG,9 Volume 3 PRD_39NVKGZW81WG John Neal CON_3HPMVK78PYNG 9  
PRD_3GKY0FR1QC4G,CON_3HPMVK78PYNG,9 Volume 3 PRD_3GKY0FR1QC4G John Neal CON_3HPMVK78PYNG 9  
PRD_3H4Q3P903H3G,CON_3HPMVK78PYNG,0 Volume 4 PRD_3H4Q3P903H3G John Neal CON_3HPMVK78PYNG 0  
PRD_3J7MGKS7X1Z0,CON_3HPMVK78PYNG,0 Volume 7 PRD_3J7MGKS7X1Z0 John Neal CON_3HPMVK78PYNG 0  
PRD_3N6TB27WMSBG,CON_3HPMVK78PYNG,9 Volume 2 PRD_3N6TB27WMSBG John Neal CON_3HPMVK78PYNG 9  
PRD_3NSQG8JN5NGG,CON_3HPMVK78PYNG,9 Volume 3 PRD_3NSQG8JN5NGG John Neal CON_3HPMVK78PYNG 9  
PRD_3ST7YP8J7P80,CON_3HPMVK78PYNG,0 Volume 1 PRD_3ST7YP8J7P80 John Neal CON_3HPMVK78PYNG 0  
PRD_3XDMWV9Q8FN0,CON_3HPMVK78PYNG,9 Volume 2 PRD_3XDMWV9Q8FN0 John Neal CON_3HPMVK78PYNG 9  

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