BookWalker

home / database

product_contributors

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

19 rows where contributor_id = "CON_2E7XYK7JK0KG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_06TG3S883GPG,CON_2E7XYK7JK0KG,1 Chapter 14 PRD_06TG3S883GPG Mamitarou CON_2E7XYK7JK0KG 1  
PRD_1QDD0SXAZVSG,CON_2E7XYK7JK0KG,1 Chapter 4 PRD_1QDD0SXAZVSG Mamitarou CON_2E7XYK7JK0KG 1  
PRD_273RM3VD1Z60,CON_2E7XYK7JK0KG,1 Chapter 15 PRD_273RM3VD1Z60 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2BDYZND4707G,CON_2E7XYK7JK0KG,1 Chapter 12 PRD_2BDYZND4707G Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2E2998FE3F6G,CON_2E7XYK7JK0KG,1 Chapter 10 PRD_2E2998FE3F6G Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2E6VH9PS9X40,CON_2E7XYK7JK0KG,1 Chapter 11 PRD_2E6VH9PS9X40 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2HT81P6WPRWG,CON_2E7XYK7JK0KG,1 Chapter 16 PRD_2HT81P6WPRWG Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2KTZ5G489NW0,CON_2E7XYK7JK0KG,1 Chapter 9 PRD_2KTZ5G489NW0 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2SBW49NKQ43G,CON_2E7XYK7JK0KG,1 Chapter 3 PRD_2SBW49NKQ43G Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2SCKQVH0ZEZG,CON_2E7XYK7JK0KG,1 Chapter 19 PRD_2SCKQVH0ZEZG Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2SE9CAXYXJ10,CON_2E7XYK7JK0KG,1 Chapter 2 PRD_2SE9CAXYXJ10 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_2XX21EKAVDYG,CON_2E7XYK7JK0KG,1 Chapter 17 PRD_2XX21EKAVDYG Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3ERBSKKNRR80,CON_2E7XYK7JK0KG,1 Chapter 13 PRD_3ERBSKKNRR80 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3H45EFJ5HVA0,CON_2E7XYK7JK0KG,1 Chapter 6 PRD_3H45EFJ5HVA0 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3JQAWWG3NWB0,CON_2E7XYK7JK0KG,1 Chapter 8 PRD_3JQAWWG3NWB0 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3NKE91WH0Y60,CON_2E7XYK7JK0KG,1 Chapter 7 PRD_3NKE91WH0Y60 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3NTNS2CFXT90,CON_2E7XYK7JK0KG,1 Chapter 5 PRD_3NTNS2CFXT90 Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3WTTE708ZA9G,CON_2E7XYK7JK0KG,1 Chapter 1 PRD_3WTTE708ZA9G Mamitarou CON_2E7XYK7JK0KG 1  
PRD_3WZSSTZY7M5G,CON_2E7XYK7JK0KG,1 Chapter 18 PRD_3WZSSTZY7M5G Mamitarou CON_2E7XYK7JK0KG 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 14.582ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS