BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_2R4P2BV0YN20"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03QAQ846S7TG,CON_2R4P2BV0YN20,1 Volume 4 PRD_03QAQ846S7TG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0451FW531DG0,CON_2R4P2BV0YN20,1 Volume 1 PRD_0451FW531DG0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_06452V6956SG,CON_2R4P2BV0YN20,1 Volume 1 PRD_06452V6956SG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0M3VFFEGMTNG,CON_2R4P2BV0YN20,1 Volume 3 PRD_0M3VFFEGMTNG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0N6R5RY46XB0,CON_2R4P2BV0YN20,1 Volume 6 PRD_0N6R5RY46XB0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0RGBT28TGSMG,CON_2R4P2BV0YN20,1 Volume 6 PRD_0RGBT28TGSMG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0S9GZ814321G,CON_2R4P2BV0YN20,1 Volume 9 PRD_0S9GZ814321G Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0X8202K98K10,CON_2R4P2BV0YN20,1 Volume 1 PRD_0X8202K98K10 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_0Z6T5NAWWRVG,CON_2R4P2BV0YN20,1 Volume 9 PRD_0Z6T5NAWWRVG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_14RCNCZDR650,CON_2R4P2BV0YN20,1 Volume 2 PRD_14RCNCZDR650 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_1DTPP8KTGGNG,CON_2R4P2BV0YN20,1 Volume 3 PRD_1DTPP8KTGGNG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_1RERZNNAJ7E0,CON_2R4P2BV0YN20,1 Volume 10 PRD_1RERZNNAJ7E0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_1Z25H9YR4NJG,CON_2R4P2BV0YN20,1 Volume 5 PRD_1Z25H9YR4NJG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_21WX9JQ476A0,CON_2R4P2BV0YN20,1 Volume 10 PRD_21WX9JQ476A0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_24DDV5HE3590,CON_2R4P2BV0YN20,1 Volume 2 PRD_24DDV5HE3590 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2820V0TRAAR0,CON_2R4P2BV0YN20,1 Volume 2 PRD_2820V0TRAAR0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2H9YSM9EXG30,CON_2R4P2BV0YN20,1 Volume 8 PRD_2H9YSM9EXG30 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2MSHKEF6RYVG,CON_2R4P2BV0YN20,1 Volume 7 PRD_2MSHKEF6RYVG Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2TB31SSNJS50,CON_2R4P2BV0YN20,1 Volume 7 PRD_2TB31SSNJS50 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2XE2YZN1V7B0,CON_2R4P2BV0YN20,1 Volume 8 PRD_2XE2YZN1V7B0 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_2YSKKCVZYR40,CON_2R4P2BV0YN20,1 Volume 5 PRD_2YSKKCVZYR40 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_3FDEXY0NJG60,CON_2R4P2BV0YN20,1 Volume 4 PRD_3FDEXY0NJG60 Akira Himekawa CON_2R4P2BV0YN20 1  
PRD_3YTXRZFV6N30,CON_2R4P2BV0YN20,1 Volume 11 PRD_3YTXRZFV6N30 Akira Himekawa CON_2R4P2BV0YN20 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.234ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS