BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_0ZZEMQAQT48G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_063Q6E1NHR7G,CON_0ZZEMQAQT48G,1 Chapter 5 PRD_063Q6E1NHR7G Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_0660EF914P50,CON_0ZZEMQAQT48G,1 Chapter 1 PRD_0660EF914P50 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_07R9PDPZ4WWG,CON_0ZZEMQAQT48G,1 Chapter 17 PRD_07R9PDPZ4WWG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_0JQSFVB5K0R0,CON_0ZZEMQAQT48G,1 Chapter 16 PRD_0JQSFVB5K0R0 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_0Z36H9DMW870,CON_0ZZEMQAQT48G,1 Chapter 18 PRD_0Z36H9DMW870 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_15JX8DFK6EDG,CON_0ZZEMQAQT48G,1 Chapter 14 PRD_15JX8DFK6EDG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_183DV09N2DCG,CON_0ZZEMQAQT48G,1 Chapter 4 PRD_183DV09N2DCG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_1G14HTH2VP60,CON_0ZZEMQAQT48G,1 Chapter 15 PRD_1G14HTH2VP60 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_1MGTVCBSH77G,CON_0ZZEMQAQT48G,1 Chapter 13 PRD_1MGTVCBSH77G Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_21YSN6YW6QNG,CON_0ZZEMQAQT48G,1 Chapter 2 PRD_21YSN6YW6QNG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_2K6CG651ACJG,CON_0ZZEMQAQT48G,1 Chapter 10 PRD_2K6CG651ACJG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_2VZQNAEBJZ80,CON_0ZZEMQAQT48G,1 Chapter 12 PRD_2VZQNAEBJZ80 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_2YC60X8DYYF0,CON_0ZZEMQAQT48G,1 Chapter 7 PRD_2YC60X8DYYF0 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_2YVYRZ2QY9QG,CON_0ZZEMQAQT48G,1 Chapter 8 PRD_2YVYRZ2QY9QG Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_375AQ4XDRFY0,CON_0ZZEMQAQT48G,1 Chapter 9 PRD_375AQ4XDRFY0 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_3BT52QYG4EX0,CON_0ZZEMQAQT48G,1 Chapter 3 PRD_3BT52QYG4EX0 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_3KN3GGYJPSH0,CON_0ZZEMQAQT48G,1 Chapter 11 PRD_3KN3GGYJPSH0 Takashi Hazama CON_0ZZEMQAQT48G 1  
PRD_3SHVFA7ZM2S0,CON_0ZZEMQAQT48G,1 Chapter 6 PRD_3SHVFA7ZM2S0 Takashi Hazama CON_0ZZEMQAQT48G 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.52ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS