BookWalker

home / database

product_contributors

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

46 rows where contributor_id = "CON_0Q8BNWHJQDYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0222AS3KVCM0,CON_0Q8BNWHJQDYG,1 Volume 3 PRD_0222AS3KVCM0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_035DT20H95GG,CON_0Q8BNWHJQDYG,1 Volume 7 PRD_035DT20H95GG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_05WPRFQXYAQ0,CON_0Q8BNWHJQDYG,1 Volume 6 PRD_05WPRFQXYAQ0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_090CZY4ZA73G,CON_0Q8BNWHJQDYG,1 Volume 5 PRD_090CZY4ZA73G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0F6MBQHP0ZXG,CON_0Q8BNWHJQDYG,1 Volume 10 PRD_0F6MBQHP0ZXG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0PEGMQD859W0,CON_0Q8BNWHJQDYG,1 Volume 10 PRD_0PEGMQD859W0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0PFWTFVCZT7G,CON_0Q8BNWHJQDYG,1 Volume 5 PRD_0PFWTFVCZT7G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0RWXXNJ6SEF0,CON_0Q8BNWHJQDYG,1 Volume 8 PRD_0RWXXNJ6SEF0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0VC6NQE0C41G,CON_0Q8BNWHJQDYG,1 Volume 7 PRD_0VC6NQE0C41G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0VPZZAEN1EA0,CON_0Q8BNWHJQDYG,1 Volume 1 PRD_0VPZZAEN1EA0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0W6NZGQ8RB3G,CON_0Q8BNWHJQDYG,1 Volume 4 PRD_0W6NZGQ8RB3G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0X2F4QQ5H2E0,CON_0Q8BNWHJQDYG,1 Volume 9 PRD_0X2F4QQ5H2E0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_0ZP6NRBXWYTG,CON_0Q8BNWHJQDYG,1 Volume 7 PRD_0ZP6NRBXWYTG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_130344WB254G,CON_0Q8BNWHJQDYG,1 Volume 1 PRD_130344WB254G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_154B2ZNDTB00,CON_0Q8BNWHJQDYG,1 Volume 14 PRD_154B2ZNDTB00 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_16T4877N3YWG,CON_0Q8BNWHJQDYG,1 Volume 9 PRD_16T4877N3YWG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1AE9HBBE7FDG,CON_0Q8BNWHJQDYG,1 Volume 4 PRD_1AE9HBBE7FDG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1EJ7FVG1JD80,CON_0Q8BNWHJQDYG,1 Volume 5 PRD_1EJ7FVG1JD80 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1GXE7XQ43M7G,CON_0Q8BNWHJQDYG,1 Volume 13 PRD_1GXE7XQ43M7G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1J56W53XG6KG,CON_0Q8BNWHJQDYG,1 Volume 8 PRD_1J56W53XG6KG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1J78KXAPGSY0,CON_0Q8BNWHJQDYG,1 Volume 2 PRD_1J78KXAPGSY0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1S1E80SQQ5F0,CON_0Q8BNWHJQDYG,1 Volume 11 PRD_1S1E80SQQ5F0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1W49HK6RV870,CON_0Q8BNWHJQDYG,1 Volume 12 PRD_1W49HK6RV870 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1YGYH6QH9ZH0,CON_0Q8BNWHJQDYG,1 Volume 9 PRD_1YGYH6QH9ZH0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1YSM8CZP4MAG,CON_0Q8BNWHJQDYG,1 Volume 2 PRD_1YSM8CZP4MAG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_1ZE7DN0AYYPG,CON_0Q8BNWHJQDYG,1 Volume 3 PRD_1ZE7DN0AYYPG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_22TVMNXNMF20,CON_0Q8BNWHJQDYG,1 Volume 1 PRD_22TVMNXNMF20 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_24X37E89VHN0,CON_0Q8BNWHJQDYG,1 Volume 4 PRD_24X37E89VHN0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2AWFP6VM12V0,CON_0Q8BNWHJQDYG,1 Volume 12 PRD_2AWFP6VM12V0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2BG0RGMNZJPG,CON_0Q8BNWHJQDYG,1 Volume 13 PRD_2BG0RGMNZJPG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2C4RPV3PY9QG,CON_0Q8BNWHJQDYG,1 Volume 3 PRD_2C4RPV3PY9QG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2CW1FX7K90N0,CON_0Q8BNWHJQDYG,1 Volume 6 PRD_2CW1FX7K90N0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2Q2R9XWMADF0,CON_0Q8BNWHJQDYG,1 Volume 1 PRD_2Q2R9XWMADF0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_2YB5H2BYYY0G,CON_0Q8BNWHJQDYG,1 Volume 2 PRD_2YB5H2BYYY0G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_30F3BRW9KBF0,CON_0Q8BNWHJQDYG,1 Volume 3 PRD_30F3BRW9KBF0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_32RRKTD646N0,CON_0Q8BNWHJQDYG,1 Volume 2 PRD_32RRKTD646N0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_36ZPCFBMYSG0,CON_0Q8BNWHJQDYG,1 Volume 6 PRD_36ZPCFBMYSG0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_384GVZ8TSJNG,CON_0Q8BNWHJQDYG,1 Volume 7 PRD_384GVZ8TSJNG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3EMABM24DXGG,CON_0Q8BNWHJQDYG,1 Volume 15 PRD_3EMABM24DXGG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3FKVDAEZ0R4G,CON_0Q8BNWHJQDYG,1 Volume 6 PRD_3FKVDAEZ0R4G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3H79XRY2E3X0,CON_0Q8BNWHJQDYG,1 Volume 4 PRD_3H79XRY2E3X0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3HAJ34X97TV0,CON_0Q8BNWHJQDYG,1 Volume 8 PRD_3HAJ34X97TV0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3HHJXVRQMBB0,CON_0Q8BNWHJQDYG,1 Volume 8 PRD_3HHJXVRQMBB0 Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3QVXMEVYRWXG,CON_0Q8BNWHJQDYG,1 Volume 5 PRD_3QVXMEVYRWXG Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3SXBPQQ97J6G,CON_0Q8BNWHJQDYG,1 Volume 10 PRD_3SXBPQQ97J6G Takahiro CON_0Q8BNWHJQDYG 1  
PRD_3TDDHTNQM2VG,CON_0Q8BNWHJQDYG,1 Volume 11 PRD_3TDDHTNQM2VG Takahiro CON_0Q8BNWHJQDYG 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 12.183ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS