BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_33F7G3704K30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02AGXV296ZD0,CON_33F7G3704K30,1 Volume 7 PRD_02AGXV296ZD0 Naoshi Komi CON_33F7G3704K30 1  
PRD_056MA0EYNH80,CON_33F7G3704K30,1 Volume 23 PRD_056MA0EYNH80 Naoshi Komi CON_33F7G3704K30 1  
PRD_059KT2SNEYK0,CON_33F7G3704K30,1 Volume 21 PRD_059KT2SNEYK0 Naoshi Komi CON_33F7G3704K30 1  
PRD_0HW52E3505BG,CON_33F7G3704K30,1 Volume 16 PRD_0HW52E3505BG Naoshi Komi CON_33F7G3704K30 1  
PRD_147W9C2X4QMG,CON_33F7G3704K30,1 Volume 22 PRD_147W9C2X4QMG Naoshi Komi CON_33F7G3704K30 1  
PRD_18HJCZMVXRP0,CON_33F7G3704K30,1 Volume 3 PRD_18HJCZMVXRP0 Naoshi Komi CON_33F7G3704K30 1  
PRD_18MCM0W70PVG,CON_33F7G3704K30,1 Volume 20 PRD_18MCM0W70PVG Naoshi Komi CON_33F7G3704K30 1  
PRD_1FAZ7KY9CNTG,CON_33F7G3704K30,1 Volume 18 PRD_1FAZ7KY9CNTG Naoshi Komi CON_33F7G3704K30 1  
PRD_1GXD2VQBJVG0,CON_33F7G3704K30,1 Volume 12 PRD_1GXD2VQBJVG0 Naoshi Komi CON_33F7G3704K30 1  
PRD_1GYGTTFRCDJG,CON_33F7G3704K30,1 Volume 15 PRD_1GYGTTFRCDJG Naoshi Komi CON_33F7G3704K30 1  
PRD_1QKWCEHDYTQ0,CON_33F7G3704K30,1 Volume 9 PRD_1QKWCEHDYTQ0 Naoshi Komi CON_33F7G3704K30 1  
PRD_1T0CZ1JQTSP0,CON_33F7G3704K30,1 Volume 8 PRD_1T0CZ1JQTSP0 Naoshi Komi CON_33F7G3704K30 1  
PRD_1X7FM7EW37M0,CON_33F7G3704K30,1 Volume 6 PRD_1X7FM7EW37M0 Naoshi Komi CON_33F7G3704K30 1  
PRD_1YPZAMCT6RN0,CON_33F7G3704K30,1 Volume 5 PRD_1YPZAMCT6RN0 Naoshi Komi CON_33F7G3704K30 1  
PRD_24SDHQZSQJRG,CON_33F7G3704K30,1 Volume 24 PRD_24SDHQZSQJRG Naoshi Komi CON_33F7G3704K30 1  
PRD_2BPVKB8TCX2G,CON_33F7G3704K30,1 Volume 2 PRD_2BPVKB8TCX2G Naoshi Komi CON_33F7G3704K30 1  
PRD_2S8CHY9PP3S0,CON_33F7G3704K30,1 Volume 11 PRD_2S8CHY9PP3S0 Naoshi Komi CON_33F7G3704K30 1  
PRD_2TVW6BCCA4T0,CON_33F7G3704K30,1 Volume 14 PRD_2TVW6BCCA4T0 Naoshi Komi CON_33F7G3704K30 1  
PRD_2XYZWHBRJ2R0,CON_33F7G3704K30,1 Volume 10 PRD_2XYZWHBRJ2R0 Naoshi Komi CON_33F7G3704K30 1  
PRD_3358XFEAQT0G,CON_33F7G3704K30,1 Volume 25 PRD_3358XFEAQT0G Naoshi Komi CON_33F7G3704K30 1  
PRD_37X6R4VBD5AG,CON_33F7G3704K30,1 Volume 1 PRD_37X6R4VBD5AG Naoshi Komi CON_33F7G3704K30 1  
PRD_3DJ7RW9EAMA0,CON_33F7G3704K30,1 Volume 17 PRD_3DJ7RW9EAMA0 Naoshi Komi CON_33F7G3704K30 1  
PRD_3EXQD9F4ENB0,CON_33F7G3704K30,1 Volume 19 PRD_3EXQD9F4ENB0 Naoshi Komi CON_33F7G3704K30 1  
PRD_3NMBYQR7PB10,CON_33F7G3704K30,1 Volume 13 PRD_3NMBYQR7PB10 Naoshi Komi CON_33F7G3704K30 1  
PRD_3WY73YZZ574G,CON_33F7G3704K30,1 Volume 4 PRD_3WY73YZZ574G Naoshi Komi CON_33F7G3704K30 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 8.474ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS