BookWalker

home / database

product_contributors

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

34 rows where contributor_id = "CON_3GR2G6GC27GG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_021Q856TH3J0,CON_3GR2G6GC27GG,24 Chapter 20 PRD_021Q856TH3J0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_0BQ0H79K21R0,CON_3GR2G6GC27GG,24 Chapter 3 PRD_0BQ0H79K21R0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_0E5KWTBNE0Z0,CON_3GR2G6GC27GG,24 Chapter 1 PRD_0E5KWTBNE0Z0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_0H1JCCX3R7A0,CON_3GR2G6GC27GG,24 Chapter 30 PRD_0H1JCCX3R7A0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_122QQYZPK3MG,CON_3GR2G6GC27GG,24 Chapter 34 PRD_122QQYZPK3MG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_13E2BCQEKW3G,CON_3GR2G6GC27GG,24 Chapter 8 PRD_13E2BCQEKW3G Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_16K62HSRZ2VG,CON_3GR2G6GC27GG,24 Chapter 32 PRD_16K62HSRZ2VG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_17WJPZGGZV2G,CON_3GR2G6GC27GG,24 Chapter 6 PRD_17WJPZGGZV2G Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_19PZPVF7FCQ0,CON_3GR2G6GC27GG,24 Chapter 31 PRD_19PZPVF7FCQ0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1AEGSHBFNCW0,CON_3GR2G6GC27GG,24 Chapter 5 PRD_1AEGSHBFNCW0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1E9WPJGFCKN0,CON_3GR2G6GC27GG,24 Chapter 26 PRD_1E9WPJGFCKN0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1EZ3B44HHB30,CON_3GR2G6GC27GG,24 Chapter 4 PRD_1EZ3B44HHB30 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1HMZMMJDBMW0,CON_3GR2G6GC27GG,24 Chapter 17 PRD_1HMZMMJDBMW0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1M5E67FQQK30,CON_3GR2G6GC27GG,24 Chapter 15 PRD_1M5E67FQQK30 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1RVYHT9SKJ20,CON_3GR2G6GC27GG,24 Chapter 13 PRD_1RVYHT9SKJ20 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1V85XRSZQK0G,CON_3GR2G6GC27GG,24 Chapter 22 PRD_1V85XRSZQK0G Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1X220HKDXAS0,CON_3GR2G6GC27GG,24 Chapter 19 PRD_1X220HKDXAS0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_1Z893DB3ZH10,CON_3GR2G6GC27GG,24 Chapter 11 PRD_1Z893DB3ZH10 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_20EZ1FHZZ21G,CON_3GR2G6GC27GG,24 Chapter 18 PRD_20EZ1FHZZ21G Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_29WBBHRG00FG,CON_3GR2G6GC27GG,24 Chapter 2 PRD_29WBBHRG00FG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_2ESVBP2C5FQ0,CON_3GR2G6GC27GG,24 Chapter 21 PRD_2ESVBP2C5FQ0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_2GZ433TA0PR0,CON_3GR2G6GC27GG,24 Chapter 27 PRD_2GZ433TA0PR0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_2QET6NC167SG,CON_3GR2G6GC27GG,24 Chapter 29 PRD_2QET6NC167SG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_30BY87EVH240,CON_3GR2G6GC27GG,24 Chapter 33 PRD_30BY87EVH240 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_31QAXN1KHWK0,CON_3GR2G6GC27GG,24 Chapter 7 PRD_31QAXN1KHWK0 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_31WTQ85CCKCG,CON_3GR2G6GC27GG,24 Chapter 9 PRD_31WTQ85CCKCG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_380MW81AEK5G,CON_3GR2G6GC27GG,24 Chapter 25 PRD_380MW81AEK5G Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_39F4C4QYFFMG,CON_3GR2G6GC27GG,24 Chapter 28 PRD_39F4C4QYFFMG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3QW6DYWJ9MKG,CON_3GR2G6GC27GG,24 Chapter 16 PRD_3QW6DYWJ9MKG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3S31A4RYHJHG,CON_3GR2G6GC27GG,24 Chapter 12 PRD_3S31A4RYHJHG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3S4WK1KF9460,CON_3GR2G6GC27GG,24 Chapter 36 PRD_3S4WK1KF9460 Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3TJPRHYMNKJG,CON_3GR2G6GC27GG,24 Chapter 14 PRD_3TJPRHYMNKJG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3XHHNQT0XHGG,CON_3GR2G6GC27GG,24 Chapter 10 PRD_3XHHNQT0XHGG Yoshikazu Okada CON_3GR2G6GC27GG 24  
PRD_3XNFYMCHN350,CON_3GR2G6GC27GG,24 Chapter 35 PRD_3XNFYMCHN350 Yoshikazu Okada CON_3GR2G6GC27GG 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.021ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS