BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_3638990Q4XS0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_05X154B0H8CG,CON_3638990Q4XS0,1 Chapter 11 PRD_05X154B0H8CG Taku Kawamura CON_3638990Q4XS0 1  
PRD_091AXXQXFN20,CON_3638990Q4XS0,1 Volume 04 PRD_091AXXQXFN20 Taku Kawamura CON_3638990Q4XS0 1  
PRD_0F4XABERC5G0,CON_3638990Q4XS0,1 Chapter 7 PRD_0F4XABERC5G0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_109DJXNHHHMG,CON_3638990Q4XS0,1 Chapter 15 PRD_109DJXNHHHMG Taku Kawamura CON_3638990Q4XS0 1  
PRD_12A54E2PH16G,CON_3638990Q4XS0,1 Volume 06 PRD_12A54E2PH16G Taku Kawamura CON_3638990Q4XS0 1  
PRD_14QNEQYRP2D0,CON_3638990Q4XS0,1 Chapter 19 PRD_14QNEQYRP2D0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_14ZWXGQVXGVG,CON_3638990Q4XS0,1 Chapter 13 PRD_14ZWXGQVXGVG Taku Kawamura CON_3638990Q4XS0 1  
PRD_1CE41BX63BQ0,CON_3638990Q4XS0,1 Chapter 17 PRD_1CE41BX63BQ0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_1JE9V0ZD75DG,CON_3638990Q4XS0,1 Chapter 20 PRD_1JE9V0ZD75DG Taku Kawamura CON_3638990Q4XS0 1  
PRD_1MW3NRWACYA0,CON_3638990Q4XS0,1 Volume 01 PRD_1MW3NRWACYA0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_1PBW0HA4M3P0,CON_3638990Q4XS0,1 Chapter 3 PRD_1PBW0HA4M3P0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_1TRCJ44EG2N0,CON_3638990Q4XS0,1 Chapter 1 PRD_1TRCJ44EG2N0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_1V0978ZZ2N30,CON_3638990Q4XS0,1 Volume 08 PRD_1V0978ZZ2N30 Taku Kawamura CON_3638990Q4XS0 1  
PRD_21PP6C10JSF0,CON_3638990Q4XS0,1 Volume 07 PRD_21PP6C10JSF0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_23BV9864XR3G,CON_3638990Q4XS0,1 Chapter 14 PRD_23BV9864XR3G Taku Kawamura CON_3638990Q4XS0 1  
PRD_2D3GWJZ87WSG,CON_3638990Q4XS0,1 Chapter 12 PRD_2D3GWJZ87WSG Taku Kawamura CON_3638990Q4XS0 1  
PRD_2DC5WNSXA47G,CON_3638990Q4XS0,1 Chapter 6 PRD_2DC5WNSXA47G Taku Kawamura CON_3638990Q4XS0 1  
PRD_2ERR91MFVQ30,CON_3638990Q4XS0,1 Chapter 10 PRD_2ERR91MFVQ30 Taku Kawamura CON_3638990Q4XS0 1  
PRD_2EZAH2ZVE50G,CON_3638990Q4XS0,1 Chapter 8 PRD_2EZAH2ZVE50G Taku Kawamura CON_3638990Q4XS0 1  
PRD_2H1YQWFCDWZG,CON_3638990Q4XS0,1 Chapter 4 PRD_2H1YQWFCDWZG Taku Kawamura CON_3638990Q4XS0 1  
PRD_2Q8H34RZ4B30,CON_3638990Q4XS0,1 Chapter 18 PRD_2Q8H34RZ4B30 Taku Kawamura CON_3638990Q4XS0 1  
PRD_2T42FNV8VRD0,CON_3638990Q4XS0,1 Volume 02 PRD_2T42FNV8VRD0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_2T9E16DYQ2WG,CON_3638990Q4XS0,1 Chapter 16 PRD_2T9E16DYQ2WG Taku Kawamura CON_3638990Q4XS0 1  
PRD_39NQ0C037YA0,CON_3638990Q4XS0,1 Chapter 9 PRD_39NQ0C037YA0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_3BTS3ZGKDXSG,CON_3638990Q4XS0,1 Volume 05 PRD_3BTS3ZGKDXSG Taku Kawamura CON_3638990Q4XS0 1  
PRD_3EFTPKT0WAY0,CON_3638990Q4XS0,1 Volume 03 PRD_3EFTPKT0WAY0 Taku Kawamura CON_3638990Q4XS0 1  
PRD_3HZV67KM3N10,CON_3638990Q4XS0,1 Chapter 5 PRD_3HZV67KM3N10 Taku Kawamura CON_3638990Q4XS0 1  
PRD_3MK4SVN9J25G,CON_3638990Q4XS0,1 Chapter 2 PRD_3MK4SVN9J25G Taku Kawamura CON_3638990Q4XS0 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 17.283ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS