BookWalker

home / database

product_contributors

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

34 rows where contributor_id = "CON_2BX1PVQ3C3G0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04VA3SG18DA0,CON_2BX1PVQ3C3G0,1 Chapter 26 PRD_04VA3SG18DA0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_0B85DCJBMC90,CON_2BX1PVQ3C3G0,1 Chapter 24 PRD_0B85DCJBMC90 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_0FYNRZCDGB80,CON_2BX1PVQ3C3G0,1 Chapter 22 PRD_0FYNRZCDGB80 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_0KPVV7586H5G,CON_2BX1PVQ3C3G0,1 Chapter 1 PRD_0KPVV7586H5G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_0WWRVB1ATDM0,CON_2BX1PVQ3C3G0,1 Chapter 32 PRD_0WWRVB1ATDM0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_137H8H2J8PJ0,CON_2BX1PVQ3C3G0,1 Chapter 10 PRD_137H8H2J8PJ0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_13G7DQX0FQFG,CON_2BX1PVQ3C3G0,1 Chapter 29 PRD_13G7DQX0FQFG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_17M1T5WMMNH0,CON_2BX1PVQ3C3G0,1 Chapter 4 PRD_17M1T5WMMNH0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1AAG5RYYGMG0,CON_2BX1PVQ3C3G0,1 Chapter 7 PRD_1AAG5RYYGMG0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1CPFG4T1PRXG,CON_2BX1PVQ3C3G0,1 Chapter 27 PRD_1CPFG4T1PRXG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1D9K2YTARJP0,CON_2BX1PVQ3C3G0,1 Chapter 2 PRD_1D9K2YTARJP0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1EV0QBR0WKQ0,CON_2BX1PVQ3C3G0,1 Chapter 5 PRD_1EV0QBR0WKQ0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1HT7NYGVGHAG,CON_2BX1PVQ3C3G0,1 Chapter 31 PRD_1HT7NYGVGHAG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1JF4BJ9QWAF0,CON_2BX1PVQ3C3G0,1 Chapter 20 PRD_1JF4BJ9QWAF0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1NJ70R5W48D0,CON_2BX1PVQ3C3G0,1 Chapter 16 PRD_1NJ70R5W48D0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1PXMN5BSR9E0,CON_2BX1PVQ3C3G0,1 Chapter 17 PRD_1PXMN5BSR9E0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1R0QJB760QC0,CON_2BX1PVQ3C3G0,1 Chapter 14 PRD_1R0QJB760QC0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_1WH6XY18CQK0,CON_2BX1PVQ3C3G0,1 Chapter 12 PRD_1WH6XY18CQK0 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_250JM236PDSG,CON_2BX1PVQ3C3G0,1 Chapter 25 PRD_250JM236PDSG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_29HD7PX8JCRG,CON_2BX1PVQ3C3G0,1 Chapter 23 PRD_29HD7PX8JCRG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_2C7XH9YJYBZG,CON_2BX1PVQ3C3G0,1 Chapter 21 PRD_2C7XH9YJYBZG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_2FG3K9CSTAZG,CON_2BX1PVQ3C3G0,1 Chapter 30 PRD_2FG3K9CSTAZG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_2MHDRKPB4QXG,CON_2BX1PVQ3C3G0,1 Chapter 28 PRD_2MHDRKPB4QXG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_31CS1VDQPN1G,CON_2BX1PVQ3C3G0,1 Chapter 9 PRD_31CS1VDQPN1G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_32YEP8GDAP2G,CON_2BX1PVQ3C3G0,1 Chapter 11 PRD_32YEP8GDAP2G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_35X9KEFSJM0G,CON_2BX1PVQ3C3G0,1 Chapter 8 PRD_35X9KEFSJM0G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_38KRY193YK7G,CON_2BX1PVQ3C3G0,1 Chapter 6 PRD_38KRY193YK7G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3CCKHG2SME20,CON_2BX1PVQ3C3G0,1 Chapter 34 PRD_3CCKHG2SME20 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3F0B9MB5TJ6G,CON_2BX1PVQ3C3G0,1 Chapter 3 PRD_3F0B9MB5TJ6G Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3GMCWWRMTAYG,CON_2BX1PVQ3C3G0,1 Chapter 19 PRD_3GMCWWRMTAYG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3PKH7STPJ240,CON_2BX1PVQ3C3G0,1 Chapter 33 PRD_3PKH7STPJ240 Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3QAZEFTZ69XG,CON_2BX1PVQ3C3G0,1 Chapter 18 PRD_3QAZEFTZ69XG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3VVFS2M128WG,CON_2BX1PVQ3C3G0,1 Chapter 15 PRD_3VVFS2M128WG Chihiro Yamazaki CON_2BX1PVQ3C3G0 1  
PRD_3Y9Y4NPBEQ3G,CON_2BX1PVQ3C3G0,1 Chapter 13 PRD_3Y9Y4NPBEQ3G Chihiro Yamazaki CON_2BX1PVQ3C3G0 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 11.755ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS