product_contributors

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

24 rows where contributor_id = "CON_3B3SERHZ2AB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01Z803TNKMP0,CON_3B3SERHZ2AB0,2 Volume 16 PRD_01Z803TNKMP0 Taiki CON_3B3SERHZ2AB0 2  
PRD_02SV8HVKN2Q0,CON_3B3SERHZ2AB0,2 Volume 22 PRD_02SV8HVKN2Q0 Taiki CON_3B3SERHZ2AB0 2  
PRD_03C03YGEM450,CON_3B3SERHZ2AB0,2 Volume 2 PRD_03C03YGEM450 Taiki CON_3B3SERHZ2AB0 2  
PRD_0AF67839AGFG,CON_3B3SERHZ2AB0,2 Volume 7 PRD_0AF67839AGFG Taiki CON_3B3SERHZ2AB0 2  
PRD_0FZDJFNGC6DG,CON_3B3SERHZ2AB0,2 Volume 3 PRD_0FZDJFNGC6DG Taiki CON_3B3SERHZ2AB0 2  
PRD_0FZX2MGJ13QG,CON_3B3SERHZ2AB0,2 Volume 8 PRD_0FZX2MGJ13QG Taiki CON_3B3SERHZ2AB0 2  
PRD_0PHV9VW7FFPG,CON_3B3SERHZ2AB0,2 Volume 10 PRD_0PHV9VW7FFPG Taiki CON_3B3SERHZ2AB0 2  
PRD_0PNRZSDGTAE0,CON_3B3SERHZ2AB0,2 Volume 20 PRD_0PNRZSDGTAE0 Taiki CON_3B3SERHZ2AB0 2  
PRD_0QR23R69DZTG,CON_3B3SERHZ2AB0,2 Volume 6 PRD_0QR23R69DZTG Taiki CON_3B3SERHZ2AB0 2  
PRD_0S2S6G0XSG50,CON_3B3SERHZ2AB0,2 Volume 2 PRD_0S2S6G0XSG50 Taiki CON_3B3SERHZ2AB0 2  
PRD_0XJ1D3K1K8P0,CON_3B3SERHZ2AB0,2 Volume 11 PRD_0XJ1D3K1K8P0 Taiki CON_3B3SERHZ2AB0 2  
PRD_1AFKT7GKZ4G0,CON_3B3SERHZ2AB0,2 Volume 14 PRD_1AFKT7GKZ4G0 Taiki CON_3B3SERHZ2AB0 2  
PRD_1QXG37K09JFG,CON_3B3SERHZ2AB0,2 Volume 9 PRD_1QXG37K09JFG Taiki CON_3B3SERHZ2AB0 2  
PRD_1X26XMME74N0,CON_3B3SERHZ2AB0,2 Volume 1 PRD_1X26XMME74N0 Taiki CON_3B3SERHZ2AB0 2  
PRD_2EK8M9CEJCP0,CON_3B3SERHZ2AB0,2 Volume 1 PRD_2EK8M9CEJCP0 Taiki CON_3B3SERHZ2AB0 2  
PRD_2GQRVKJB61H0,CON_3B3SERHZ2AB0,2 Volume 21 PRD_2GQRVKJB61H0 Taiki CON_3B3SERHZ2AB0 2  
PRD_2NDXWY825A5G,CON_3B3SERHZ2AB0,2 Volume 19 PRD_2NDXWY825A5G Taiki CON_3B3SERHZ2AB0 2  
PRD_2TCM39FBN280,CON_3B3SERHZ2AB0,2 Volume 17 PRD_2TCM39FBN280 Taiki CON_3B3SERHZ2AB0 2  
PRD_2WV9NZRAMZN0,CON_3B3SERHZ2AB0,2 Volume 13 PRD_2WV9NZRAMZN0 Taiki CON_3B3SERHZ2AB0 2  
PRD_3039N5CYNZK0,CON_3B3SERHZ2AB0,2 Volume 12 PRD_3039N5CYNZK0 Taiki CON_3B3SERHZ2AB0 2  
PRD_367AMAPX961G,CON_3B3SERHZ2AB0,2 Volume 4 PRD_367AMAPX961G Taiki CON_3B3SERHZ2AB0 2  
PRD_3CEKSV0QZR30,CON_3B3SERHZ2AB0,2 Volume 5 PRD_3CEKSV0QZR30 Taiki CON_3B3SERHZ2AB0 2  
PRD_3FZZ0ZYAZFG0,CON_3B3SERHZ2AB0,2 Volume 18 PRD_3FZZ0ZYAZFG0 Taiki CON_3B3SERHZ2AB0 2  
PRD_3H2DA64CJSDG,CON_3B3SERHZ2AB0,2 Volume 15 PRD_3H2DA64CJSDG Taiki CON_3B3SERHZ2AB0 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);