BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_0REGXYJ0EAXG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0C56PWA8E0RG,CON_0REGXYJ0EAXG,2 Volume 1 PRD_0C56PWA8E0RG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_0FRM2PR5XPQG,CON_0REGXYJ0EAXG,2 Eighth Bite PRD_0FRM2PR5XPQG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_0MKYMR6CDN1G,CON_0REGXYJ0EAXG,2 Volume 8 PRD_0MKYMR6CDN1G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_0N3A1AVWGDXG,CON_0REGXYJ0EAXG,2 Volume 1 PRD_0N3A1AVWGDXG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_0SRE2XQ3B660,CON_0REGXYJ0EAXG,2 Seventh Bite PRD_0SRE2XQ3B660 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_0SVZN73R878G,CON_0REGXYJ0EAXG,2 First Bite PRD_0SVZN73R878G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_18D8HZ89B3VG,CON_0REGXYJ0EAXG,2 Volume 6 PRD_18D8HZ89B3VG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1B2AW099TFB0,CON_0REGXYJ0EAXG,2 Volume 3 PRD_1B2AW099TFB0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1DQX718DW51G,CON_0REGXYJ0EAXG,2 Volume 1 PRD_1DQX718DW51G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1DZ7GGFDDAW0,CON_0REGXYJ0EAXG,2 Volume 2 PRD_1DZ7GGFDDAW0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1EJMY0F3QAJ0,CON_0REGXYJ0EAXG,2 Second Bite PRD_1EJMY0F3QAJ0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1FNBA0B7DCW0,CON_0REGXYJ0EAXG,2 Volume 2 PRD_1FNBA0B7DCW0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1G74F35AYCYG,CON_0REGXYJ0EAXG,2 Volume 7 PRD_1G74F35AYCYG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1JPCRPSF601G,CON_0REGXYJ0EAXG,2 Volume 8 PRD_1JPCRPSF601G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1M9MW5R19YE0,CON_0REGXYJ0EAXG,2 Volume 4 PRD_1M9MW5R19YE0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1MHDZQT2BP30,CON_0REGXYJ0EAXG,2 Volume 3 PRD_1MHDZQT2BP30 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_1YAJF06E5JP0,CON_0REGXYJ0EAXG,2 Volume 11 PRD_1YAJF06E5JP0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_20344H3P9V4G,CON_0REGXYJ0EAXG,2 Volume 9 PRD_20344H3P9V4G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_21WCZ8Q9BQMG,CON_0REGXYJ0EAXG,2 Volume 5 PRD_21WCZ8Q9BQMG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_21XTJ7R8QYHG,CON_0REGXYJ0EAXG,2 Volume 4 PRD_21XTJ7R8QYHG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_25X66HMG5T30,CON_0REGXYJ0EAXG,2 Volume 5 PRD_25X66HMG5T30 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2707NGEP5RXG,CON_0REGXYJ0EAXG,2 Volume 4 PRD_2707NGEP5RXG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2GVMW93TPPAG,CON_0REGXYJ0EAXG,2 Volume 5 PRD_2GVMW93TPPAG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2GYNPD671Q2G,CON_0REGXYJ0EAXG,2 Volume 2 PRD_2GYNPD671Q2G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2KASR7DCGTG0,CON_0REGXYJ0EAXG,2 Volume 12 PRD_2KASR7DCGTG0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2RM269BTK33G,CON_0REGXYJ0EAXG,2 Volume 10 PRD_2RM269BTK33G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_2ZE7EJZKBZH0,CON_0REGXYJ0EAXG,2 Third Bite PRD_2ZE7EJZKBZH0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_30V309AN7RYG,CON_0REGXYJ0EAXG,2 Volume 6 PRD_30V309AN7RYG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_34BD9J6W2RRG,CON_0REGXYJ0EAXG,2 Fifth Bite PRD_34BD9J6W2RRG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_363GBMADNHMG,CON_0REGXYJ0EAXG,2 Volume 5 PRD_363GBMADNHMG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_370A7F1R3CJG,CON_0REGXYJ0EAXG,2 Fourth Bite PRD_370A7F1R3CJG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3QMS7CMJYNN0,CON_0REGXYJ0EAXG,2 Volume 4 PRD_3QMS7CMJYNN0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3RBPRW5CBZ1G,CON_0REGXYJ0EAXG,2 Volume 7 PRD_3RBPRW5CBZ1G Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3VC0V2QRT020,CON_0REGXYJ0EAXG,2 Volume 6 PRD_3VC0V2QRT020 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3WQ6VVB0YVN0,CON_0REGXYJ0EAXG,2 Volume 9 PRD_3WQ6VVB0YVN0 Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3WVK3WKC59TG,CON_0REGXYJ0EAXG,2 Volume 3 PRD_3WVK3WKC59TG Asagi Tohsaka CON_0REGXYJ0EAXG 2  
PRD_3YAQ5GMXKX0G,CON_0REGXYJ0EAXG,2 Sixth Bite PRD_3YAQ5GMXKX0G Asagi Tohsaka CON_0REGXYJ0EAXG 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 11.096ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS