BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_211GN1EZ7TY0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0093CZY8M6AG,CON_211GN1EZ7TY0,1 Chapter 3 PRD_0093CZY8M6AG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_00DXMZ1VTM80,CON_211GN1EZ7TY0,1 Chapter 11 PRD_00DXMZ1VTM80 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_04ZKZJVJG59G,CON_211GN1EZ7TY0,1 Volume 3 PRD_04ZKZJVJG59G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_072C7J3Y6KF0,CON_211GN1EZ7TY0,1 Chapter 9 PRD_072C7J3Y6KF0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0BC295NMW48G,CON_211GN1EZ7TY0,1 Volume 1 PRD_0BC295NMW48G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0BGWH6X02JE0,CON_211GN1EZ7TY0,1 Chapter 7 PRD_0BGWH6X02JE0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0E1FWSZAEHD0,CON_211GN1EZ7TY0,1 Chapter 5 PRD_0E1FWSZAEHD0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0KPPFZ5DVV7G,CON_211GN1EZ7TY0,1 Chapter 13 PRD_0KPPFZ5DVV7G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0P76TJ6G7T6G,CON_211GN1EZ7TY0,1 Chapter 11 PRD_0P76TJ6G7T6G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0SA1QR2WFR4G,CON_211GN1EZ7TY0,1 Chapter 7 PRD_0SA1QR2WFR4G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0TNH450T3S5G,CON_211GN1EZ7TY0,1 Chapter 9 PRD_0TNH450T3S5G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0XRG1CW687BG,CON_211GN1EZ7TY0,1 Chapter 5 PRD_0XRG1CW687BG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_0XZD9C7HYN90,CON_211GN1EZ7TY0,1 Chapter 13 PRD_0XZD9C7HYN90 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_11TKYCP9BA80,CON_211GN1EZ7TY0,24 Volume 4 PRD_11TKYCP9BA80 Mika Sakurano CON_211GN1EZ7TY0 24  
PRD_1H4ESZTPPGK0,CON_211GN1EZ7TY0,1 Volume 3 PRD_1H4ESZTPPGK0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_1JQYECSCAGC0,CON_211GN1EZ7TY0,1 Chapter 3 PRD_1JQYECSCAGC0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_1NTS4JMRJZJ0,CON_211GN1EZ7TY0,1 Volume 1 PRD_1NTS4JMRJZJ0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_221RVNFBP7V0,CON_211GN1EZ7TY0,1 Chapter 4 PRD_221RVNFBP7V0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_224N3PPPWNRG,CON_211GN1EZ7TY0,1 Chapter 12 PRD_224N3PPPWNRG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_24A8P0VQKFXG,CON_211GN1EZ7TY0,1 Volume 4 PRD_24A8P0VQKFXG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_254VGVAQY5S0,CON_211GN1EZ7TY0,1 Volume 2 PRD_254VGVAQY5S0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_25BMRWJ34KYG,CON_211GN1EZ7TY0,1 Chapter 8 PRD_25BMRWJ34KYG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_26N4D9GRRMZG,CON_211GN1EZ7TY0,1 Chapter 10 PRD_26N4D9GRRMZG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_26PB589DJ6T0,CON_211GN1EZ7TY0,1 Chapter 2 PRD_26PB589DJ6T0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_29R7AFC50JXG,CON_211GN1EZ7TY0,1 Chapter 6 PRD_29R7AFC50JXG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2CEQN2EFCHWG,CON_211GN1EZ7TY0,1 Chapter 4 PRD_2CEQN2EFCHWG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2EZKS1TVN5M0,CON_211GN1EZ7TY0,24 Volume 2 PRD_2EZKS1TVN5M0 Mika Sakurano CON_211GN1EZ7TY0 24  
PRD_2HZY09QJSVQ0,CON_211GN1EZ7TY0,1 Chapter 12 PRD_2HZY09QJSVQ0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2MCEKWHN5TP0,CON_211GN1EZ7TY0,1 Chapter 10 PRD_2MCEKWHN5TP0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2V2SXFKZ1SN0,CON_211GN1EZ7TY0,1 Chapter 8 PRD_2V2SXFKZ1SN0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2ZK882D1DRM0,CON_211GN1EZ7TY0,1 Chapter 6 PRD_2ZK882D1DRM0 Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_2ZQTG3NCGPSG,CON_211GN1EZ7TY0,1 Chapter 14 PRD_2ZQTG3NCGPSG Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_3GZ60NBH8G3G,CON_211GN1EZ7TY0,1 Chapter 2 PRD_3GZ60NBH8G3G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_3PJM6WBH1EN0,CON_211GN1EZ7TY0,24 Volume 3 PRD_3PJM6WBH1EN0 Mika Sakurano CON_211GN1EZ7TY0 24  
PRD_3QDPJ85VMZ2G,CON_211GN1EZ7TY0,1 Volume 2 PRD_3QDPJ85VMZ2G Mika Sakurano CON_211GN1EZ7TY0 1  
PRD_3WSBH6BVNFZG,CON_211GN1EZ7TY0,24 Volume 1 PRD_3WSBH6BVNFZG Mika Sakurano CON_211GN1EZ7TY0 24  

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 10.735ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS