product_contributors

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

49 rows where contributor_id = "CON_2BB2AP227JHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_006EAAGCG4H0,CON_2BB2AP227JHG,2 Volume 14 PRD_006EAAGCG4H0 Kinta CON_2BB2AP227JHG 2  
PRD_025MY4M4CE9G,CON_2BB2AP227JHG,2 Volume 10 PRD_025MY4M4CE9G Kinta CON_2BB2AP227JHG 2  
PRD_0AKYHDANYHC0,CON_2BB2AP227JHG,2 Volume 4 PRD_0AKYHDANYHC0 Kinta CON_2BB2AP227JHG 2  
PRD_0DRJGYCVJBY0,CON_2BB2AP227JHG,2 Volume 5 PRD_0DRJGYCVJBY0 Kinta CON_2BB2AP227JHG 2  
PRD_0SXEJHJH3THG,CON_2BB2AP227JHG,2 Volume 5 PRD_0SXEJHJH3THG Kinta CON_2BB2AP227JHG 2  
PRD_0W8E0VX2M6FG,CON_2BB2AP227JHG,2 Volume 1 PRD_0W8E0VX2M6FG Kinta CON_2BB2AP227JHG 2  
PRD_0ZNY575677B0,CON_2BB2AP227JHG,2 Volume 11 PRD_0ZNY575677B0 Kinta CON_2BB2AP227JHG 2  
PRD_13NAEEQQ8XDG,CON_2BB2AP227JHG,2 Volume 3 PRD_13NAEEQQ8XDG Kinta CON_2BB2AP227JHG 2  
PRD_1411TTKTF2V0,CON_2BB2AP227JHG,1 Volume 10 PRD_1411TTKTF2V0 Kinta CON_2BB2AP227JHG 1  
PRD_1BN28K2WX4E0,CON_2BB2AP227JHG,1 Volume 12 PRD_1BN28K2WX4E0 Kinta CON_2BB2AP227JHG 1  
PRD_1BW5KDDSBBK0,CON_2BB2AP227JHG,2 Volume 2 PRD_1BW5KDDSBBK0 Kinta CON_2BB2AP227JHG 2  
PRD_1CK4HZRVRE2G,CON_2BB2AP227JHG,1 Volume 9 PRD_1CK4HZRVRE2G Kinta CON_2BB2AP227JHG 1  
PRD_1ET8XVJY0RHG,CON_2BB2AP227JHG,1 Volume 13 PRD_1ET8XVJY0RHG Kinta CON_2BB2AP227JHG 1  
PRD_1FAY4EN8J1F0,CON_2BB2AP227JHG,2 Volume 2 PRD_1FAY4EN8J1F0 Kinta CON_2BB2AP227JHG 2  
PRD_1FRA3BKDFAQ0,CON_2BB2AP227JHG,1 Volume 7 PRD_1FRA3BKDFAQ0 Kinta CON_2BB2AP227JHG 1  
PRD_1HY3ETX52360,CON_2BB2AP227JHG,1 Volume 5 PRD_1HY3ETX52360 Kinta CON_2BB2AP227JHG 1  
PRD_1NMCV6EQ4QKG,CON_2BB2AP227JHG,2 Volume 11 PRD_1NMCV6EQ4QKG Kinta CON_2BB2AP227JHG 2  
PRD_1TR1804DJZP0,CON_2BB2AP227JHG,2 Volume 5 PRD_1TR1804DJZP0 Kinta CON_2BB2AP227JHG 2  
PRD_1V3ZNQCMXTH0,CON_2BB2AP227JHG,2 Volume 12 PRD_1V3ZNQCMXTH0 Kinta CON_2BB2AP227JHG 2  
PRD_1XJW78A5ERSG,CON_2BB2AP227JHG,2 Volume 1 PRD_1XJW78A5ERSG Kinta CON_2BB2AP227JHG 2  
PRD_1ZPHBNS7G8KG,CON_2BB2AP227JHG,1 Volume 1 PRD_1ZPHBNS7G8KG Kinta CON_2BB2AP227JHG 1  
PRD_22JP15JVN9JG,CON_2BB2AP227JHG,2 Volume 6 PRD_22JP15JVN9JG Kinta CON_2BB2AP227JHG 2  
PRD_23PCK2CJDBH0,CON_2BB2AP227JHG,2 Volume 13 PRD_23PCK2CJDBH0 Kinta CON_2BB2AP227JHG 2  
PRD_2B596RMFJ0T0,CON_2BB2AP227JHG,2 Volume 3 PRD_2B596RMFJ0T0 Kinta CON_2BB2AP227JHG 2  
PRD_2CP0FWP92PS0,CON_2BB2AP227JHG,1 Volume 8 PRD_2CP0FWP92PS0 Kinta CON_2BB2AP227JHG 1  
PRD_2ESDCJBHX3SG,CON_2BB2AP227JHG,1 Volume 6 PRD_2ESDCJBHX3SG Kinta CON_2BB2AP227JHG 1  
PRD_2FPV0YZX088G,CON_2BB2AP227JHG,2 Volume 6 PRD_2FPV0YZX088G Kinta CON_2BB2AP227JHG 2  
PRD_2GHGN4Y1NEA0,CON_2BB2AP227JHG,2 Volume 9 PRD_2GHGN4Y1NEA0 Kinta CON_2BB2AP227JHG 2  
PRD_2JSF4A3CMQMG,CON_2BB2AP227JHG,2 Volume 3 PRD_2JSF4A3CMQMG Kinta CON_2BB2AP227JHG 2  
PRD_2P5AWQ9AN4EG,CON_2BB2AP227JHG,2 Volume 7 PRD_2P5AWQ9AN4EG Kinta CON_2BB2AP227JHG 2  
PRD_2Q3CKNNZQ60G,CON_2BB2AP227JHG,2 Volume 9 PRD_2Q3CKNNZQ60G Kinta CON_2BB2AP227JHG 2  
PRD_2QKM4ZBM3BQG,CON_2BB2AP227JHG,2 Volume 1 PRD_2QKM4ZBM3BQG Kinta CON_2BB2AP227JHG 2  
PRD_2RV93HE0BQTG,CON_2BB2AP227JHG,2 Volume 1 PRD_2RV93HE0BQTG Kinta CON_2BB2AP227JHG 2  
PRD_2VJQWYGVDRS0,CON_2BB2AP227JHG,2 Volume 8 PRD_2VJQWYGVDRS0 Kinta CON_2BB2AP227JHG 2  
PRD_2XYNQGCZY9N0,CON_2BB2AP227JHG,1 Volume 11 PRD_2XYNQGCZY9N0 Kinta CON_2BB2AP227JHG 1  
PRD_2Y4PK50C9K20,CON_2BB2AP227JHG,2 Volume 4 PRD_2Y4PK50C9K20 Kinta CON_2BB2AP227JHG 2  
PRD_2YPXB9718WMG,CON_2BB2AP227JHG,1 Volume 2 PRD_2YPXB9718WMG Kinta CON_2BB2AP227JHG 1  
PRD_31BCX0V7FWWG,CON_2BB2AP227JHG,2 Volume 1 PRD_31BCX0V7FWWG Kinta CON_2BB2AP227JHG 2  
PRD_31HTPH95W2WG,CON_2BB2AP227JHG,2 Volume 4 PRD_31HTPH95W2WG Kinta CON_2BB2AP227JHG 2  
PRD_31TZ314TQJ90,CON_2BB2AP227JHG,2 Volume 8 PRD_31TZ314TQJ90 Kinta CON_2BB2AP227JHG 2  
PRD_34N6TG5QM4WG,CON_2BB2AP227JHG,2 Volume 3 PRD_34N6TG5QM4WG Kinta CON_2BB2AP227JHG 2  
PRD_386S7TNC0FW0,CON_2BB2AP227JHG,2 Volume 7 PRD_386S7TNC0FW0 Kinta CON_2BB2AP227JHG 2  
PRD_38BZQ7F0Y5CG,CON_2BB2AP227JHG,2 Volume 2 PRD_38BZQ7F0Y5CG Kinta CON_2BB2AP227JHG 2  
PRD_39ZB8J5VS6AG,CON_2BB2AP227JHG,2 Volume 6 PRD_39ZB8J5VS6AG Kinta CON_2BB2AP227JHG 2  
PRD_3DC17EG5XB60,CON_2BB2AP227JHG,2 Volume 4 PRD_3DC17EG5XB60 Kinta CON_2BB2AP227JHG 2  
PRD_3HGEG9RK1EZG,CON_2BB2AP227JHG,2 Volume 10 PRD_3HGEG9RK1EZG Kinta CON_2BB2AP227JHG 2  
PRD_3MES5MMQX120,CON_2BB2AP227JHG,2 Volume 2 PRD_3MES5MMQX120 Kinta CON_2BB2AP227JHG 2  
PRD_3RZ9Q7PSS010,CON_2BB2AP227JHG,2 Volume 12 PRD_3RZ9Q7PSS010 Kinta CON_2BB2AP227JHG 2  
PRD_3VRVFZS7Y5A0,CON_2BB2AP227JHG,1 Volume 4 PRD_3VRVFZS7Y5A0 Kinta CON_2BB2AP227JHG 1  

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