BookWalker

home / database

product_contributors

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

30 rows where contributor_id = "CON_2WRK26KNBX30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04BT6EK6DH50,CON_2WRK26KNBX30,1 Chapter 12 PRD_04BT6EK6DH50 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_08VY1E25GBAG,CON_2WRK26KNBX30,1 Chapter 6 PRD_08VY1E25GBAG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_0K1BZW4CR50G,CON_2WRK26KNBX30,1 Chapter 5 PRD_0K1BZW4CR50G Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_0KD7ABQYRFXG,CON_2WRK26KNBX30,1 Chapter 5 PRD_0KD7ABQYRFXG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_0P3QNYH14EWG,CON_2WRK26KNBX30,1 Chapter 6 PRD_0P3QNYH14EWG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_0VXF41G2Q73G,CON_2WRK26KNBX30,1 Chapter 3 PRD_0VXF41G2Q73G Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1BN08DS3NRK0,CON_2WRK26KNBX30,1 Chapter 10 PRD_1BN08DS3NRK0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1D5WH14STFE0,CON_2WRK26KNBX30,1 Chapter 4 PRD_1D5WH14STFE0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1DNWXH0PXRN0,CON_2WRK26KNBX30,1 Chapter 8 PRD_1DNWXH0PXRN0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1EQC6EAQY0F0,CON_2WRK26KNBX30,1 Chapter 2 PRD_1EQC6EAQY0F0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1NE0QWQK6650,CON_2WRK26KNBX30,1 Chapter 9 PRD_1NE0QWQK6650 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1PF898VM48FG,CON_2WRK26KNBX30,1 Chapter 3 PRD_1PF898VM48FG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_1TXRMVNY0QEG,CON_2WRK26KNBX30,1 Chapter 1 PRD_1TXRMVNY0QEG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_29DEPSFZQTGG,CON_2WRK26KNBX30,1 Chapter 1 PRD_29DEPSFZQTGG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2C3S0C91KSQG,CON_2WRK26KNBX30,1 Chapter 3 PRD_2C3S0C91KSQG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2DHH5BFCTAS0,CON_2WRK26KNBX30,1 Chapter 5 PRD_2DHH5BFCTAS0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2HEKG6PJ65G0,CON_2WRK26KNBX30,1 Chapter 4 PRD_2HEKG6PJ65G0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2HTFWM6W6ED0,CON_2WRK26KNBX30,1 Chapter 7 PRD_2HTFWM6W6ED0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2JH5PH5H0SE0,CON_2WRK26KNBX30,1 Chapter 8 PRD_2JH5PH5H0SE0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2JNPYJDWQ8KG,CON_2WRK26KNBX30,1 Chapter 7 PRD_2JNPYJDWQ8KG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2JR36KNFT6H0,CON_2WRK26KNBX30,1 Chapter 6 PRD_2JR36KNFT6H0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2NGZV4FFD4D0,CON_2WRK26KNBX30,1 Chapter 2 PRD_2NGZV4FFD4D0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2NZ23SGM24Q0,CON_2WRK26KNBX30,1 Chapter 2 PRD_2NZ23SGM24Q0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_2RSEST28EDK0,CON_2WRK26KNBX30,1 Chapter 10 PRD_2RSEST28EDK0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_35DSQ3EYQR3G,CON_2WRK26KNBX30,1 Chapter 11 PRD_35DSQ3EYQR3G Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_38282P80G72G,CON_2WRK26KNBX30,1 Chapter 9 PRD_38282P80G72G Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_3G61GY8Q69R0,CON_2WRK26KNBX30,1 Chapter 4 PRD_3G61GY8Q69R0 Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_3VBZXQQ67WZG,CON_2WRK26KNBX30,1 Chapter 1 PRD_3VBZXQQ67WZG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_3VQB856G46MG,CON_2WRK26KNBX30,1 Chapter 8 PRD_3VQB856G46MG Haruo Haruyama CON_2WRK26KNBX30 1  
PRD_3XABHWYSFW1G,CON_2WRK26KNBX30,1 Chapter 7 PRD_3XABHWYSFW1G Haruo Haruyama CON_2WRK26KNBX30 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 10.214ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS