BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_1ZCJGDBEJ750"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00VTXCRR9Y60,CON_1ZCJGDBEJ750,1 Volume 2 PRD_00VTXCRR9Y60 LeonarD CON_1ZCJGDBEJ750 1  
PRD_014SRZFXKJRG,CON_1ZCJGDBEJ750,11 Chapter 5 PRD_014SRZFXKJRG LeonarD CON_1ZCJGDBEJ750 11  
PRD_08BRN5B9VGYG,CON_1ZCJGDBEJ750,11 Chapter 3 PRD_08BRN5B9VGYG LeonarD CON_1ZCJGDBEJ750 11  
PRD_0MERBBFZZZH0,CON_1ZCJGDBEJ750,11 Chapter 7 PRD_0MERBBFZZZH0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_0Q2Z6KM53PMG,CON_1ZCJGDBEJ750,11 Chapter 2 PRD_0Q2Z6KM53PMG LeonarD CON_1ZCJGDBEJ750 11  
PRD_0RZ8PY91VYG0,CON_1ZCJGDBEJ750,11 Chapter 6 PRD_0RZ8PY91VYG0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_0VBPPMMEDX6G,CON_1ZCJGDBEJ750,11 Chapter 14 PRD_0VBPPMMEDX6G LeonarD CON_1ZCJGDBEJ750 11  
PRD_0Y1Y3SKHBMTG,CON_1ZCJGDBEJ750,11 Chapter 1 PRD_0Y1Y3SKHBMTG LeonarD CON_1ZCJGDBEJ750 11  
PRD_15ZQRN521KXG,CON_1ZCJGDBEJ750,11 Chapter 9 PRD_15ZQRN521KXG LeonarD CON_1ZCJGDBEJ750 11  
PRD_18GGJ9EQG020,CON_1ZCJGDBEJ750,11 Chapter 10 PRD_18GGJ9EQG020 LeonarD CON_1ZCJGDBEJ750 11  
PRD_1KEVJB6P3YWG,CON_1ZCJGDBEJ750,11 Volume 2 PRD_1KEVJB6P3YWG LeonarD CON_1ZCJGDBEJ750 11  
PRD_1R22AZMWSF10,CON_1ZCJGDBEJ750,1 Volume 7 PRD_1R22AZMWSF10 LeonarD CON_1ZCJGDBEJ750 1  
PRD_1T980HTQ5EX0,CON_1ZCJGDBEJ750,11 Chapter 4 PRD_1T980HTQ5EX0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_1WD3E7MZR8PG,CON_1ZCJGDBEJ750,1 Volume 6 PRD_1WD3E7MZR8PG LeonarD CON_1ZCJGDBEJ750 1  
PRD_1WZ4Z5VKDMTG,CON_1ZCJGDBEJ750,1 Volume 4 PRD_1WZ4Z5VKDMTG LeonarD CON_1ZCJGDBEJ750 1  
PRD_2EK3EFTESZE0,CON_1ZCJGDBEJ750,11 Volume 1 PRD_2EK3EFTESZE0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_2M6BJ15C6DN0,CON_1ZCJGDBEJ750,11 Chapter 12 PRD_2M6BJ15C6DN0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_2N2EWA59FYQ0,CON_1ZCJGDBEJ750,11 Chapter 13 PRD_2N2EWA59FYQ0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_2Z5NF70REBV0,CON_1ZCJGDBEJ750,11 Chapter 11 PRD_2Z5NF70REBV0 LeonarD CON_1ZCJGDBEJ750 11  
PRD_3AWX709XM2WG,CON_1ZCJGDBEJ750,1 Volume 1 PRD_3AWX709XM2WG LeonarD CON_1ZCJGDBEJ750 1  
PRD_3E65CVR6CPTG,CON_1ZCJGDBEJ750,1 Volume 3 PRD_3E65CVR6CPTG LeonarD CON_1ZCJGDBEJ750 1  
PRD_3FVP46PSQQGG,CON_1ZCJGDBEJ750,1 Volume 5 PRD_3FVP46PSQQGG LeonarD CON_1ZCJGDBEJ750 1  
PRD_3WQYH66WE3DG,CON_1ZCJGDBEJ750,11 Chapter 8 PRD_3WQYH66WE3DG LeonarD CON_1ZCJGDBEJ750 11  

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