product_contributors

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

26 rows where contributor_id = "CON_3YCTBVQ4Z43G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0197C6FQ8KW0,CON_3YCTBVQ4Z43G,2 Volume 23 PRD_0197C6FQ8KW0 Riv CON_3YCTBVQ4Z43G 2  
PRD_0329Q2CVKJGG,CON_3YCTBVQ4Z43G,2 Volume 15 PRD_0329Q2CVKJGG Riv CON_3YCTBVQ4Z43G 2  
PRD_0B7GNW8G7NV0,CON_3YCTBVQ4Z43G,2 Volume 9 PRD_0B7GNW8G7NV0 Riv CON_3YCTBVQ4Z43G 2  
PRD_0D26K37SDAJ0,CON_3YCTBVQ4Z43G,2 Volume 21 PRD_0D26K37SDAJ0 Riv CON_3YCTBVQ4Z43G 2  
PRD_0K2A5R10148G,CON_3YCTBVQ4Z43G,2 Volume 22 PRD_0K2A5R10148G Riv CON_3YCTBVQ4Z43G 2  
PRD_0NXJ8VPE9M30,CON_3YCTBVQ4Z43G,2 Volume 20 PRD_0NXJ8VPE9M30 Riv CON_3YCTBVQ4Z43G 2  
PRD_0W8Q8TR2V630,CON_3YCTBVQ4Z43G,2 Volume 14 PRD_0W8Q8TR2V630 Riv CON_3YCTBVQ4Z43G 2  
PRD_15D7V91K3M50,CON_3YCTBVQ4Z43G,2 Volume 4 PRD_15D7V91K3M50 Riv CON_3YCTBVQ4Z43G 2  
PRD_168GEFZ3KY2G,CON_3YCTBVQ4Z43G,2 Volume 10 PRD_168GEFZ3KY2G Riv CON_3YCTBVQ4Z43G 2  
PRD_19GSXDPYY3K0,CON_3YCTBVQ4Z43G,2 Volume 24 PRD_19GSXDPYY3K0 Riv CON_3YCTBVQ4Z43G 2  
PRD_1RWNM65DDZFG,CON_3YCTBVQ4Z43G,2 Volume 1 PRD_1RWNM65DDZFG Riv CON_3YCTBVQ4Z43G 2  
PRD_1VGPSJDVYTJ0,CON_3YCTBVQ4Z43G,2 Volume 19 PRD_1VGPSJDVYTJ0 Riv CON_3YCTBVQ4Z43G 2  
PRD_2246HKVN8260,CON_3YCTBVQ4Z43G,2 Volume 2 PRD_2246HKVN8260 Riv CON_3YCTBVQ4Z43G 2  
PRD_25HW7306S990,CON_3YCTBVQ4Z43G,2 Volume 6 PRD_25HW7306S990 Riv CON_3YCTBVQ4Z43G 2  
PRD_28PA7BY72MP0,CON_3YCTBVQ4Z43G,2 Volume 25 PRD_28PA7BY72MP0 Riv CON_3YCTBVQ4Z43G 2  
PRD_2EQ204XZ04EG,CON_3YCTBVQ4Z43G,2 Volume 3 PRD_2EQ204XZ04EG Riv CON_3YCTBVQ4Z43G 2  
PRD_2FTC2ECK2JKG,CON_3YCTBVQ4Z43G,2 Volume 11 PRD_2FTC2ECK2JKG Riv CON_3YCTBVQ4Z43G 2  
PRD_2HDP58NY0CRG,CON_3YCTBVQ4Z43G,2 Volume 12 PRD_2HDP58NY0CRG Riv CON_3YCTBVQ4Z43G 2  
PRD_2T4MTHD95E4G,CON_3YCTBVQ4Z43G,2 Volume 8 PRD_2T4MTHD95E4G Riv CON_3YCTBVQ4Z43G 2  
PRD_2XKQRFAQX0E0,CON_3YCTBVQ4Z43G,2 Volume 18 PRD_2XKQRFAQX0E0 Riv CON_3YCTBVQ4Z43G 2  
PRD_34BEEM6WKH80,CON_3YCTBVQ4Z43G,2 Volume 26 PRD_34BEEM6WKH80 Riv CON_3YCTBVQ4Z43G 2  
PRD_371J94AWG3T0,CON_3YCTBVQ4Z43G,2 Volume 13 PRD_371J94AWG3T0 Riv CON_3YCTBVQ4Z43G 2  
PRD_38W9116GV2HG,CON_3YCTBVQ4Z43G,2 Volume 7 PRD_38W9116GV2HG Riv CON_3YCTBVQ4Z43G 2  
PRD_3N68NP718G6G,CON_3YCTBVQ4Z43G,2 Volume 16 PRD_3N68NP718G6G Riv CON_3YCTBVQ4Z43G 2  
PRD_3RVB74WFKHY0,CON_3YCTBVQ4Z43G,2 Volume 5 PRD_3RVB74WFKHY0 Riv CON_3YCTBVQ4Z43G 2  
PRD_3YCHMNMPR5MG,CON_3YCTBVQ4Z43G,2 Volume 17 PRD_3YCHMNMPR5MG Riv CON_3YCTBVQ4Z43G 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);