BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_3FJP6PJ3ZZD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_06ZC0A8WM0FG,CON_3FJP6PJ3ZZD0,1 Volume 11 PRD_06ZC0A8WM0FG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_075ECQQMX9E0,CON_3FJP6PJ3ZZD0,1 Volume 1 PRD_075ECQQMX9E0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_07AYXJRTRD40,CON_3FJP6PJ3ZZD0,1 Volume 15 PRD_07AYXJRTRD40 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_0914CKQ2G5CG,CON_3FJP6PJ3ZZD0,1 Volume 12 PRD_0914CKQ2G5CG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_12CZJZYB8JK0,CON_3FJP6PJ3ZZD0,1 Volume 2 PRD_12CZJZYB8JK0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_13JH99YRS720,CON_3FJP6PJ3ZZD0,1 Volume 2 PRD_13JH99YRS720 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_187WWTC71ZQ0,CON_3FJP6PJ3ZZD0,1 Volume 10 PRD_187WWTC71ZQ0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_19D0DYMPQS2G,CON_3FJP6PJ3ZZD0,1 Volume 4 PRD_19D0DYMPQS2G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_1CNBD5ME4FSG,CON_3FJP6PJ3ZZD0,1 Volume 1 PRD_1CNBD5ME4FSG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_1SG3NRCFWDJG,CON_3FJP6PJ3ZZD0,1 Volume 14 PRD_1SG3NRCFWDJG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_1VS2C13SYP2G,CON_3FJP6PJ3ZZD0,1 Volume 3 PRD_1VS2C13SYP2G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_1ZGN820Y5V8G,CON_3FJP6PJ3ZZD0,1 Volume 7 PRD_1ZGN820Y5V8G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_211CJ1Z5VDXG,CON_3FJP6PJ3ZZD0,1 Volume 8 PRD_211CJ1Z5VDXG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_21XN32XEJHFG,CON_3FJP6PJ3ZZD0,1 Volume 13 PRD_21XN32XEJHFG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_23CSTPRSBYC0,CON_3FJP6PJ3ZZD0,1 Volume 8 PRD_23CSTPRSBYC0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_273SP8WDR3HG,CON_3FJP6PJ3ZZD0,1 Volume 20 PRD_273SP8WDR3HG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_29PN8A6D3300,CON_3FJP6PJ3ZZD0,1 Volume 3 PRD_29PN8A6D3300 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2D7SZA6SFMS0,CON_3FJP6PJ3ZZD0,1 Volume 6 PRD_2D7SZA6SFMS0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2FASB5FGMZY0,CON_3FJP6PJ3ZZD0,1 Volume 1 PRD_2FASB5FGMZY0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2FNHKV28DDJ0,CON_3FJP6PJ3ZZD0,1 Volume 7 PRD_2FNHKV28DDJ0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2JHF3J0J4KH0,CON_3FJP6PJ3ZZD0,1 Volume 11 PRD_2JHF3J0J4KH0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2Q2NZS1TSVMG,CON_3FJP6PJ3ZZD0,1 Volume 9 PRD_2Q2NZS1TSVMG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2RB6A0QAM58G,CON_3FJP6PJ3ZZD0,1 Volume 18 PRD_2RB6A0QAM58G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2SD2WG5BYDN0,CON_3FJP6PJ3ZZD0,1 Volume 12 PRD_2SD2WG5BYDN0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_2YE8QNK6ZJSG,CON_3FJP6PJ3ZZD0,1 Volume 14 PRD_2YE8QNK6ZJSG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3260S1YNQTWG,CON_3FJP6PJ3ZZD0,1 Volume 16 PRD_3260S1YNQTWG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_32RN3WV5A6E0,CON_3FJP6PJ3ZZD0,1 Volume 10 PRD_32RN3WV5A6E0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_34T1V6KVHWGG,CON_3FJP6PJ3ZZD0,1 Volume 9 PRD_34T1V6KVHWGG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3BBH437SG33G,CON_3FJP6PJ3ZZD0,1 Volume 17 PRD_3BBH437SG33G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3CKKBM16FFT0,CON_3FJP6PJ3ZZD0,1 Volume 19 PRD_3CKKBM16FFT0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3GDJ6W3ZRG1G,CON_3FJP6PJ3ZZD0,1 Volume 5 PRD_3GDJ6W3ZRG1G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3JFVBEP3H8N0,CON_3FJP6PJ3ZZD0,1 Volume 13 PRD_3JFVBEP3H8N0 Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3M1PRVBPV58G,CON_3FJP6PJ3ZZD0,1 Volume 4 PRD_3M1PRVBPV58G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3MX4DPQWXMDG,CON_3FJP6PJ3ZZD0,1 Volume 5 PRD_3MX4DPQWXMDG Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3TZD5NMAZM3G,CON_3FJP6PJ3ZZD0,1 Volume 6 PRD_3TZD5NMAZM3G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3WAT3Q7KZJ2G,CON_3FJP6PJ3ZZD0,1 Volume 3 PRD_3WAT3Q7KZJ2G Fuminori Teshima CON_3FJP6PJ3ZZD0 1  
PRD_3Z0VE9HK245G,CON_3FJP6PJ3ZZD0,1 Volume 2 PRD_3Z0VE9HK245G Fuminori Teshima CON_3FJP6PJ3ZZD0 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.855ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS