BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_3DYT1XZ0BE30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03SJBP9SS5S0,CON_3DYT1XZ0BE30,1 Chapter 11 PRD_03SJBP9SS5S0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_06E2N9BW54R0,CON_3DYT1XZ0BE30,1 Chapter 9 PRD_06E2N9BW54R0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_09DDJF78D2Y0,CON_3DYT1XZ0BE30,1 Chapter 5 PRD_09DDJF78D2Y0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0AWX0W5613Z0,CON_3DYT1XZ0BE30,1 Chapter 7 PRD_0AWX0W5613Z0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0C3WX20J91X0,CON_3DYT1XZ0BE30,1 Chapter 3 PRD_0C3WX20J91X0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0HQHGAP18SN0,CON_3DYT1XZ0BE30,1 Chapter 19 PRD_0HQHGAP18SN0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0M403XGBMRM0,CON_3DYT1XZ0BE30,1 Chapter 17 PRD_0M403XGBMRM0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0RTKEGJDH7V0,CON_3DYT1XZ0BE30,1 Chapter 15 PRD_0RTKEGJDH7V0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_0ZB3R3FQX6T0,CON_3DYT1XZ0BE30,1 Chapter 13 PRD_0ZB3R3FQX6T0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_114F5MCBTX1G,CON_3DYT1XZ0BE30,1 Chapter 28 PRD_114F5MCBTX1G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_12QWT1J1YY2G,CON_3DYT1XZ0BE30,1 Chapter 30 PRD_12QWT1J1YY2G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_15TZQ7EE6W0G,CON_3DYT1XZ0BE30,1 Chapter 26 PRD_15TZQ7EE6W0G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_18BE2TBG2V7G,CON_3DYT1XZ0BE30,1 Chapter 24 PRD_18BE2TBG2V7G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_1CSSCD5TET6G,CON_3DYT1XZ0BE30,1 Chapter 22 PRD_1CSSCD5TET6G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_1GGF8N2MN0W0,CON_3DYT1XZ0BE30,1 Chapter 1 PRD_1GGF8N2MN0W0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_1VGXXVPNPGWG,CON_3DYT1XZ0BE30,1 Chapter 34 PRD_1VGXXVPNPGWG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_1Y1CFEGZJZ3G,CON_3DYT1XZ0BE30,1 Chapter 32 PRD_1Y1CFEGZJZ3G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_206TW0RZ748G,CON_3DYT1XZ0BE30,1 Chapter 10 PRD_206TW0RZ748G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_24QNFKT133FG,CON_3DYT1XZ0BE30,1 Chapter 8 PRD_24QNFKT133FG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2B45S6MBF2EG,CON_3DYT1XZ0BE30,1 Chapter 6 PRD_2B45S6MBF2EG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2FTM4SPDB1DG,CON_3DYT1XZ0BE30,1 Chapter 4 PRD_2FTM4SPDB1DG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2KE9Z07WAS5G,CON_3DYT1XZ0BE30,1 Chapter 20 PRD_2KE9Z07WAS5G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2QWRAK16PR4G,CON_3DYT1XZ0BE30,1 Chapter 18 PRD_2QWRAK16PR4G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2S3V7TWJZ6AG,CON_3DYT1XZ0BE30,1 Chapter 14 PRD_2S3V7TWJZ6AG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2SBBSC3KDY40,CON_3DYT1XZ0BE30,1 Chapter 37 PRD_2SBBSC3KDY40 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2TD8M638K7BG,CON_3DYT1XZ0BE30,1 Chapter 16 PRD_2TD8M638K7BG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_2XGBHDYMV59G,CON_3DYT1XZ0BE30,1 Chapter 12 PRD_2XGBHDYMV59G Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_30Z4KBX6WYJ0,CON_3DYT1XZ0BE30,1 Chapter 29 PRD_30Z4KBX6WYJ0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_37DQYYZ8RXH0,CON_3DYT1XZ0BE30,1 Chapter 27 PRD_37DQYYZ8RXH0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3A269HRK4WG0,CON_3DYT1XZ0BE30,1 Chapter 25 PRD_3A269HRK4WG0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3D116QMZCTP0,CON_3DYT1XZ0BE30,1 Chapter 21 PRD_3D116QMZCTP0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3DQGWQ3YNDF0,CON_3DYT1XZ0BE30,1 Chapter 36 PRD_3DQGWQ3YNDF0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3EGPV4TN0VQ0,CON_3DYT1XZ0BE30,1 Chapter 23 PRD_3EGPV4TN0VQ0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3JB4PCKQQ0CG,CON_3DYT1XZ0BE30,1 Chapter 2 PRD_3JB4PCKQQ0CG Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3NBN4H7G8GD0,CON_3DYT1XZ0BE30,1 Chapter 35 PRD_3NBN4H7G8GD0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3SR5P41TMZC0,CON_3DYT1XZ0BE30,1 Chapter 33 PRD_3SR5P41TMZC0 Riku Nishi CON_3DYT1XZ0BE30 1  
PRD_3WEM1Q3WGZK0,CON_3DYT1XZ0BE30,1 Chapter 31 PRD_3WEM1Q3WGZK0 Riku Nishi CON_3DYT1XZ0BE30 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 8.468ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS