BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_038PWA7K31XG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0CZVFXXSS8C0,CON_038PWA7K31XG,1 Volume 2 PRD_0CZVFXXSS8C0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_0E8QHWE18Q7G,CON_038PWA7K31XG,1 Volume 4 PRD_0E8QHWE18Q7G Yuki Yaku CON_038PWA7K31XG 1  
PRD_0NFX6169K63G,CON_038PWA7K31XG,1 Volume 3 PRD_0NFX6169K63G Yuki Yaku CON_038PWA7K31XG 1  
PRD_1F7Q59V37QC0,CON_038PWA7K31XG,1 Volume 10 PRD_1F7Q59V37QC0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_1FD2R9J4P850,CON_038PWA7K31XG,1 Volume 1 PRD_1FD2R9J4P850 Yuki Yaku CON_038PWA7K31XG 1  
PRD_1GFHBYS6SJ80,CON_038PWA7K31XG,1 Volume 5 PRD_1GFHBYS6SJ80 Yuki Yaku CON_038PWA7K31XG 1  
PRD_1Y0CHFWT41GG,CON_038PWA7K31XG,1 Volume 3 PRD_1Y0CHFWT41GG Yuki Yaku CON_038PWA7K31XG 1  
PRD_2421762MFJQ0,CON_038PWA7K31XG,1 Volume 1 PRD_2421762MFJQ0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_28M1HKQE5GBG,CON_038PWA7K31XG,1 Volume 9 PRD_28M1HKQE5GBG Yuki Yaku CON_038PWA7K31XG 1  
PRD_2JG0Y0WE4NS0,CON_038PWA7K31XG,1 Volume 11 PRD_2JG0Y0WE4NS0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_2MBHAET0V3S0,CON_038PWA7K31XG,1 Volume 6.5 PRD_2MBHAET0V3S0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_358ANCMFAJXG,CON_038PWA7K31XG,1 Volume 6 PRD_358ANCMFAJXG Yuki Yaku CON_038PWA7K31XG 1  
PRD_3691MHWP7EEG,CON_038PWA7K31XG,1 Volume 2 PRD_3691MHWP7EEG Yuki Yaku CON_038PWA7K31XG 1  
PRD_3HTZJHM5XR60,CON_038PWA7K31XG,1 Volume 8 PRD_3HTZJHM5XR60 Yuki Yaku CON_038PWA7K31XG 1  
PRD_3SDYMAPD8DJ0,CON_038PWA7K31XG,1 Volume 8.5 PRD_3SDYMAPD8DJ0 Yuki Yaku CON_038PWA7K31XG 1  
PRD_3TG9EVQW59QG,CON_038PWA7K31XG,1 Volume 7 PRD_3TG9EVQW59QG Yuki Yaku CON_038PWA7K31XG 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.572ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS