product_contributors

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

17 rows where contributor_id = "CON_1507YECWED80"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04A46NM7MY00,CON_1507YECWED80,7 See You There, Beyond the Ocean PRD_04A46NM7MY00 Aila Nagamine CON_1507YECWED80 7  
PRD_098JJ06M9BMG,CON_1507YECWED80,7 Volume 4 PRD_098JJ06M9BMG Aila Nagamine CON_1507YECWED80 7  
PRD_0JR5X7CR2MF0,CON_1507YECWED80,7 Volume 2 PRD_0JR5X7CR2MF0 Aila Nagamine CON_1507YECWED80 7  
PRD_0NZ4TD84AJD0,CON_1507YECWED80,7 Volume 3 PRD_0NZ4TD84AJD0 Aila Nagamine CON_1507YECWED80 7  
PRD_13JK8F3T04X0,CON_1507YECWED80,7 Volume 1 PRD_13JK8F3T04X0 Aila Nagamine CON_1507YECWED80 7  
PRD_16MFS4GEV5TG,CON_1507YECWED80,7 Volume 3 PRD_16MFS4GEV5TG Aila Nagamine CON_1507YECWED80 7  
PRD_1G0FW56ZN8N0,CON_1507YECWED80,7 Volume 2 PRD_1G0FW56ZN8N0 Aila Nagamine CON_1507YECWED80 7  
PRD_1MSKJSMZPTM0,CON_1507YECWED80,7 A Long & Short Love Story PRD_1MSKJSMZPTM0 Aila Nagamine CON_1507YECWED80 7  
PRD_25AG2F9RJJN0,CON_1507YECWED80,7 Volume 1 PRD_25AG2F9RJJN0 Aila Nagamine CON_1507YECWED80 7  
PRD_287T7T88R3GG,CON_1507YECWED80,7 Volume 2 PRD_287T7T88R3GG Aila Nagamine CON_1507YECWED80 7  
PRD_2AKCZY74JYQG,CON_1507YECWED80,7 Volume 3 PRD_2AKCZY74JYQG Aila Nagamine CON_1507YECWED80 7  
PRD_2XH61Z9ZGAB0,CON_1507YECWED80,7 Volume 2 PRD_2XH61Z9ZGAB0 Aila Nagamine CON_1507YECWED80 7  
PRD_35CD3BERJY1G,CON_1507YECWED80,7 Volume 1 PRD_35CD3BERJY1G Aila Nagamine CON_1507YECWED80 7  
PRD_3DPEVWNRX94G,CON_1507YECWED80,7 Volume 4 PRD_3DPEVWNRX94G Aila Nagamine CON_1507YECWED80 7  
PRD_3KV7BWQTQ85G,CON_1507YECWED80,7 Volume 1 PRD_3KV7BWQTQ85G Aila Nagamine CON_1507YECWED80 7  
PRD_3MDCBHW22C0G,CON_1507YECWED80,7 Volume 1 PRD_3MDCBHW22C0G Aila Nagamine CON_1507YECWED80 7  
PRD_3R73T0X22M30,CON_1507YECWED80,7 Volume 1 PRD_3R73T0X22M30 Aila Nagamine CON_1507YECWED80 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);