BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_05QD6VB1P2S0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0C1SY9KT2DSG,CON_05QD6VB1P2S0,1 Volume 2 PRD_0C1SY9KT2DSG mika CON_05QD6VB1P2S0 1  
PRD_0F9AKSACPVD0,CON_05QD6VB1P2S0,1 Chapter 5 PRD_0F9AKSACPVD0 mika CON_05QD6VB1P2S0 1  
PRD_0TPBA27D5ST0,CON_05QD6VB1P2S0,1 Chapter 2 PRD_0TPBA27D5ST0 mika CON_05QD6VB1P2S0 1  
PRD_1401YZ0NB7VG,CON_05QD6VB1P2S0,1 Chapter 8 PRD_1401YZ0NB7VG mika CON_05QD6VB1P2S0 1  
PRD_14NZG8J2BYBG,CON_05QD6VB1P2S0,1 Chapter 4 PRD_14NZG8J2BYBG mika CON_05QD6VB1P2S0 1  
PRD_151D0WV0WBMG,CON_05QD6VB1P2S0,1 Chapter 4 PRD_151D0WV0WBMG mika CON_05QD6VB1P2S0 1  
PRD_166S4BTBF0HG,CON_05QD6VB1P2S0,1 Chapter 9 PRD_166S4BTBF0HG mika CON_05QD6VB1P2S0 1  
PRD_1QX2K9S7ZK0G,CON_05QD6VB1P2S0,1 Chapter 6 PRD_1QX2K9S7ZK0G mika CON_05QD6VB1P2S0 1  
PRD_1R5ZAZSMCBK0,CON_05QD6VB1P2S0,1 Chapter 6 PRD_1R5ZAZSMCBK0 mika CON_05QD6VB1P2S0 1  
PRD_1T9B5CHPAVHG,CON_05QD6VB1P2S0,1 Volume 4 PRD_1T9B5CHPAVHG mika CON_05QD6VB1P2S0 1  
PRD_1V0SM8HRDESG,CON_05QD6VB1P2S0,1 Volume 5 PRD_1V0SM8HRDESG mika CON_05QD6VB1P2S0 1  
PRD_1X4G3YK108K0,CON_05QD6VB1P2S0,1 Volume 6 PRD_1X4G3YK108K0 mika CON_05QD6VB1P2S0 1  
PRD_1XPWV2PP3G5G,CON_05QD6VB1P2S0,1 Chapter 3 PRD_1XPWV2PP3G5G mika CON_05QD6VB1P2S0 1  
PRD_2J99R1BGZV8G,CON_05QD6VB1P2S0,1 Chapter 1 PRD_2J99R1BGZV8G mika CON_05QD6VB1P2S0 1  
PRD_2MJ7YGMY6QJ0,CON_05QD6VB1P2S0,1 Volume 9 PRD_2MJ7YGMY6QJ0 mika CON_05QD6VB1P2S0 1  
PRD_2VQKPFB8S18G,CON_05QD6VB1P2S0,1 Volume 3 PRD_2VQKPFB8S18G mika CON_05QD6VB1P2S0 1  
PRD_2X2EBA5PCHZG,CON_05QD6VB1P2S0,1 Chapter 7 PRD_2X2EBA5PCHZG mika CON_05QD6VB1P2S0 1  
PRD_2ZG5TS14XG10,CON_05QD6VB1P2S0,1 Volume 7 PRD_2ZG5TS14XG10 mika CON_05QD6VB1P2S0 1  
PRD_398B43FJRHQ0,CON_05QD6VB1P2S0,1 The Crown Prince is Too Sweet on Me! PRD_398B43FJRHQ0 mika CON_05QD6VB1P2S0 1  
PRD_3B6408D99AYG,CON_05QD6VB1P2S0,1 Volume 1 PRD_3B6408D99AYG mika CON_05QD6VB1P2S0 1  
PRD_3C017RRKHWS0,CON_05QD6VB1P2S0,1 Chapter 2 PRD_3C017RRKHWS0 mika CON_05QD6VB1P2S0 1  
PRD_3P0YZ24YXNG0,CON_05QD6VB1P2S0,1 Volume 8 PRD_3P0YZ24YXNG0 mika CON_05QD6VB1P2S0 1  
PRD_3QBY840301HG,CON_05QD6VB1P2S0,1 Chapter 3 PRD_3QBY840301HG mika CON_05QD6VB1P2S0 1  
PRD_3RV5Q5AESJQ0,CON_05QD6VB1P2S0,1 Chapter 5 PRD_3RV5Q5AESJQ0 mika CON_05QD6VB1P2S0 1  
PRD_3YES5BWF8FQG,CON_05QD6VB1P2S0,1 Chapter 1 PRD_3YES5BWF8FQG mika CON_05QD6VB1P2S0 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.642ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS