BookWalker

home / database

product_contributors

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

54 rows where contributor_id = "CON_0A473FCRW330"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04B656SB428G,CON_0A473FCRW330,1 Chapter 4 PRD_04B656SB428G Icelatte CON_0A473FCRW330 1  
PRD_04QXM02HBE10,CON_0A473FCRW330,1 Chapter 21 PRD_04QXM02HBE10 Icelatte CON_0A473FCRW330 1  
PRD_06YYSQMT5V1G,CON_0A473FCRW330,1 Chapter 16 PRD_06YYSQMT5V1G Icelatte CON_0A473FCRW330 1  
PRD_08N48RK1XKA0,CON_0A473FCRW330,1 Chapter 3 PRD_08N48RK1XKA0 Icelatte CON_0A473FCRW330 1  
PRD_08SPGSVD01FG,CON_0A473FCRW330,1 Chapter 2 PRD_08SPGSVD01FG Icelatte CON_0A473FCRW330 1  
PRD_091P0TJX5V60,CON_0A473FCRW330,1 Chapter 13 PRD_091P0TJX5V60 Icelatte CON_0A473FCRW330 1  
PRD_0H44D65DG9S0,CON_0A473FCRW330,1 Chapter 7 PRD_0H44D65DG9S0 Icelatte CON_0A473FCRW330 1  
PRD_0KD45GRZJJ90,CON_0A473FCRW330,1 Chapter 7 PRD_0KD45GRZJJ90 Icelatte CON_0A473FCRW330 1  
PRD_0R1STBH3FBM0,CON_0A473FCRW330,1 Chapter 6 PRD_0R1STBH3FBM0 Icelatte CON_0A473FCRW330 1  
PRD_0R4A2CSENSSG,CON_0A473FCRW330,1 Chapter 5 PRD_0R4A2CSENSSG Icelatte CON_0A473FCRW330 1  
PRD_0T5WXY9YR790,CON_0A473FCRW330,1 Chapter 20 PRD_0T5WXY9YR790 Icelatte CON_0A473FCRW330 1  
PRD_0TM93HZNK2Y0,CON_0A473FCRW330,1 Chapter 18 PRD_0TM93HZNK2Y0 Icelatte CON_0A473FCRW330 1  
PRD_0W3ZCJGXZQT0,CON_0A473FCRW330,1 Chapter 22 PRD_0W3ZCJGXZQT0 Icelatte CON_0A473FCRW330 1  
PRD_0Z1Y6YWR2QG0,CON_0A473FCRW330,1 Chapter 5 PRD_0Z1Y6YWR2QG0 Icelatte CON_0A473FCRW330 1  
PRD_17QWGK8JJSTG,CON_0A473FCRW330,1 Chapter 17 PRD_17QWGK8JJSTG Icelatte CON_0A473FCRW330 1  
PRD_1D2H10N313B0,CON_0A473FCRW330,1 Chapter 12 PRD_1D2H10N313B0 Icelatte CON_0A473FCRW330 1  
PRD_1G8JPWTTZB7G,CON_0A473FCRW330,1 Chapter 6 PRD_1G8JPWTTZB7G Icelatte CON_0A473FCRW330 1  
PRD_1K3P4CBDMPEG,CON_0A473FCRW330,1 Chapter 1 PRD_1K3P4CBDMPEG Icelatte CON_0A473FCRW330 1  
PRD_1MSD0FMWVA6G,CON_0A473FCRW330,1 Chapter 5 PRD_1MSD0FMWVA6G Icelatte CON_0A473FCRW330 1  
PRD_1NDJX7HT2XPG,CON_0A473FCRW330,1 Chapter 1 PRD_1NDJX7HT2XPG Icelatte CON_0A473FCRW330 1  
PRD_1NGF58S59BM0,CON_0A473FCRW330,1 Chapter 6 PRD_1NGF58S59BM0 Icelatte CON_0A473FCRW330 1  
PRD_1R6ZGVVFNAV0,CON_0A473FCRW330,1 Chapter 5 PRD_1R6ZGVVFNAV0 Icelatte CON_0A473FCRW330 1  
PRD_1T94V9TN68Z0,CON_0A473FCRW330,1 Chapter 3 PRD_1T94V9TN68Z0 Icelatte CON_0A473FCRW330 1  
PRD_1V2F4WBPZ6V0,CON_0A473FCRW330,1 Chapter 2 PRD_1V2F4WBPZ6V0 Icelatte CON_0A473FCRW330 1  
PRD_1W6Z4D9J9510,CON_0A473FCRW330,1 Chapter 14 PRD_1W6Z4D9J9510 Icelatte CON_0A473FCRW330 1  
PRD_25V1S9KYKSK0,CON_0A473FCRW330,1 Chapter 9 PRD_25V1S9KYKSK0 Icelatte CON_0A473FCRW330 1  
PRD_297PYQMNMF80,CON_0A473FCRW330,1 Chapter 11 PRD_297PYQMNMF80 Icelatte CON_0A473FCRW330 1  
PRD_29A36RW0TXDG,CON_0A473FCRW330,1 Chapter 9 PRD_29A36RW0TXDG Icelatte CON_0A473FCRW330 1  
PRD_29QN45GJ7E7G,CON_0A473FCRW330,1 Chapter 4 PRD_29QN45GJ7E7G Icelatte CON_0A473FCRW330 1  
PRD_2D4WP3HXK590,CON_0A473FCRW330,1 Chapter 10 PRD_2D4WP3HXK590 Icelatte CON_0A473FCRW330 1  
PRD_2DEY7DTQNG8G,CON_0A473FCRW330,1 Chapter 12 PRD_2DEY7DTQNG8G Icelatte CON_0A473FCRW330 1  
PRD_2E85YDAGCKB0,CON_0A473FCRW330,1 Chapter 6 PRD_2E85YDAGCKB0 Icelatte CON_0A473FCRW330 1  
PRD_2ESHYN6K1NC0,CON_0A473FCRW330,1 Chapter 23 PRD_2ESHYN6K1NC0 Icelatte CON_0A473FCRW330 1  
PRD_2ME9NJ2DF4XG,CON_0A473FCRW330,1 Chapter 2 PRD_2ME9NJ2DF4XG Icelatte CON_0A473FCRW330 1  
PRD_2QEKYFC7BTB0,CON_0A473FCRW330,1 Chapter 8 PRD_2QEKYFC7BTB0 Icelatte CON_0A473FCRW330 1  
PRD_2SR2X70JEY50,CON_0A473FCRW330,1 Chapter 1 PRD_2SR2X70JEY50 Icelatte CON_0A473FCRW330 1  
PRD_2TF5DKF60JXG,CON_0A473FCRW330,1 Chapter 8 PRD_2TF5DKF60JXG Icelatte CON_0A473FCRW330 1  
PRD_2ZCCK1KMWHR0,CON_0A473FCRW330,1 Chapter 19 PRD_2ZCCK1KMWHR0 Icelatte CON_0A473FCRW330 1  
PRD_3664BPPRNF6G,CON_0A473FCRW330,1 Chapter 3 PRD_3664BPPRNF6G Icelatte CON_0A473FCRW330 1  
PRD_387NPC7PSMXG,CON_0A473FCRW330,1 Chapter 24 PRD_387NPC7PSMXG Icelatte CON_0A473FCRW330 1  
PRD_3CES3Z0GXB20,CON_0A473FCRW330,1 Chapter 1 PRD_3CES3Z0GXB20 Icelatte CON_0A473FCRW330 1  
PRD_3G923YRD2WKG,CON_0A473FCRW330,1 Chapter 10 PRD_3G923YRD2WKG Icelatte CON_0A473FCRW330 1  
PRD_3JTFK3R8PQZ0,CON_0A473FCRW330,1 Chapter 2 PRD_3JTFK3R8PQZ0 Icelatte CON_0A473FCRW330 1  
PRD_3M1W2ZBQR8FG,CON_0A473FCRW330,1 Chapter 4 PRD_3M1W2ZBQR8FG Icelatte CON_0A473FCRW330 1  
PRD_3M5TRXM1TMTG,CON_0A473FCRW330,1 Chapter 11 PRD_3M5TRXM1TMTG Icelatte CON_0A473FCRW330 1  
PRD_3PG5F55ZXBQ0,CON_0A473FCRW330,1 Chapter 7 PRD_3PG5F55ZXBQ0 Icelatte CON_0A473FCRW330 1  
PRD_3RPFDJ5T4QEG,CON_0A473FCRW330,1 Chapter 2 PRD_3RPFDJ5T4QEG Icelatte CON_0A473FCRW330 1  
PRD_3SBQX6TVX5AG,CON_0A473FCRW330,1 Chapter 1 PRD_3SBQX6TVX5AG Icelatte CON_0A473FCRW330 1  
PRD_3TN4KKRHH6BG,CON_0A473FCRW330,1 Chapter 3 PRD_3TN4KKRHH6BG Icelatte CON_0A473FCRW330 1  
PRD_3TZWV1M5VX0G,CON_0A473FCRW330,1 Chapter 9 PRD_3TZWV1M5VX0G Icelatte CON_0A473FCRW330 1  
PRD_3VSQZH8AQABG,CON_0A473FCRW330,1 Chapter 3 PRD_3VSQZH8AQABG Icelatte CON_0A473FCRW330 1  
PRD_3X6BX2J8B4NG,CON_0A473FCRW330,1 Chapter 4 PRD_3X6BX2J8B4NG Icelatte CON_0A473FCRW330 1  
PRD_3XS0FAS189J0,CON_0A473FCRW330,1 Chapter 15 PRD_3XS0FAS189J0 Icelatte CON_0A473FCRW330 1  
PRD_3ZS7WY3K9SFG,CON_0A473FCRW330,1 Chapter 8 PRD_3ZS7WY3K9SFG Icelatte CON_0A473FCRW330 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 14.609ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS