BookWalker

home / database

product_contributors

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

40 rows where contributor_id = "CON_1HRMBAARNZFG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_090B379S5XE0,CON_1HRMBAARNZFG,1 Chapter 15 PRD_090B379S5XE0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_0H2NJ83PT7YG,CON_1HRMBAARNZFG,1 Chapter 6 PRD_0H2NJ83PT7YG Kokoharu CON_1HRMBAARNZFG 1  
PRD_0HAJW0RHGVNG,CON_1HRMBAARNZFG,1 Chapter 8 PRD_0HAJW0RHGVNG Kokoharu CON_1HRMBAARNZFG 1  
PRD_0J98RNY1BAT0,CON_1HRMBAARNZFG,1 Chapter 22 PRD_0J98RNY1BAT0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_0NCBNVTDK8R0,CON_1HRMBAARNZFG,1 Chapter 19 PRD_0NCBNVTDK8R0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_0WCRA0EEMRRG,CON_1HRMBAARNZFG,1 Chapter 20 PRD_0WCRA0EEMRRG Kokoharu CON_1HRMBAARNZFG 1  
PRD_0WKAJ1HSVPY0,CON_1HRMBAARNZFG,1 Chapter 17 PRD_0WKAJ1HSVPY0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_0WVKWREMYAN0,CON_1HRMBAARNZFG,1 Chapter 4 PRD_0WVKWREMYAN0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_122GM0ZQ3W40,CON_1HRMBAARNZFG,1 Chapter 7 PRD_122GM0ZQ3W40 Kokoharu CON_1HRMBAARNZFG 1  
PRD_12AS6QMJ6G30,CON_1HRMBAARNZFG,1 Chapter 3 PRD_12AS6QMJ6G30 Kokoharu CON_1HRMBAARNZFG 1  
PRD_151KH6V3BTA0,CON_1HRMBAARNZFG,1 Chapter 3 PRD_151KH6V3BTA0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_16KQHPMTGEXG,CON_1HRMBAARNZFG,1 Chapter 11 PRD_16KQHPMTGEXG Kokoharu CON_1HRMBAARNZFG 1  
PRD_19KHMRDT1BBG,CON_1HRMBAARNZFG,1 Chapter 18 PRD_19KHMRDT1BBG Kokoharu CON_1HRMBAARNZFG 1  
PRD_19P2WSN5QS90,CON_1HRMBAARNZFG,1 Chapter 10 PRD_19P2WSN5QS90 Kokoharu CON_1HRMBAARNZFG 1  
PRD_1AX195KG5C4G,CON_1HRMBAARNZFG,1 Chapter 23 PRD_1AX195KG5C4G Kokoharu CON_1HRMBAARNZFG 1  
PRD_1C4XECQFKR80,CON_1HRMBAARNZFG,1 Chapter 8 PRD_1C4XECQFKR80 Kokoharu CON_1HRMBAARNZFG 1  
PRD_1E7H1BKNQJHG,CON_1HRMBAARNZFG,1 Chapter 16 PRD_1E7H1BKNQJHG Kokoharu CON_1HRMBAARNZFG 1  
PRD_1RV4QSRZN00G,CON_1HRMBAARNZFG,1 Chapter 9 PRD_1RV4QSRZN00G Kokoharu CON_1HRMBAARNZFG 1  
PRD_1ZC09C2D7X50,CON_1HRMBAARNZFG,1 Chapter 11 PRD_1ZC09C2D7X50 Kokoharu CON_1HRMBAARNZFG 1  
PRD_219DPX215MCG,CON_1HRMBAARNZFG,1 Chapter 12 PRD_219DPX215MCG Kokoharu CON_1HRMBAARNZFG 1  
PRD_21HA0NV3R8BG,CON_1HRMBAARNZFG,1 Chapter 1 PRD_21HA0NV3R8BG Kokoharu CON_1HRMBAARNZFG 1  
PRD_22M03ARKK780,CON_1HRMBAARNZFG,1 Chapter 21 PRD_22M03ARKK780 Kokoharu CON_1HRMBAARNZFG 1  
PRD_22ZJXE7BGP5G,CON_1HRMBAARNZFG,1 Chapter 13 PRD_22ZJXE7BGP5G Kokoharu CON_1HRMBAARNZFG 1  
PRD_24AGZBWHVZZG,CON_1HRMBAARNZFG,1 Chapter 14 PRD_24AGZBWHVZZG Kokoharu CON_1HRMBAARNZFG 1  
PRD_25ZW1HWB1MKG,CON_1HRMBAARNZFG,1 Chapter 16 PRD_25ZW1HWB1MKG Kokoharu CON_1HRMBAARNZFG 1  
PRD_289JB3P274D0,CON_1HRMBAARNZFG,1 Chapter 13 PRD_289JB3P274D0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_28CCK4YDDKJG,CON_1HRMBAARNZFG,1 Chapter 15 PRD_28CCK4YDDKJG Kokoharu CON_1HRMBAARNZFG 1  
PRD_2F186Q32W0Q0,CON_1HRMBAARNZFG,1 Chapter 1 PRD_2F186Q32W0Q0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_2QBW4JJVR6E0,CON_1HRMBAARNZFG,1 Chapter 4 PRD_2QBW4JJVR6E0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_2QKTN9BPYT50,CON_1HRMBAARNZFG,1 Chapter 6 PRD_2QKTN9BPYT50 Kokoharu CON_1HRMBAARNZFG 1  
PRD_2T0N0W5RTS40,CON_1HRMBAARNZFG,1 Chapter 9 PRD_2T0N0W5RTS40 Kokoharu CON_1HRMBAARNZFG 1  
PRD_2VXRRV2DMB6G,CON_1HRMBAARNZFG,1 Chapter 7 PRD_2VXRRV2DMB6G Kokoharu CON_1HRMBAARNZFG 1  
PRD_2YEZ1RE004C0,CON_1HRMBAARNZFG,1 Chapter 2 PRD_2YEZ1RE004C0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_30AFZC5NJEE0,CON_1HRMBAARNZFG,1 Chapter 12 PRD_30AFZC5NJEE0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_34RYAZ7ZYDD0,CON_1HRMBAARNZFG,1 Chapter 10 PRD_34RYAZ7ZYDD0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_3FRRD2WZFBV0,CON_1HRMBAARNZFG,1 Chapter 24 PRD_3FRRD2WZFBV0 Kokoharu CON_1HRMBAARNZFG 1  
PRD_3KKE8ANSNHGG,CON_1HRMBAARNZFG,1 Chapter 14 PRD_3KKE8ANSNHGG Kokoharu CON_1HRMBAARNZFG 1  
PRD_3SF62T8AWHCG,CON_1HRMBAARNZFG,1 Chapter 5 PRD_3SF62T8AWHCG Kokoharu CON_1HRMBAARNZFG 1  
PRD_3XN83PCJ5XMG,CON_1HRMBAARNZFG,1 Chapter 5 PRD_3XN83PCJ5XMG Kokoharu CON_1HRMBAARNZFG 1  
PRD_3XXHCDACRHKG,CON_1HRMBAARNZFG,1 Chapter 2 PRD_3XXHCDACRHKG Kokoharu CON_1HRMBAARNZFG 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.521ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS