BookWalker

home / database

product_contributors

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

27 rows where contributor_id = "CON_1BSDDHJV1BYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_056RM35R642G,CON_1BSDDHJV1BYG,1 Volume 24 PRD_056RM35R642G Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_06G8AGBNT53G,CON_1BSDDHJV1BYG,1 Volume 25 PRD_06G8AGBNT53G Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_06MTJHK10K10,CON_1BSDDHJV1BYG,1 Volume 1 PRD_06MTJHK10K10 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_09QB7P72231G,CON_1BSDDHJV1BYG,1 Volume 17 PRD_09QB7P72231G Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_0C5VH914E20G,CON_1BSDDHJV1BYG,1 Volume 15 PRD_0C5VH914E20G Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_0MBXF38J7BT0,CON_1BSDDHJV1BYG,1 Volume 11 PRD_0MBXF38J7BT0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_0MEFQ4GXDSZG,CON_1BSDDHJV1BYG,1 Volume 9 PRD_0MEFQ4GXDSZG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_0V3BARNJWPW0,CON_1BSDDHJV1BYG,1 Volume 7 PRD_0V3BARNJWPW0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_12WMP9T6TDBG,CON_1BSDDHJV1BYG,1 Volume 4 PRD_12WMP9T6TDBG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_18G6Y2KNEA8G,CON_1BSDDHJV1BYG,1 Volume 18 PRD_18G6Y2KNEA8G Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_1F6H9NDZA9FG,CON_1BSDDHJV1BYG,1 Volume 14 PRD_1F6H9NDZA9FG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_20FJR70W2MHG,CON_1BSDDHJV1BYG,1 Volume 2 PRD_20FJR70W2MHG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_24SG3TTTR5K0,CON_1BSDDHJV1BYG,1 Volume 22 PRD_24SG3TTTR5K0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_24WDBT26EKGG,CON_1BSDDHJV1BYG,1 Volume 19 PRD_24WDBT26EKGG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_2BE3DDMX44J0,CON_1BSDDHJV1BYG,1 Volume 23 PRD_2BE3DDMX44J0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_2FWKR0P703H0,CON_1BSDDHJV1BYG,1 Volume 16 PRD_2FWKR0P703H0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_2S8K314QTPKG,CON_1BSDDHJV1BYG,1 Volume 6 PRD_2S8K314QTPKG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_2TQP8D32BRF0,CON_1BSDDHJV1BYG,1 Volume 10 PRD_2TQP8D32BRF0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_2TT0GEBDYPCG,CON_1BSDDHJV1BYG,1 Volume 8 PRD_2TT0GEBDYPCG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_33120JXRNZNG,CON_1BSDDHJV1BYG,1 Volume 27 PRD_33120JXRNZNG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_335Z8J5BRDV0,CON_1BSDDHJV1BYG,1 Volume 3 PRD_335Z8J5BRDV0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_37K0A4QQB0Q0,CON_1BSDDHJV1BYG,1 Volume 26 PRD_37K0A4QQB0Q0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_3A8Y5R0G0BS0,CON_1BSDDHJV1BYG,1 Volume 21 PRD_3A8Y5R0G0BS0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_3ESEQB2TCAR0,CON_1BSDDHJV1BYG,1 Volume 20 PRD_3ESEQB2TCAR0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_3JD2BKG9C2G0,CON_1BSDDHJV1BYG,1 Volume 13 PRD_3JD2BKG9C2G0 Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_3PZ0D5A05KHG,CON_1BSDDHJV1BYG,1 Volume 12 PRD_3PZ0D5A05KHG Norihiro Yagi CON_1BSDDHJV1BYG 1  
PRD_3WQCXZB1WEM0,CON_1BSDDHJV1BYG,1 Volume 5 PRD_3WQCXZB1WEM0 Norihiro Yagi CON_1BSDDHJV1BYG 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 9.51ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS