BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_2Q8JJZ8QGXZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01BQ52Q9PSDG,CON_2Q8JJZ8QGXZG,2 Volume 3 PRD_01BQ52Q9PSDG Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_01S4RP8C8BB0,CON_2Q8JJZ8QGXZG,2 Volume 5 PRD_01S4RP8C8BB0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_04FQA95PMAA0,CON_2Q8JJZ8QGXZG,2 Volume 3 PRD_04FQA95PMAA0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_10Q1F1CME4CG,CON_2Q8JJZ8QGXZG,2 Volume 7 PRD_10Q1F1CME4CG Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_13Y9S0K4H79G,CON_2Q8JJZ8QGXZG,2 Volume 1 PRD_13Y9S0K4H79G Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_1N3Q78Q5T7FG,CON_2Q8JJZ8QGXZG,2 Volume 13 PRD_1N3Q78Q5T7FG Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_1PD4NNN3HR8G,CON_2Q8JJZ8QGXZG,2 Volume 14 PRD_1PD4NNN3HR8G Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_1SG7JVH866EG,CON_2Q8JJZ8QGXZG,2 Volume 10 PRD_1SG7JVH866EG Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_1W6PWEJJ25DG,CON_2Q8JJZ8QGXZG,2 Volume 8 PRD_1W6PWEJJ25DG Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_296X65EJBVV0,CON_2Q8JJZ8QGXZG,2 Volume 1 PRD_296X65EJBVV0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_31WA28JK5VP0,CON_2Q8JJZ8QGXZG,2 Volume 2 PRD_31WA28JK5VP0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_32FYPRXQ05X0,CON_2Q8JJZ8QGXZG,2 Volume 6 PRD_32FYPRXQ05X0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_35JSKYS38330,CON_2Q8JJZ8QGXZG,2 Volume 2 PRD_35JSKYS38330 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_36W90BZSC4W0,CON_2Q8JJZ8QGXZG,2 Volume 4 PRD_36W90BZSC4W0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_3G5W3BAYKSS0,CON_2Q8JJZ8QGXZG,2 Volume 15 PRD_3G5W3BAYKSS0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_3MTFEY40ZRR0,CON_2Q8JJZ8QGXZG,2 Volume 12 PRD_3MTFEY40ZRR0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_3V8ZSH6AR7Z0,CON_2Q8JJZ8QGXZG,2 Volume 11 PRD_3V8ZSH6AR7Z0 Betten Court CON_2Q8JJZ8QGXZG 2  
PRD_3ZSEB40D46Y0,CON_2Q8JJZ8QGXZG,2 Volume 9 PRD_3ZSEB40D46Y0 Betten Court CON_2Q8JJZ8QGXZG 2  

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