BookWalker

home / database

product_contributors

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

54 rows where contributor_id = "CON_0FK5DBNBP6NG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00QS5GCF4CAG,CON_0FK5DBNBP6NG,2 Volume 8 PRD_00QS5GCF4CAG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_02NJJKF1K640,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 18 PRD_02NJJKF1K640 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0749Q39H0B9G,CON_0FK5DBNBP6NG,2 Volume 3 PRD_0749Q39H0B9G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_089CSC4G7390,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 20 PRD_089CSC4G7390 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0BTR2PBVCA8G,CON_0FK5DBNBP6NG,2 Volume 1 PRD_0BTR2PBVCA8G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0CV2WZZEWMAG,CON_0FK5DBNBP6NG,2 FireRed and LeafGreen, Vol. 24 PRD_0CV2WZZEWMAG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0CZZ4Z6T3280,CON_0FK5DBNBP6NG,2 FireRed and LeafGreen, Vol. 23 PRD_0CZZ4Z6T3280 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0K73FB1N2FH0,CON_0FK5DBNBP6NG,2 Volume 8 PRD_0K73FB1N2FH0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0SCD798Q9G70,CON_0FK5DBNBP6NG,2 Volume 1 PRD_0SCD798Q9G70 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0SGYFAG2WE4G,CON_0FK5DBNBP6NG,2 Volume 2 PRD_0SGYFAG2WE4G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0VPKMDKNAR60,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 17 PRD_0VPKMDKNAR60 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0W1ETXJ4RDBG,CON_0FK5DBNBP6NG,2 Volume 10 PRD_0W1ETXJ4RDBG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0X67JP9PSFJ0,CON_0FK5DBNBP6NG,2 Volume 4 PRD_0X67JP9PSFJ0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0XVP2VV2RK30,CON_0FK5DBNBP6NG,2 Volume 2 PRD_0XVP2VV2RK30 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_0Y7270DZQ750,CON_0FK5DBNBP6NG,2 Gold and Silver, Vol. 13 PRD_0Y7270DZQ750 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_100ECHDKMYCG,CON_0FK5DBNBP6NG,2 Gold and Silver, Vol. 12 PRD_100ECHDKMYCG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_133PMRP1QX60,CON_0FK5DBNBP6NG,2 Volume 2 PRD_133PMRP1QX60 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_14PYY4FNGYKG,CON_0FK5DBNBP6NG,2 Gold and Silver, Vol. 11 PRD_14PYY4FNGYKG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_162A6EJS65K0,CON_0FK5DBNBP6NG,2 Volume 3 PRD_162A6EJS65K0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_17VCPC32CR80,CON_0FK5DBNBP6NG,2 Volume 2 PRD_17VCPC32CR80 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_192RMK6SVNKG,CON_0FK5DBNBP6NG,2 Volume 5 PRD_192RMK6SVNKG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1DCYY6RGH5D0,CON_0FK5DBNBP6NG,2 Volume 1 PRD_1DCYY6RGH5D0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1K9XFJRGRK9G,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 22 PRD_1K9XFJRGRK9G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1P2Y1526B0E0,CON_0FK5DBNBP6NG,2 Emerald, Vol. 29 PRD_1P2Y1526B0E0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1R7XFK5KRVB0,CON_0FK5DBNBP6NG,2 Volume 6 PRD_1R7XFK5KRVB0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1WBRS350YJW0,CON_0FK5DBNBP6NG,2 Volume 1 PRD_1WBRS350YJW0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1WRY17F1B8FG,CON_0FK5DBNBP6NG,2 Volume 4 PRD_1WRY17F1B8FG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_1YXCPBP7CGEG,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 16 PRD_1YXCPBP7CGEG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_22EPK7XA6DV0,CON_0FK5DBNBP6NG,2 Volume 9 PRD_22EPK7XA6DV0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_25DG8DRPEBS0,CON_0FK5DBNBP6NG,2 Volume 2 PRD_25DG8DRPEBS0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_26H96Q4A2JHG,CON_0FK5DBNBP6NG,2 Volume 2 PRD_26H96Q4A2JHG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_26RMPSQ0ZYMG,CON_0FK5DBNBP6NG,2 Volume 11 PRD_26RMPSQ0ZYMG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_26Z1YTZC2CT0,CON_0FK5DBNBP6NG,2 Volume 3 PRD_26Z1YTZC2CT0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_27KNPGR8X5TG,CON_0FK5DBNBP6NG,2 Emerald, Vol. 28 PRD_27KNPGR8X5TG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2G4MST5HP1Q0,CON_0FK5DBNBP6NG,2 Volume 4 PRD_2G4MST5HP1Q0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2M1MV9TFJV50,CON_0FK5DBNBP6NG,2 Volume 7 PRD_2M1MV9TFJV50 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2MN7BD7VJ0P0,CON_0FK5DBNBP6NG,2 Volume 6 PRD_2MN7BD7VJ0P0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2N9B330GCSPG,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 19 PRD_2N9B330GCSPG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2RTGEXZX589G,CON_0FK5DBNBP6NG,2 Volume 5 PRD_2RTGEXZX589G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2SZTEP2T8RNG,CON_0FK5DBNBP6NG,2 FireRed and LeafGreen, Vol. 25 PRD_2SZTEP2T8RNG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2VBQP01XYFN0,CON_0FK5DBNBP6NG,2 Volume 5 PRD_2VBQP01XYFN0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2WCARAWWN7MG,CON_0FK5DBNBP6NG,2 Emerald, Vol. 27 PRD_2WCARAWWN7MG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_2ZR61K37TEM0,CON_0FK5DBNBP6NG,2 Volume 4 PRD_2ZR61K37TEM0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_31N2D43VR53G,CON_0FK5DBNBP6NG,2 Volume 3 PRD_31N2D43VR53G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_33V7T73EPZX0,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 15 PRD_33V7T73EPZX0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_340Q8PJ7ARZG,CON_0FK5DBNBP6NG,2 Volume 7 PRD_340Q8PJ7ARZG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_34BJRRXY442G,CON_0FK5DBNBP6NG,2 Volume 1 PRD_34BJRRXY442G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_35XT0NAM4AT0,CON_0FK5DBNBP6NG,2 Volume 6 PRD_35XT0NAM4AT0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_38RDABZ0031G,CON_0FK5DBNBP6NG,2 Volume 1 PRD_38RDABZ0031G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_3AY6QEYTYX30,CON_0FK5DBNBP6NG,2 Gold and Silver, Vol. 10 PRD_3AY6QEYTYX30 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_3FEXNYSAC20G,CON_0FK5DBNBP6NG,2 Volume 9 PRD_3FEXNYSAC20G Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_3HH50VBP6KS0,CON_0FK5DBNBP6NG,2 Ruby and Sapphire, Vol. 21 PRD_3HH50VBP6KS0 Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_3HNP8WK1D1YG,CON_0FK5DBNBP6NG,2 Emerald, Vol. 26 PRD_3HNP8WK1D1YG Satoshi Yamamoto CON_0FK5DBNBP6NG 2  
PRD_3ZAQ8M14AGY0,CON_0FK5DBNBP6NG,2 Gold and Silver, Vol. 14 PRD_3ZAQ8M14AGY0 Satoshi Yamamoto CON_0FK5DBNBP6NG 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.416ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS