BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_3A5E29X6H1GG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02SS8APJA5M0,CON_3A5E29X6H1GG,1 Volume 12 PRD_02SS8APJA5M0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0BZWD12FDQ9G,CON_3A5E29X6H1GG,1 Volume 14 PRD_0BZWD12FDQ9G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0DD5YQGGRDA0,CON_3A5E29X6H1GG,1 Volume 15 PRD_0DD5YQGGRDA0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0FBEG7DARFA0,CON_3A5E29X6H1GG,1 Volume 5 PRD_0FBEG7DARFA0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0GZKVMSVX340,CON_3A5E29X6H1GG,1 Volume 15 PRD_0GZKVMSVX340 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0MVT0EZEKZ90,CON_3A5E29X6H1GG,1 Volume 17 PRD_0MVT0EZEKZ90 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0P017E0BCSEG,CON_3A5E29X6H1GG,1 Volume 6 PRD_0P017E0BCSEG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0RA2HPHP5ZYG,CON_3A5E29X6H1GG,1 Volume 18 PRD_0RA2HPHP5ZYG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_0ZH6SYRRRKV0,CON_3A5E29X6H1GG,1 Volume 13 PRD_0ZH6SYRRRKV0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_11DAHTE9GCHG,CON_3A5E29X6H1GG,1 Volume 11 PRD_11DAHTE9GCHG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1DAEWJQW2VR0,CON_3A5E29X6H1GG,1 Volume 7 PRD_1DAEWJQW2VR0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1ENZHZNT6WS0,CON_3A5E29X6H1GG,1 Volume 9 PRD_1ENZHZNT6WS0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1F14SK7R49PG,CON_3A5E29X6H1GG,1 Volume 9 PRD_1F14SK7R49PG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1N2XKC31CW3G,CON_3A5E29X6H1GG,1 Volume 1 PRD_1N2XKC31CW3G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1QE9HJNXV05G,CON_3A5E29X6H1GG,1 Volume 4 PRD_1QE9HJNXV05G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1SKCY0XB8V2G,CON_3A5E29X6H1GG,1 Volume 1 PRD_1SKCY0XB8V2G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1TMH97DXRZ0G,CON_3A5E29X6H1GG,1 Volume 8 PRD_1TMH97DXRZ0G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1TWRR0ASCCF0,CON_3A5E29X6H1GG,1 Volume 6 PRD_1TWRR0ASCCF0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_1YPERACZB87G,CON_3A5E29X6H1GG,1 Volume 10 PRD_1YPERACZB87G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_24CYHDRB6DQG,CON_3A5E29X6H1GG,1 Volume 4 PRD_24CYHDRB6DQG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2F5X4D1KTETG,CON_3A5E29X6H1GG,1 Volume 16 PRD_2F5X4D1KTETG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2M99SRK8ASY0,CON_3A5E29X6H1GG,1 Volume 10 PRD_2M99SRK8ASY0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2P47PS34CQMG,CON_3A5E29X6H1GG,1 Volume 12 PRD_2P47PS34CQMG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2PJJF4C9NGSG,CON_3A5E29X6H1GG,1 Volume 18 PRD_2PJJF4C9NGSG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2S9Y0M9VTKBG,CON_3A5E29X6H1GG,1 Volume 14 PRD_2S9Y0M9VTKBG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_2VHXY1J0BR4G,CON_3A5E29X6H1GG,1 Volume 16 PRD_2VHXY1J0BR4G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_326XK3GQFCAG,CON_3A5E29X6H1GG,1 Volume 8 PRD_326XK3GQFCAG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_37SZ1AZM658G,CON_3A5E29X6H1GG,1 Volume 17 PRD_37SZ1AZM658G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3CX6A84Z4V8G,CON_3A5E29X6H1GG,1 Volume 5 PRD_3CX6A84Z4V8G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3DMVB732BHB0,CON_3A5E29X6H1GG,1 Volume 13 PRD_3DMVB732BHB0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3MD2BAV0VF5G,CON_3A5E29X6H1GG,1 Volume 7 PRD_3MD2BAV0VF5G Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3NQGAV42S0N0,CON_3A5E29X6H1GG,1 Volume 3 PRD_3NQGAV42S0N0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3R40ME655FM0,CON_3A5E29X6H1GG,1 Volume 2 PRD_3R40ME655FM0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3VA45PJ6AWK0,CON_3A5E29X6H1GG,1 Volume 2 PRD_3VA45PJ6AWK0 Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3XWE9DVEP9XG,CON_3A5E29X6H1GG,1 Volume 11 PRD_3XWE9DVEP9XG Saki Hasemi CON_3A5E29X6H1GG 1  
PRD_3YZ1M5BD2PT0,CON_3A5E29X6H1GG,1 Volume 3 PRD_3YZ1M5BD2PT0 Saki Hasemi CON_3A5E29X6H1GG 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.169ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS