product_contributors

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

18 rows where contributor_id = "CON_0VPBJ3QRQ6C0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0A8T9JVRKJZG,CON_0VPBJ3QRQ6C0,7 Volume 2 PRD_0A8T9JVRKJZG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_0AGQ07YSZ38G,CON_0VPBJ3QRQ6C0,7 Volume 2 PRD_0AGQ07YSZ38G Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_0DP6DJH7REGG,CON_0VPBJ3QRQ6C0,7 Volume 4 PRD_0DP6DJH7REGG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_0EWMJBR87B60,CON_0VPBJ3QRQ6C0,7 Volume 2 PRD_0EWMJBR87B60 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_0JYVTVT3ZKKG,CON_0VPBJ3QRQ6C0,7 Volume 1 PRD_0JYVTVT3ZKKG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_0P7G8Y6K03BG,CON_0VPBJ3QRQ6C0,7 Volume 3 PRD_0P7G8Y6K03BG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_1BB0NJZ8ANB0,CON_0VPBJ3QRQ6C0,7 Volume 1 PRD_1BB0NJZ8ANB0 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_1E71J6MVJNFG,CON_0VPBJ3QRQ6C0,7 Volume 1 PRD_1E71J6MVJNFG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_1G821V0SMJ90,CON_0VPBJ3QRQ6C0,7 Yankee & Carameliser PRD_1G821V0SMJ90 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_1T30R94K08JG,CON_0VPBJ3QRQ6C0,7 Volume 26 PRD_1T30R94K08JG Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_21TWWADJN5T0,CON_0VPBJ3QRQ6C0,7 Volume 27 PRD_21TWWADJN5T0 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_2QMJYQ7ASH20,CON_0VPBJ3QRQ6C0,7 Volume 25 PRD_2QMJYQ7ASH20 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_2T8SMQ2MZ020,CON_0VPBJ3QRQ6C0,7 Volume 2 PRD_2T8SMQ2MZ020 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_2VGFCDJ3M19G,CON_0VPBJ3QRQ6C0,7 Volume 1 PRD_2VGFCDJ3M19G Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_37FH5F60BKD0,CON_0VPBJ3QRQ6C0,7 Volume 3 PRD_37FH5F60BKD0 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_3859ASWZ64J0,CON_0VPBJ3QRQ6C0,7 Volume 1 PRD_3859ASWZ64J0 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_3KZE6V056D00,CON_0VPBJ3QRQ6C0,7 Volume 2 PRD_3KZE6V056D00 Oliva Osanz CON_0VPBJ3QRQ6C0 7  
PRD_3WWKKGE1TC60,CON_0VPBJ3QRQ6C0,7 Volume 24 PRD_3WWKKGE1TC60 Oliva Osanz CON_0VPBJ3QRQ6C0 7  

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);