BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_3YNR2SKY5MA0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01RRX4KAXZ00,CON_3YNR2SKY5MA0,1 Singapore, Chapter 9 PRD_01RRX4KAXZ00 SCHO CON_3YNR2SKY5MA0 1  
PRD_049B8QDCSY70,CON_3YNR2SKY5MA0,1 Singapore, Chapter 6 PRD_049B8QDCSY70 SCHO CON_3YNR2SKY5MA0 1  
PRD_0FCA5X8S1W50,CON_3YNR2SKY5MA0,1 Singapore, Chapter 2 PRD_0FCA5X8S1W50 SCHO CON_3YNR2SKY5MA0 1  
PRD_0K0FR5Y81MX0,CON_3YNR2SKY5MA0,1 Singapore, Chapter 1 PRD_0K0FR5Y81MX0 SCHO CON_3YNR2SKY5MA0 1  
PRD_0KBN8696TG00,CON_3YNR2SKY5MA0,1 Korea II, Chapter 5 PRD_0KBN8696TG00 SCHO CON_3YNR2SKY5MA0 1  
PRD_0KE7G7GJ1E5G,CON_3YNR2SKY5MA0,1 Japan, Chapter 4 PRD_0KE7G7GJ1E5G SCHO CON_3YNR2SKY5MA0 1  
PRD_0QR5VSB96Z70,CON_3YNR2SKY5MA0,1 Korea II, Chapter 2 PRD_0QR5VSB96Z70 SCHO CON_3YNR2SKY5MA0 1  
PRD_0QWP3TJMDD4G,CON_3YNR2SKY5MA0,1 Japan, Chapter 2 PRD_0QWP3TJMDD4G SCHO CON_3YNR2SKY5MA0 1  
PRD_0TEM5C4K2Y60,CON_3YNR2SKY5MA0,1 Korea II, Chapter 1 PRD_0TEM5C4K2Y60 SCHO CON_3YNR2SKY5MA0 1  
PRD_1A3W2QA0V1G0,CON_3YNR2SKY5MA0,1 Japan, Chapter 9 PRD_1A3W2QA0V1G0 SCHO CON_3YNR2SKY5MA0 1  
PRD_1BZ3TP2NMKJG,CON_3YNR2SKY5MA0,1 Korea II, Chapter 10 PRD_1BZ3TP2NMKJG SCHO CON_3YNR2SKY5MA0 1  
PRD_1D22QXY1WHGG,CON_3YNR2SKY5MA0,1 Korea II, Chapter 6 PRD_1D22QXY1WHGG SCHO CON_3YNR2SKY5MA0 1  
PRD_1D6ZZX6D3FP0,CON_3YNR2SKY5MA0,1 Japan, Chapter 5 PRD_1D6ZZX6D3FP0 SCHO CON_3YNR2SKY5MA0 1  
PRD_1EAMM8D17NEG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 5 PRD_1EAMM8D17NEG SCHO CON_3YNR2SKY5MA0 1  
PRD_1EDJ4AWZGJHG,CON_3YNR2SKY5MA0,1 Japan, Chapter 8 PRD_1EDJ4AWZGJHG SCHO CON_3YNR2SKY5MA0 1  
PRD_1EGFCA4B70Q0,CON_3YNR2SKY5MA0,1 Japan, Chapter 7 PRD_1EGFCA4B70Q0 SCHO CON_3YNR2SKY5MA0 1  
PRD_23KG4T05ZGGG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 10 PRD_23KG4T05ZGGG SCHO CON_3YNR2SKY5MA0 1  
PRD_2600PD2FVZQG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 8 PRD_2600PD2FVZQG SCHO CON_3YNR2SKY5MA0 1  
PRD_2972CMSM3XNG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 4 PRD_2972CMSM3XNG SCHO CON_3YNR2SKY5MA0 1  
PRD_2APK11ZJ7YPG,CON_3YNR2SKY5MA0,1 Korea II, Chapter 12 PRD_2APK11ZJ7YPG SCHO CON_3YNR2SKY5MA0 1  
PRD_2ASYH2F8GTSG,CON_3YNR2SKY5MA0,1 Japan, Chapter 11 PRD_2ASYH2F8GTSG SCHO CON_3YNR2SKY5MA0 1  
PRD_2DNJY7VYFWMG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 3 PRD_2DNJY7VYFWMG SCHO CON_3YNR2SKY5MA0 1  
PRD_2HGX2GRBRGQG,CON_3YNR2SKY5MA0,1 Korea II, Chapter 4 PRD_2HGX2GRBRGQG SCHO CON_3YNR2SKY5MA0 1  
PRD_2HQEAG3QFEN0,CON_3YNR2SKY5MA0,1 Japan, Chapter 3 PRD_2HQEAG3QFEN0 SCHO CON_3YNR2SKY5MA0 1  
PRD_2M1CC3TE4ZPG,CON_3YNR2SKY5MA0,1 Korea II, Chapter 3 PRD_2M1CC3TE4ZPG SCHO CON_3YNR2SKY5MA0 1  
PRD_2M5YM4XSBDM0,CON_3YNR2SKY5MA0,1 Japan, Chapter 1 PRD_2M5YM4XSBDM0 SCHO CON_3YNR2SKY5MA0 1  
PRD_2WX1S763KHHG,CON_3YNR2SKY5MA0,1 Singapore, Chapter 12 PRD_2WX1S763KHHG SCHO CON_3YNR2SKY5MA0 1  
PRD_3145YVSSH21G,CON_3YNR2SKY5MA0,1 Japan, Chapter 12 PRD_3145YVSSH21G SCHO CON_3YNR2SKY5MA0 1  
PRD_329JV55DN9T0,CON_3YNR2SKY5MA0,1 Singapore, Chapter 11 PRD_329JV55DN9T0 SCHO CON_3YNR2SKY5MA0 1  
PRD_35CXGB0SXQR0,CON_3YNR2SKY5MA0,1 Singapore, Chapter 7 PRD_35CXGB0SXQR0 SCHO CON_3YNR2SKY5MA0 1  
PRD_35QV0DKGPK30,CON_3YNR2SKY5MA0,1 Korea II, Chapter 11 PRD_35QV0DKGPK30 SCHO CON_3YNR2SKY5MA0 1  
PRD_35TM8EV3X10G,CON_3YNR2SKY5MA0,1 Japan, Chapter 10 PRD_35TM8EV3X10G SCHO CON_3YNR2SKY5MA0 1  
PRD_384BK0DTJJ20,CON_3YNR2SKY5MA0,1 Korea II, Chapter 9 PRD_384BK0DTJJ20 SCHO CON_3YNR2SKY5MA0 1  
PRD_3CKZEJW65NY0,CON_3YNR2SKY5MA0,1 Korea II, Chapter 8 PRD_3CKZEJW65NY0 SCHO CON_3YNR2SKY5MA0 1  
PRD_3CSQ6MQ85F6G,CON_3YNR2SKY5MA0,1 Japan, Chapter 6 PRD_3CSQ6MQ85F6G SCHO CON_3YNR2SKY5MA0 1  
PRD_3CTTYKFWYH10,CON_3YNR2SKY5MA0,1 Korea II, Chapter 7 PRD_3CTTYKFWYH10 SCHO CON_3YNR2SKY5MA0 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);
Powered by Datasette · Queries took 12.501ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS