BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_0AVG55PKQGNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_100NPNJCJ2KG,CON_0AVG55PKQGNG,1 Volume 12 PRD_100NPNJCJ2KG Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_116QM5J3GMH0,CON_0AVG55PKQGNG,1 Volume 9 PRD_116QM5J3GMH0 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_11XVKF10N02G,CON_0AVG55PKQGNG,1 Volume 6 PRD_11XVKF10N02G Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_1975BR6K3W7G,CON_0AVG55PKQGNG,1 Volume 2 PRD_1975BR6K3W7G Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_1P9ZX13DJ59G,CON_0AVG55PKQGNG,1 Volume 11 PRD_1P9ZX13DJ59G Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_22D6P54MW190,CON_0AVG55PKQGNG,1 Volume 8 PRD_22D6P54MW190 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_2N97QV0PE3GG,CON_0AVG55PKQGNG,1 Volume 3 PRD_2N97QV0PE3GG Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_39V0DKS9P180,CON_0AVG55PKQGNG,1 Volume 1 PRD_39V0DKS9P180 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_3AKEWHMKTRV0,CON_0AVG55PKQGNG,1 Volume 5 PRD_3AKEWHMKTRV0 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_3EJCPEXJMVD0,CON_0AVG55PKQGNG,1 Volume 7 PRD_3EJCPEXJMVD0 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_3N69QV8234J0,CON_0AVG55PKQGNG,1 Volume 10 PRD_3N69QV8234J0 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_3QH6H2WBEZG0,CON_0AVG55PKQGNG,1 Volume 4 PRD_3QH6H2WBEZG0 Norio Sakurai CON_0AVG55PKQGNG 1  
PRD_3S1MCWH1TAB0,CON_0AVG55PKQGNG,2 The Dangers in My Heart - The Novel PRD_3S1MCWH1TAB0 Norio Sakurai CON_0AVG55PKQGNG 2  

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