BookWalker

home / database

product_contributors

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

50 rows where contributor_id = "CON_1F21XXY81PB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00NMPR4P79R0,CON_1F21XXY81PB0,24 Chapter 25 PRD_00NMPR4P79R0 UMIKA CON_1F21XXY81PB0 24  
PRD_01H1V09J91Q0,CON_1F21XXY81PB0,24 Chapter 36 PRD_01H1V09J91Q0 UMIKA CON_1F21XXY81PB0 24  
PRD_020JPFQPTBHG,CON_1F21XXY81PB0,24 Chapter 9 PRD_020JPFQPTBHG UMIKA CON_1F21XXY81PB0 24  
PRD_047G6KBMN0P0,CON_1F21XXY81PB0,24 Chapter 37 PRD_047G6KBMN0P0 UMIKA CON_1F21XXY81PB0 24  
PRD_057WCNK329QG,CON_1F21XXY81PB0,24 Chapter 3 PRD_057WCNK329QG UMIKA CON_1F21XXY81PB0 24  
PRD_06HD12HS6AGG,CON_1F21XXY81PB0,24 Chapter 1 PRD_06HD12HS6AGG UMIKA CON_1F21XXY81PB0 24  
PRD_08VEJ97BZF0G,CON_1F21XXY81PB0,24 Chapter 18 PRD_08VEJ97BZF0G UMIKA CON_1F21XXY81PB0 24  
PRD_0E96YH24BPX0,CON_1F21XXY81PB0,24 Chapter 26 PRD_0E96YH24BPX0 UMIKA CON_1F21XXY81PB0 24  
PRD_0FQBD0WQQSMG,CON_1F21XXY81PB0,24 Chapter 35 PRD_0FQBD0WQQSMG UMIKA CON_1F21XXY81PB0 24  
PRD_0HYGW3WYAEDG,CON_1F21XXY81PB0,24 Chapter 4 PRD_0HYGW3WYAEDG UMIKA CON_1F21XXY81PB0 24  
PRD_0RXKS9RAJDKG,CON_1F21XXY81PB0,24 Chapter 12 PRD_0RXKS9RAJDKG UMIKA CON_1F21XXY81PB0 24  
PRD_0VXQK7GW54J0,CON_1F21XXY81PB0,24 Chapter 43 PRD_0VXQK7GW54J0 UMIKA CON_1F21XXY81PB0 24  
PRD_0W74B5AKVAS0,CON_1F21XXY81PB0,24 Chapter 22 PRD_0W74B5AKVAS0 UMIKA CON_1F21XXY81PB0 24  
PRD_0YJ6YTJ613H0,CON_1F21XXY81PB0,24 Chapter 42 PRD_0YJ6YTJ613H0 UMIKA CON_1F21XXY81PB0 24  
PRD_0ZJ24WTCYCJG,CON_1F21XXY81PB0,24 Chapter 11 PRD_0ZJ24WTCYCJG UMIKA CON_1F21XXY81PB0 24  
PRD_18J9EKPD41R0,CON_1F21XXY81PB0,24 Chapter 8 PRD_18J9EKPD41R0 UMIKA CON_1F21XXY81PB0 24  
PRD_1F0SR6KQ00Z0,CON_1F21XXY81PB0,24 Chapter 7 PRD_1F0SR6KQ00Z0 UMIKA CON_1F21XXY81PB0 24  
PRD_1KY8FF2G7D6G,CON_1F21XXY81PB0,24 Chapter 19 PRD_1KY8FF2G7D6G UMIKA CON_1F21XXY81PB0 24  
PRD_1M0PYSG3CW60,CON_1F21XXY81PB0,24 Chapter 31 PRD_1M0PYSG3CW60 UMIKA CON_1F21XXY81PB0 24  
PRD_1P0BDCVCXKC0,CON_1F21XXY81PB0,24 Chapter 15 PRD_1P0BDCVCXKC0 UMIKA CON_1F21XXY81PB0 24  
PRD_1Q7AAVF1PMWG,CON_1F21XXY81PB0,24 Chapter 46 PRD_1Q7AAVF1PMWG UMIKA CON_1F21XXY81PB0 24  
PRD_1QB3PFVGX0T0,CON_1F21XXY81PB0,24 Chapter 21 PRD_1QB3PFVGX0T0 UMIKA CON_1F21XXY81PB0 24  
PRD_1RH18CJ58V50,CON_1F21XXY81PB0,24 Chapter 32 PRD_1RH18CJ58V50 UMIKA CON_1F21XXY81PB0 24  
PRD_1VNTME9BJK3G,CON_1F21XXY81PB0,24 Chapter 50 PRD_1VNTME9BJK3G UMIKA CON_1F21XXY81PB0 24  
PRD_1YAN71BDYJ2G,CON_1F21XXY81PB0,24 Chapter 45 PRD_1YAN71BDYJ2G UMIKA CON_1F21XXY81PB0 24  
PRD_1Z7HVZCFMT40,CON_1F21XXY81PB0,24 Chapter 28 PRD_1Z7HVZCFMT40 UMIKA CON_1F21XXY81PB0 24  
PRD_20858R6VRA10,CON_1F21XXY81PB0,24 Chapter 6 PRD_20858R6VRA10 UMIKA CON_1F21XXY81PB0 24  
PRD_212ZF2QV58FG,CON_1F21XXY81PB0,24 Chapter 27 PRD_212ZF2QV58FG UMIKA CON_1F21XXY81PB0 24  
PRD_239S2QZDB17G,CON_1F21XXY81PB0,24 Chapter 38 PRD_239S2QZDB17G UMIKA CON_1F21XXY81PB0 24  
PRD_24YNTB0Y4900,CON_1F21XXY81PB0,24 Chapter 5 PRD_24YNTB0Y4900 UMIKA CON_1F21XXY81PB0 24  
PRD_27RDJQ0DRM3G,CON_1F21XXY81PB0,24 Chapter 14 PRD_27RDJQ0DRM3G UMIKA CON_1F21XXY81PB0 24  
PRD_27Y8CARQQ06G,CON_1F21XXY81PB0,24 Chapter 39 PRD_27Y8CARQQ06G UMIKA CON_1F21XXY81PB0 24  
PRD_28R17H4ZGW30,CON_1F21XXY81PB0,24 Chapter 44 PRD_28R17H4ZGW30 UMIKA CON_1F21XXY81PB0 24  
PRD_290H4KP8XFG0,CON_1F21XXY81PB0,24 Chapter 17 PRD_290H4KP8XFG0 UMIKA CON_1F21XXY81PB0 24  
PRD_29E0MPDJ9S50,CON_1F21XXY81PB0,24 Chapter 34 PRD_29E0MPDJ9S50 UMIKA CON_1F21XXY81PB0 24  
PRD_2AJ6S0M6H0H0,CON_1F21XXY81PB0,24 Chapter 16 PRD_2AJ6S0M6H0H0 UMIKA CON_1F21XXY81PB0 24  
PRD_2CPEQVD99NCG,CON_1F21XXY81PB0,24 Chapter 24 PRD_2CPEQVD99NCG UMIKA CON_1F21XXY81PB0 24  
PRD_2KH8BSDSCFY0,CON_1F21XXY81PB0,24 Chapter 2 PRD_2KH8BSDSCFY0 UMIKA CON_1F21XXY81PB0 24  
PRD_2MRJNPW2NCBG,CON_1F21XXY81PB0,24 Chapter 23 PRD_2MRJNPW2NCBG UMIKA CON_1F21XXY81PB0 24  
PRD_2RAY5G31331G,CON_1F21XXY81PB0,24 Chapter 41 PRD_2RAY5G31331G UMIKA CON_1F21XXY81PB0 24  
PRD_2WVEQ4XBF20G,CON_1F21XXY81PB0,24 Chapter 40 PRD_2WVEQ4XBF20G UMIKA CON_1F21XXY81PB0 24  
PRD_2XVAX54HWB20,CON_1F21XXY81PB0,24 Chapter 10 PRD_2XVAX54HWB20 UMIKA CON_1F21XXY81PB0 24  
PRD_3HV0M28FZMWG,CON_1F21XXY81PB0,24 Chapter 13 PRD_3HV0M28FZMWG UMIKA CON_1F21XXY81PB0 24  
PRD_3NCJ35Y6MKC0,CON_1F21XXY81PB0,24 Chapter 48 PRD_3NCJ35Y6MKC0 UMIKA CON_1F21XXY81PB0 24  
PRD_3NGA8RANVF9G,CON_1F21XXY81PB0,24 Chapter 20 PRD_3NGA8RANVF9G UMIKA CON_1F21XXY81PB0 24  
PRD_3SXDERR8GKK0,CON_1F21XXY81PB0,24 Chapter 47 PRD_3SXDERR8GKK0 UMIKA CON_1F21XXY81PB0 24  
PRD_3T9YQ230AWNG,CON_1F21XXY81PB0,24 Chapter 33 PRD_3T9YQ230AWNG UMIKA CON_1F21XXY81PB0 24  
PRD_3WKXRBNJWJJ0,CON_1F21XXY81PB0,24 Chapter 49 PRD_3WKXRBNJWJJ0 UMIKA CON_1F21XXY81PB0 24  
PRD_3XCRC9ZCJTVG,CON_1F21XXY81PB0,24 Chapter 30 PRD_3XCRC9ZCJTVG UMIKA CON_1F21XXY81PB0 24  
PRD_3YY92PXAPVMG,CON_1F21XXY81PB0,24 Chapter 29 PRD_3YY92PXAPVMG UMIKA CON_1F21XXY81PB0 24  

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