BookWalker

home / database

product_contributors

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

40 rows where contributor_id = "CON_0FZGY9QZQSW0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00KTMMYXST2G,CON_0FZGY9QZQSW0,18 Chapter 8 PRD_00KTMMYXST2G kyo CON_0FZGY9QZQSW0 18  
PRD_070N67R05S1G,CON_0FZGY9QZQSW0,18 Chapter 6 PRD_070N67R05S1G kyo CON_0FZGY9QZQSW0 18  
PRD_0BH5HTTA1R0G,CON_0FZGY9QZQSW0,18 Chapter 4 PRD_0BH5HTTA1R0G kyo CON_0FZGY9QZQSW0 18  
PRD_0BJB9SJYVA30,CON_0FZGY9QZQSW0,18 Chapter 23 PRD_0BJB9SJYVA30 kyo CON_0FZGY9QZQSW0 18  
PRD_0BW9ZSHJX0PG,CON_0FZGY9QZQSW0,18 Chapter 28 PRD_0BW9ZSHJX0PG kyo CON_0FZGY9QZQSW0 18  
PRD_0E7M3DMCA77G,CON_0FZGY9QZQSW0,18 Chapter 1 PRD_0E7M3DMCA77G kyo CON_0FZGY9QZQSW0 18  
PRD_0KV9QM53DZZG,CON_0FZGY9QZQSW0,18 Chapter 18 PRD_0KV9QM53DZZG kyo CON_0FZGY9QZQSW0 18  
PRD_0M0DJ02TPNC0,CON_0FZGY9QZQSW0,18 Chapter 36 PRD_0M0DJ02TPNC0 kyo CON_0FZGY9QZQSW0 18  
PRD_0P9R17759YYG,CON_0FZGY9QZQSW0,18 Chapter 16 PRD_0P9R17759YYG kyo CON_0FZGY9QZQSW0 18  
PRD_0SCVYD2HHWWG,CON_0FZGY9QZQSW0,18 Chapter 13 PRD_0SCVYD2HHWWG kyo CON_0FZGY9QZQSW0 18  
PRD_0TYBCT1FNXXG,CON_0FZGY9QZQSW0,18 Chapter 15 PRD_0TYBCT1FNXXG kyo CON_0FZGY9QZQSW0 18  
PRD_0XXA91WVXV3G,CON_0FZGY9QZQSW0,18 Chapter 10 PRD_0XXA91WVXV3G kyo CON_0FZGY9QZQSW0 18  
PRD_103W1039C32G,CON_0FZGY9QZQSW0,18 Chapter 38 PRD_103W1039C32G kyo CON_0FZGY9QZQSW0 18  
PRD_17YQPJXFVJB0,CON_0FZGY9QZQSW0,18 Chapter 25 PRD_17YQPJXFVJB0 kyo CON_0FZGY9QZQSW0 18  
PRD_1D32KQ96GWG0,CON_0FZGY9QZQSW0,18 Chapter 33 PRD_1D32KQ96GWG0 kyo CON_0FZGY9QZQSW0 18  
PRD_1DJ1XBTYFZ80,CON_0FZGY9QZQSW0,18 Chapter 19 PRD_1DJ1XBTYFZ80 kyo CON_0FZGY9QZQSW0 18  
PRD_1EXPKRRM3G90,CON_0FZGY9QZQSW0,18 Chapter 21 PRD_1EXPKRRM3G90 kyo CON_0FZGY9QZQSW0 18  
PRD_1HXRY9ZDCDPG,CON_0FZGY9QZQSW0,18 Chapter 39 PRD_1HXRY9ZDCDPG kyo CON_0FZGY9QZQSW0 18  
PRD_1MWN2SVB0QD0,CON_0FZGY9QZQSW0,18 Chapter 32 PRD_1MWN2SVB0QD0 kyo CON_0FZGY9QZQSW0 18  
PRD_1V98BN7XW1TG,CON_0FZGY9QZQSW0,18 Chapter 35 PRD_1V98BN7XW1TG kyo CON_0FZGY9QZQSW0 18  
PRD_22AJ2AFRVVK0,CON_0FZGY9QZQSW0,18 Chapter 9 PRD_22AJ2AFRVVK0 kyo CON_0FZGY9QZQSW0 18  
PRD_259XRGB53SH0,CON_0FZGY9QZQSW0,18 Chapter 5 PRD_259XRGB53SH0 kyo CON_0FZGY9QZQSW0 18  
PRD_26VDDX937TJ0,CON_0FZGY9QZQSW0,18 Chapter 7 PRD_26VDDX937TJ0 kyo CON_0FZGY9QZQSW0 18  
PRD_29YCA35FFRG0,CON_0FZGY9QZQSW0,18 Chapter 3 PRD_29YCA35FFRG0 kyo CON_0FZGY9QZQSW0 18  
PRD_2CCWNP6H87Q0,CON_0FZGY9QZQSW0,18 Chapter 2 PRD_2CCWNP6H87Q0 kyo CON_0FZGY9QZQSW0 18  
PRD_2G0G8YM0BYF0,CON_0FZGY9QZQSW0,18 Chapter 17 PRD_2G0G8YM0BYF0 kyo CON_0FZGY9QZQSW0 18  
PRD_2G4BMR5GSQ7G,CON_0FZGY9QZQSW0,18 Chapter 30 PRD_2G4BMR5GSQ7G kyo CON_0FZGY9QZQSW0 18  
PRD_2MH0VHPAQXE0,CON_0FZGY9QZQSW0,18 Chapter 14 PRD_2MH0VHPAQXE0 kyo CON_0FZGY9QZQSW0 18  
PRD_2SAXBKCFDCFG,CON_0FZGY9QZQSW0,18 Chapter 29 PRD_2SAXBKCFDCFG kyo CON_0FZGY9QZQSW0 18  
PRD_2V7K54GCKWD0,CON_0FZGY9QZQSW0,18 Chapter 12 PRD_2V7K54GCKWD0 kyo CON_0FZGY9QZQSW0 18  
PRD_2ZKYSCD3SQ9G,CON_0FZGY9QZQSW0,18 Chapter 31 PRD_2ZKYSCD3SQ9G kyo CON_0FZGY9QZQSW0 18  
PRD_2ZM3GQDPZVC0,CON_0FZGY9QZQSW0,18 Chapter 11 PRD_2ZM3GQDPZVC0 kyo CON_0FZGY9QZQSW0 18  
PRD_31HFW8JAXKVG,CON_0FZGY9QZQSW0,18 Chapter 26 PRD_31HFW8JAXKVG kyo CON_0FZGY9QZQSW0 18  
PRD_31W7G5QHH83G,CON_0FZGY9QZQSW0,18 Chapter 37 PRD_31W7G5QHH83G kyo CON_0FZGY9QZQSW0 18  
PRD_347YFVCCSJTG,CON_0FZGY9QZQSW0,18 Chapter 24 PRD_347YFVCCSJTG kyo CON_0FZGY9QZQSW0 18  
PRD_38MESE9Q5HSG,CON_0FZGY9QZQSW0,18 Chapter 22 PRD_38MESE9Q5HSG kyo CON_0FZGY9QZQSW0 18  
PRD_3FAS41BS1GRG,CON_0FZGY9QZQSW0,18 Chapter 20 PRD_3FAS41BS1GRG kyo CON_0FZGY9QZQSW0 18  
PRD_3Q689JKCHEZ0,CON_0FZGY9QZQSW0,18 Chapter 34 PRD_3Q689JKCHEZ0 kyo CON_0FZGY9QZQSW0 18  
PRD_3X0WJNG0HMMG,CON_0FZGY9QZQSW0,18 Chapter 27 PRD_3X0WJNG0HMMG kyo CON_0FZGY9QZQSW0 18  
PRD_3ZVXZYB6NKR0,CON_0FZGY9QZQSW0,18 Chapter 40 PRD_3ZVXZYB6NKR0 kyo CON_0FZGY9QZQSW0 18  

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 9.031ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS