BookWalker

home / database

product_contributors

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

39 rows where contributor_id = "CON_3T5Q7DNWWV5G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_007WMYKHQTC0,CON_3T5Q7DNWWV5G,1 Chapter 11 PRD_007WMYKHQTC0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_02Y3KVAMFHJG,CON_3T5Q7DNWWV5G,1 Chapter 2 PRD_02Y3KVAMFHJG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_05Q3BYGXGB50,CON_3T5Q7DNWWV5G,1 Chapter 3 PRD_05Q3BYGXGB50 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0FVEWQ97VRH0,CON_3T5Q7DNWWV5G,1 Chapter 10 PRD_0FVEWQ97VRH0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0JSJP1CYM8RG,CON_3T5Q7DNWWV5G,1 We're Shooting PRD_0JSJP1CYM8RG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0MQQ3HQWAMAG,CON_3T5Q7DNWWV5G,1 Chapter 9 PRD_0MQQ3HQWAMAG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0P2743C2SA6G,CON_3T5Q7DNWWV5G,1 Chapter 10 PRD_0P2743C2SA6G Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0QK91FYBHP20,CON_3T5Q7DNWWV5G,1 Chapter 7 PRD_0QK91FYBHP20 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0TJ0F3T2K4ZG,CON_3T5Q7DNWWV5G,1 Chapter 6 PRD_0TJ0F3T2K4ZG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_0X0ZGCB8G1BG,CON_3T5Q7DNWWV5G,1 Chapter 11 PRD_0X0ZGCB8G1BG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_103FGP3EGKD0,CON_3T5Q7DNWWV5G,1 Chapter 5 PRD_103FGP3EGKD0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_152MNYMNKQK0,CON_3T5Q7DNWWV5G,1 Chapter 2 PRD_152MNYMNKQK0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_16C4ABTKQQC0,CON_3T5Q7DNWWV5G,1 Chapter 4 PRD_16C4ABTKQQC0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_18Z3XVFWFN80,CON_3T5Q7DNWWV5G,1 Chapter 4 PRD_18Z3XVFWFN80 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1F0QK5MPCQM0,CON_3T5Q7DNWWV5G,1 Chapter 14 PRD_1F0QK5MPCQM0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1K9WCDQGE0Y0,CON_3T5Q7DNWWV5G,1 Chapter 4 PRD_1K9WCDQGE0Y0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1KZME78MHYA0,CON_3T5Q7DNWWV5G,1 Chapter 8 PRD_1KZME78MHYA0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1N2QBD40SW80,CON_3T5Q7DNWWV5G,1 Chapter 5 PRD_1N2QBD40SW80 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1SCNE0YZZD9G,CON_3T5Q7DNWWV5G,1 Chapter 3 PRD_1SCNE0YZZD9G Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_1XJZ5314MME0,CON_3T5Q7DNWWV5G,1 Chapter 7 PRD_1XJZ5314MME0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_25B2KVQ20TVG,CON_3T5Q7DNWWV5G,1 Chapter 5 PRD_25B2KVQ20TVG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2A878PKCYNHG,CON_3T5Q7DNWWV5G,1 Chapter 12 PRD_2A878PKCYNHG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2BWBW732YBMG,CON_3T5Q7DNWWV5G,1 Chapter 2 PRD_2BWBW732YBMG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2EBWZSJE1EGG,CON_3T5Q7DNWWV5G,1 Chapter 1 PRD_2EBWZSJE1EGG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2K649057WFW0,CON_3T5Q7DNWWV5G,1 Chapter 13 PRD_2K649057WFW0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2KR0BWAQFCT0,CON_3T5Q7DNWWV5G,1 Chapter 6 PRD_2KR0BWAQFCT0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2WV68YX9H6J0,CON_3T5Q7DNWWV5G,1 Chapter 2 PRD_2WV68YX9H6J0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_2YVQHS2P0C10,CON_3T5Q7DNWWV5G,1 Chapter 12 PRD_2YVQHS2P0C10 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_304XH18E98WG,CON_3T5Q7DNWWV5G,1 Chapter 5 PRD_304XH18E98WG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3201WG6CP790,CON_3T5Q7DNWWV5G,1 Chapter 1 PRD_3201WG6CP790 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_33T7YDG9JMXG,CON_3T5Q7DNWWV5G,1 Chapter 6 PRD_33T7YDG9JMXG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_34NCWM5GNQ3G,CON_3T5Q7DNWWV5G,1 Chapter 3 PRD_34NCWM5GNQ3G Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3BBZE77THP2G,CON_3T5Q7DNWWV5G,1 Chapter 1 PRD_3BBZE77THP2G Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3G4W0HVSZYSG,CON_3T5Q7DNWWV5G,1 Chapter 6 PRD_3G4W0HVSZYSG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3GH10MTF267G,CON_3T5Q7DNWWV5G,1 Chapter 9 PRD_3GH10MTF267G Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3MNCJ4N3VXRG,CON_3T5Q7DNWWV5G,1 Chapter 4 PRD_3MNCJ4N3VXRG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3Z5QCTP7PNYG,CON_3T5Q7DNWWV5G,1 Chapter 8 PRD_3Z5QCTP7PNYG Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3ZKPHX4ADRA0,CON_3T5Q7DNWWV5G,1 Chapter 3 PRD_3ZKPHX4ADRA0 Funa Isono CON_3T5Q7DNWWV5G 1  
PRD_3ZREFAH83VYG,CON_3T5Q7DNWWV5G,1 Chapter 1 PRD_3ZREFAH83VYG Funa Isono CON_3T5Q7DNWWV5G 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.337ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS