BookWalker

home / database

product_contributors

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

19 rows where contributor_id = "CON_1VKTYAMBKM6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0AJVVNVHB0W0,CON_1VKTYAMBKM6G,1 Volume 2 PRD_0AJVVNVHB0W0 Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_0EKDJR2Y0Q0G,CON_1VKTYAMBKM6G,1 Volume 4 PRD_0EKDJR2Y0Q0G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_0J2KAKKSX16G,CON_1VKTYAMBKM6G,1 Volume 6 PRD_0J2KAKKSX16G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_0JJGN3FPWSDG,CON_1VKTYAMBKM6G,1 Volume 12 PRD_0JJGN3FPWSDG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_0M0CGWSSW20G,CON_1VKTYAMBKM6G,1 Volume 11 PRD_0M0CGWSSW20G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_0Q9NT9MJWE1G,CON_1VKTYAMBKM6G,1 Volume 14 PRD_0Q9NT9MJWE1G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_1BNEGCM3S76G,CON_1VKTYAMBKM6G,1 Volume 1 PRD_1BNEGCM3S76G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_1EA478V7WXG0,CON_1VKTYAMBKM6G,1 Volume 1 PRD_1EA478V7WXG0 Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_1MB5QF4YPGGG,CON_1VKTYAMBKM6G,1 Volume 8 PRD_1MB5QF4YPGGG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_1MDZZ44KRK8G,CON_1VKTYAMBKM6G,1 Volume 15 PRD_1MDZZ44KRK8G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_1YY2Z5KT5670,CON_1VKTYAMBKM6G,1 Volume 16 PRD_1YY2Z5KT5670 Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_23CD2RBRAGHG,CON_1VKTYAMBKM6G,1 Volume 18 PRD_23CD2RBRAGHG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_27VEVZH9N3KG,CON_1VKTYAMBKM6G,1 Volume 5 PRD_27VEVZH9N3KG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_2EX7X8M1G86G,CON_1VKTYAMBKM6G,1 Volume 10 PRD_2EX7X8M1G86G Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_2TX4VFZBQSCG,CON_1VKTYAMBKM6G,1 Volume 17 PRD_2TX4VFZBQSCG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_2YSD22VX39PG,CON_1VKTYAMBKM6G,1 Volume 9 PRD_2YSD22VX39PG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_37YJR2ERDQRG,CON_1VKTYAMBKM6G,1 Volume 13 PRD_37YJR2ERDQRG Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_3AY4G7NSQG00,CON_1VKTYAMBKM6G,1 Volume 3 PRD_3AY4G7NSQG00 Mai Tanaka CON_1VKTYAMBKM6G 1  
PRD_3WHYTH4T9XEG,CON_1VKTYAMBKM6G,1 Volume 7 PRD_3WHYTH4T9XEG Mai Tanaka CON_1VKTYAMBKM6G 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.879ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS