BookWalker

home / database

product_contributors

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

26 rows where contributor_id = "CON_1GY5DAGNFEFG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00W2QNRJZ9S0,CON_1GY5DAGNFEFG,1 Chapter 13 PRD_00W2QNRJZ9S0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_0A3CCVMZ7QZ0,CON_1GY5DAGNFEFG,1 Chapter 9 PRD_0A3CCVMZ7QZ0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_0PT0W81TFDN0,CON_1GY5DAGNFEFG,1 Chapter 7 PRD_0PT0W81TFDN0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_0SS3SFX6QBV0,CON_1GY5DAGNFEFG,1 Chapter 1 PRD_0SS3SFX6QBV0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_0WFJ42Z8KAT0,CON_1GY5DAGNFEFG,1 Chapter 6 PRD_0WFJ42Z8KAT0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_13RVPJCXAQW0,CON_1GY5DAGNFEFG,1 Chapter 4 PRD_13RVPJCXAQW0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_169A05E7PP30,CON_1GY5DAGNFEFG,1 Chapter 2 PRD_169A05E7PP30 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_19CNXB5KYM10,CON_1GY5DAGNFEFG,1 Chapter 1 PRD_19CNXB5KYM10 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_1ASE36S6X00G,CON_1GY5DAGNFEFG,1 Chapter 11 PRD_1ASE36S6X00G Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_1AZTKR89JN20,CON_1GY5DAGNFEFG,1 Chapter 10 PRD_1AZTKR89JN20 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_1Z7Y3YBFVTZG,CON_1GY5DAGNFEFG,1 Chapter 7 PRD_1Z7Y3YBFVTZG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_1ZABBZJVE8X0,CON_1GY5DAGNFEFG,1 Chapter 6 PRD_1ZABBZJVE8X0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_215N8YBQX88G,CON_1GY5DAGNFEFG,1 Chapter 12 PRD_215N8YBQX88G Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_22MTXBEDH99G,CON_1GY5DAGNFEFG,1 Chapter 5 PRD_22MTXBEDH99G Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_25T5VH5SSQFG,CON_1GY5DAGNFEFG,1 Chapter 10 PRD_25T5VH5SSQFG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_27CDM6N2M7C0,CON_1GY5DAGNFEFG,1 Chapter 14 PRD_27CDM6N2M7C0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_2Q38PJGZDC4G,CON_1GY5DAGNFEFG,1 Chapter 8 PRD_2Q38PJGZDC4G Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_2VHV05J19BBG,CON_1GY5DAGNFEFG,1 Chapter 3 PRD_2VHV05J19BBG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_2VJ58QNRR27G,CON_1GY5DAGNFEFG,1 Chapter 9 PRD_2VJ58QNRR27G Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_2Y6BKRCBNAAG,CON_1GY5DAGNFEFG,1 Chapter 2 PRD_2Y6BKRCBNAAG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_3002FWZ28QKG,CON_1GY5DAGNFEFG,1 Chapter 3 PRD_3002FWZ28QKG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_34PJSFS4MPJG,CON_1GY5DAGNFEFG,1 Chapter 12 PRD_34PJSFS4MPJG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_3B7D42VEGNHG,CON_1GY5DAGNFEFG,1 Chapter 11 PRD_3B7D42VEGNHG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_3TE5GGQ9F4D0,CON_1GY5DAGNFEFG,1 Chapter 4 PRD_3TE5GGQ9F4D0 Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_3XKKW9XRCQCG,CON_1GY5DAGNFEFG,1 Chapter 5 PRD_3XKKW9XRCQCG Touko Ikura CON_1GY5DAGNFEFG 1  
PRD_3YX0JN3P08DG,CON_1GY5DAGNFEFG,1 Chapter 8 PRD_3YX0JN3P08DG Touko Ikura CON_1GY5DAGNFEFG 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 9.291ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS