product_contributors

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

26 rows where contributor_id = "CON_1FQB41XPFRT0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_07TBYZSPQKRG,CON_1FQB41XPFRT0,7 Volume 1 PRD_07TBYZSPQKRG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_09S66XDTGBEG,CON_1FQB41XPFRT0,7 Volume 2 PRD_09S66XDTGBEG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0A83CB1XTXJG,CON_1FQB41XPFRT0,7 Volume 2 PRD_0A83CB1XTXJG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0AYZFECXKTV0,CON_1FQB41XPFRT0,7 Volume 2 PRD_0AYZFECXKTV0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0E0B6CT7WGBG,CON_1FQB41XPFRT0,7 Volume 2 PRD_0E0B6CT7WGBG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0PTHKEWM09Z0,CON_1FQB41XPFRT0,7 Volume 5 PRD_0PTHKEWM09Z0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0S9CD5AAYZF0,CON_1FQB41XPFRT0,7 Volume 2 PRD_0S9CD5AAYZF0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_0Z7PM8N7JDN0,CON_1FQB41XPFRT0,7 Volume 2 PRD_0Z7PM8N7JDN0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_1BNNNNSXGYH0,CON_1FQB41XPFRT0,7 Volume 3 PRD_1BNNNNSXGYH0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_1HJDNAPTE060,CON_1FQB41XPFRT0,7 Volume 1 PRD_1HJDNAPTE060 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_1MXJ6J18BJ00,CON_1FQB41XPFRT0,7 Horror Collector PRD_1MXJ6J18BJ00 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_1V7ESB2BXPV0,CON_1FQB41XPFRT0,7 Volume 1 PRD_1V7ESB2BXPV0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_21SYMGGZWZ1G,CON_1FQB41XPFRT0,7 Volume 3 PRD_21SYMGGZWZ1G Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_24BFFXFMH4S0,CON_1FQB41XPFRT0,7 Volume 4 PRD_24BFFXFMH4S0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_28XRJCT8ENVG,CON_1FQB41XPFRT0,7 Volume 1 PRD_28XRJCT8ENVG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2CAM3D6Z2CW0,CON_1FQB41XPFRT0,7 Volume 3 PRD_2CAM3D6Z2CW0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2KJPVSFDJH50,CON_1FQB41XPFRT0,7 Volume 1 PRD_2KJPVSFDJH50 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2MP5C71EANEG,CON_1FQB41XPFRT0,7 Volume 1 PRD_2MP5C71EANEG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2NRKTZJA6JCG,CON_1FQB41XPFRT0,7 Volume 4 PRD_2NRKTZJA6JCG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2YE0FFK51NB0,CON_1FQB41XPFRT0,7 Volume 2 PRD_2YE0FFK51NB0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2Z52010YGE4G,CON_1FQB41XPFRT0,7 Volume 1 PRD_2Z52010YGE4G Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_2ZXRCEGG86CG,CON_1FQB41XPFRT0,7 Volume 3 PRD_2ZXRCEGG86CG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_30ARHFZQDHM0,CON_1FQB41XPFRT0,7 Volume 1 PRD_30ARHFZQDHM0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_34AW34QTB6Y0,CON_1FQB41XPFRT0,7 Volume 3 PRD_34AW34QTB6Y0 Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_3B5YPSEJ0DYG,CON_1FQB41XPFRT0,7 Volume 2 PRD_3B5YPSEJ0DYG Madeleine Jose CON_1FQB41XPFRT0 7  
PRD_3W18R8VXP940,CON_1FQB41XPFRT0,7 Hinatsugimura PRD_3W18R8VXP940 Madeleine Jose CON_1FQB41XPFRT0 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);