BookWalker

home / database

product_contributors

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

21 rows where contributor_id = "CON_0X6CCTJY0F60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01QAYJXMAWDG,CON_0X6CCTJY0F60,24 Chapter 19 PRD_01QAYJXMAWDG Kanoko CON_0X6CCTJY0F60 24  
PRD_044585ZYPVCG,CON_0X6CCTJY0F60,24 Chapter 17 PRD_044585ZYPVCG Kanoko CON_0X6CCTJY0F60 24  
PRD_08TNVRS0JVKG,CON_0X6CCTJY0F60,24 Chapter 15 PRD_08TNVRS0JVKG Kanoko CON_0X6CCTJY0F60 24  
PRD_0GWSSJ8SYHAG,CON_0X6CCTJY0F60,24 Chapter 11 PRD_0GWSSJ8SYHAG Kanoko CON_0X6CCTJY0F60 24  
PRD_0JGHEH4ZA3HG,CON_0X6CCTJY0F60,24 Chapter 2 PRD_0JGHEH4ZA3HG Kanoko CON_0X6CCTJY0F60 24  
PRD_1BGPA2288MN0,CON_0X6CCTJY0F60,24 Chapter 16 PRD_1BGPA2288MN0 Kanoko CON_0X6CCTJY0F60 24  
PRD_1CENHGR04QS0,CON_0X6CCTJY0F60,24 Chapter 9 PRD_1CENHGR04QS0 Kanoko CON_0X6CCTJY0F60 24  
PRD_1KP90W5P1WEG,CON_0X6CCTJY0F60,24 Chapter 13 PRD_1KP90W5P1WEG Kanoko CON_0X6CCTJY0F60 24  
PRD_1KTT8XD1MAC0,CON_0X6CCTJY0F60,24 Chapter 12 PRD_1KTT8XD1MAC0 Kanoko CON_0X6CCTJY0F60 24  
PRD_1RKDN0NX8CGG,CON_0X6CCTJY0F60,24 Chapter 3 PRD_1RKDN0NX8CGG Kanoko CON_0X6CCTJY0F60 24  
PRD_1V181X53CDQ0,CON_0X6CCTJY0F60,24 Chapter 5 PRD_1V181X53CDQ0 Kanoko CON_0X6CCTJY0F60 24  
PRD_1XZRWJYNA5CG,CON_0X6CCTJY0F60,24 Chapter 21 PRD_1XZRWJYNA5CG Kanoko CON_0X6CCTJY0F60 24  
PRD_23E248JQCXY0,CON_0X6CCTJY0F60,24 Chapter 20 PRD_23E248JQCXY0 Kanoko CON_0X6CCTJY0F60 24  
PRD_27WJQVCS8WX0,CON_0X6CCTJY0F60,24 Chapter 18 PRD_27WJQVCS8WX0 Kanoko CON_0X6CCTJY0F60 24  
PRD_293WC185GT30,CON_0X6CCTJY0F60,24 Chapter 14 PRD_293WC185GT30 Kanoko CON_0X6CCTJY0F60 24  
PRD_2GWAFWZFYG6G,CON_0X6CCTJY0F60,24 Chapter 1 PRD_2GWAFWZFYG6G Kanoko CON_0X6CCTJY0F60 24  
PRD_2QDQEPMCCNZ0,CON_0X6CCTJY0F60,24 Chapter 10 PRD_2QDQEPMCCNZ0 Kanoko CON_0X6CCTJY0F60 24  
PRD_2YAZKTRPMSMG,CON_0X6CCTJY0F60,24 Chapter 7 PRD_2YAZKTRPMSMG Kanoko CON_0X6CCTJY0F60 24  
PRD_3FAQZ0CRA7NG,CON_0X6CCTJY0F60,24 Chapter 6 PRD_3FAQZ0CRA7NG Kanoko CON_0X6CCTJY0F60 24  
PRD_3SEGT7M0AC6G,CON_0X6CCTJY0F60,24 Chapter 8 PRD_3SEGT7M0AC6G Kanoko CON_0X6CCTJY0F60 24  
PRD_3YRME942PB00,CON_0X6CCTJY0F60,24 Chapter 4 PRD_3YRME942PB00 Kanoko CON_0X6CCTJY0F60 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 8.481ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS