BookWalker

home / database

product_contributors

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

27 rows where contributor_id = "CON_1K9AR2ZH12S0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0NBMA9YRBEW0,CON_1K9AR2ZH12S0,1 Chapter 1 PRD_0NBMA9YRBEW0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_0PN5RPWPFFX0,CON_1K9AR2ZH12S0,1 Chapter 10 PRD_0PN5RPWPFFX0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_0SNADVGQ0ZXG,CON_1K9AR2ZH12S0,1 Chapter 8 PRD_0SNADVGQ0ZXG Kentarou CON_1K9AR2ZH12S0 1  
PRD_0SR4NWR2QD30,CON_1K9AR2ZH12S0,1 Chapter 5 PRD_0SR4NWR2QD30 Kentarou CON_1K9AR2ZH12S0 1  
PRD_0WEQ7FT4KC20,CON_1K9AR2ZH12S0,1 Chapter 4 PRD_0WEQ7FT4KC20 Kentarou CON_1K9AR2ZH12S0 1  
PRD_10HM3VMDZHEG,CON_1K9AR2ZH12S0,1 Chapter 27 PRD_10HM3VMDZHEG Kentarou CON_1K9AR2ZH12S0 1  
PRD_13N01DRPN4AG,CON_1K9AR2ZH12S0,1 Chapter 23 PRD_13N01DRPN4AG Kentarou CON_1K9AR2ZH12S0 1  
PRD_13PQSCHBEP50,CON_1K9AR2ZH12S0,1 Chapter 21 PRD_13PQSCHBEP50 Kentarou CON_1K9AR2ZH12S0 1  
PRD_16BKC0TRH39G,CON_1K9AR2ZH12S0,1 Chapter 19 PRD_16BKC0TRH39G Kentarou CON_1K9AR2ZH12S0 1  
PRD_19EJ96P4S1FG,CON_1K9AR2ZH12S0,1 Chapter 18 PRD_19EJ96P4S1FG Kentarou CON_1K9AR2ZH12S0 1  
PRD_1AR3ZKM2X28G,CON_1K9AR2ZH12S0,1 Chapter 17 PRD_1AR3ZKM2X28G Kentarou CON_1K9AR2ZH12S0 1  
PRD_1B22P6QA1K30,CON_1K9AR2ZH12S0,1 Chapter 25 PRD_1B22P6QA1K30 Kentarou CON_1K9AR2ZH12S0 1  
PRD_1EDW4G1RVYCG,CON_1K9AR2ZH12S0,1 Chapter 26 PRD_1EDW4G1RVYCG Kentarou CON_1K9AR2ZH12S0 1  
PRD_1R89C4A0DCW0,CON_1K9AR2ZH12S0,1 Chapter 9 PRD_1R89C4A0DCW0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_1Z4HQTZC95BG,CON_1K9AR2ZH12S0,1 Chapter 24 PRD_1Z4HQTZC95BG Kentarou CON_1K9AR2ZH12S0 1  
PRD_214EBB6KXBGG,CON_1K9AR2ZH12S0,1 Chapter 3 PRD_214EBB6KXBGG Kentarou CON_1K9AR2ZH12S0 1  
PRD_22QZSR59HCHG,CON_1K9AR2ZH12S0,1 Chapter 7 PRD_22QZSR59HCHG Kentarou CON_1K9AR2ZH12S0 1  
PRD_25KK6XHZCDCG,CON_1K9AR2ZH12S0,1 Chapter 15 PRD_25KK6XHZCDCG Kentarou CON_1K9AR2ZH12S0 1  
PRD_2CNFB4MPTTG0,CON_1K9AR2ZH12S0,1 Chapter 16 PRD_2CNFB4MPTTG0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_2GDX6CDH1FDG,CON_1K9AR2ZH12S0,1 Chapter 13 PRD_2GDX6CDH1FDG Kentarou CON_1K9AR2ZH12S0 1  
PRD_2MV61YWWG29G,CON_1K9AR2ZH12S0,1 Chapter 11 PRD_2MV61YWWG29G Kentarou CON_1K9AR2ZH12S0 1  
PRD_2Q2DHZFVDECG,CON_1K9AR2ZH12S0,1 Chapter 2 PRD_2Q2DHZFVDECG Kentarou CON_1K9AR2ZH12S0 1  
PRD_2Y1FE5B7NDJG,CON_1K9AR2ZH12S0,1 Chapter 6 PRD_2Y1FE5B7NDJG Kentarou CON_1K9AR2ZH12S0 1  
PRD_3028VPBVK4T0,CON_1K9AR2ZH12S0,1 Chapter 12 PRD_3028VPBVK4T0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_3B2S8WZMMMTG,CON_1K9AR2ZH12S0,1 Chapter 14 PRD_3B2S8WZMMMTG Kentarou CON_1K9AR2ZH12S0 1  
PRD_3XDR839HQ5V0,CON_1K9AR2ZH12S0,1 Chapter 22 PRD_3XDR839HQ5V0 Kentarou CON_1K9AR2ZH12S0 1  
PRD_3YZ9YGCFB6M0,CON_1K9AR2ZH12S0,1 Chapter 20 PRD_3YZ9YGCFB6M0 Kentarou CON_1K9AR2ZH12S0 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 11.503ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS