BookWalker

home / database

product_contributors

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

39 rows where contributor_id = "CON_2VJ8GJ5Z4TGG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_09XSPXG6DS7G,CON_2VJ8GJ5Z4TGG,1 Chapter 7 PRD_09XSPXG6DS7G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0AGP62NS4GX0,CON_2VJ8GJ5Z4TGG,1 Chapter 7 PRD_0AGP62NS4GX0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0CFZRFAX3A10,CON_2VJ8GJ5Z4TGG,1 Chapter 8 PRD_0CFZRFAX3A10 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0EKMSY2ZYMQ0,CON_2VJ8GJ5Z4TGG,1 Chapter 11 PRD_0EKMSY2ZYMQ0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0EP11ZAB52MG,CON_2VJ8GJ5Z4TGG,1 Chapter 4 PRD_0EP11ZAB52MG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0FYRA2BF4Y2G,CON_2VJ8GJ5Z4TGG,1 Chapter 21 PRD_0FYRA2BF4Y2G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0JEQW735B8J0,CON_2VJ8GJ5Z4TGG,1 Chapter 1 PRD_0JEQW735B8J0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0WVZ7N5MMGS0,CON_2VJ8GJ5Z4TGG,1 Chapter 15 PRD_0WVZ7N5MMGS0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_0Y1AQHKQCYMG,CON_2VJ8GJ5Z4TGG,1 Chapter 3 PRD_0Y1AQHKQCYMG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_12EKQC11T580,CON_2VJ8GJ5Z4TGG,1 Chapter 2 PRD_12EKQC11T580 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_16MRK6A8JQ0G,CON_2VJ8GJ5Z4TGG,1 Chapter 13 PRD_16MRK6A8JQ0G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_18VT58NE3J90,CON_2VJ8GJ5Z4TGG,1 Chapter 17 PRD_18VT58NE3J90 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_19GWRBPY193G,CON_2VJ8GJ5Z4TGG,1 Chapter 5 PRD_19GWRBPY193G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1A4F26AMYRSG,CON_2VJ8GJ5Z4TGG,1 Chapter 20 PRD_1A4F26AMYRSG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1B5B43X00CTG,CON_2VJ8GJ5Z4TGG,1 Chapter 5 PRD_1B5B43X00CTG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1CMS3M5BZKFG,CON_2VJ8GJ5Z4TGG,1 Chapter 6 PRD_1CMS3M5BZKFG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1KA5Y3Z8YAS0,CON_2VJ8GJ5Z4TGG,1 Chapter 4 PRD_1KA5Y3Z8YAS0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1S20EXWA953G,CON_2VJ8GJ5Z4TGG,1 Chapter 2 PRD_1S20EXWA953G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_1TJY7385M1QG,CON_2VJ8GJ5Z4TGG,1 Chapter 7 PRD_1TJY7385M1QG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_21HPBJP3YYFG,CON_2VJ8GJ5Z4TGG,1 Chapter 12 PRD_21HPBJP3YYFG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2466N5G5TXEG,CON_2VJ8GJ5Z4TGG,1 Chapter 10 PRD_2466N5G5TXEG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2BMHXK11FTG0,CON_2VJ8GJ5Z4TGG,1 Chapter 9 PRD_2BMHXK11FTG0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2KS52EGTBGF0,CON_2VJ8GJ5Z4TGG,1 Chapter 6 PRD_2KS52EGTBGF0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2QCHQX5FS3F0,CON_2VJ8GJ5Z4TGG,1 Chapter 3 PRD_2QCHQX5FS3F0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2QK2ZYCVFHCG,CON_2VJ8GJ5Z4TGG,1 Chapter 4 PRD_2QK2ZYCVFHCG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2VX02G6J52E0,CON_2VJ8GJ5Z4TGG,1 Chapter 1 PRD_2VX02G6J52E0 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2WEX8T2MAX40,CON_2VJ8GJ5Z4TGG,1 Chapter 1 PRD_2WEX8T2MAX40 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2X37RZMSJZ8G,CON_2VJ8GJ5Z4TGG,1 Chapter 14 PRD_2X37RZMSJZ8G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2XFA0MY6BZJG,CON_2VJ8GJ5Z4TGG,1 Chapter 8 PRD_2XFA0MY6BZJG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_2YJQDCTQPG9G,CON_2VJ8GJ5Z4TGG,1 Chapter 9 PRD_2YJQDCTQPG9G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_30QATHN56SNG,CON_2VJ8GJ5Z4TGG,1 Chapter 9 PRD_30QATHN56SNG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_37W31B86SMTG,CON_2VJ8GJ5Z4TGG,1 Chapter 18 PRD_37W31B86SMTG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_38DQMGNSX790,CON_2VJ8GJ5Z4TGG,1 Chapter 19 PRD_38DQMGNSX790 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3AJJCYA95KSG,CON_2VJ8GJ5Z4TGG,1 Chapter 16 PRD_3AJJCYA95KSG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3DZ8W5RYWJGG,CON_2VJ8GJ5Z4TGG,1 Chapter 5 PRD_3DZ8W5RYWJGG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3FNAAMSQRTDG,CON_2VJ8GJ5Z4TGG,1 Chapter 3 PRD_3FNAAMSQRTDG Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3K9FXVF6RJ5G,CON_2VJ8GJ5Z4TGG,1 Chapter 2 PRD_3K9FXVF6RJ5G Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3RT6RDVAJ070,CON_2VJ8GJ5Z4TGG,1 Chapter 6 PRD_3RT6RDVAJ070 Alto Mizuno CON_2VJ8GJ5Z4TGG 1  
PRD_3XTQ79HP5TCG,CON_2VJ8GJ5Z4TGG,1 Chapter 8 PRD_3XTQ79HP5TCG Alto Mizuno CON_2VJ8GJ5Z4TGG 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 15.36ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS