BookWalker

home / database

product_contributors

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

35 rows where contributor_id = "CON_06P78WNSWSR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02CTNB7WQQ30,CON_06P78WNSWSR0,1 Chapter 35 PRD_02CTNB7WQQ30 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_04Z04PAJ3GYG,CON_06P78WNSWSR0,1 Chapter 31 PRD_04Z04PAJ3GYG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_08NQY4KWSWF0,CON_06P78WNSWSR0,1 Chapter 7 PRD_08NQY4KWSWF0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0BGDYAC7JD30,CON_06P78WNSWSR0,1 Chapter 15 PRD_0BGDYAC7JD30 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0E5EHYHN4T7G,CON_06P78WNSWSR0,1 Chapter 2 PRD_0E5EHYHN4T7G Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0P4Q7QHQQNVG,CON_06P78WNSWSR0,1 Chapter 34 PRD_0P4Q7QHQQNVG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0Q9S7HNCV47G,CON_06P78WNSWSR0,1 Chapter 23 PRD_0Q9S7HNCV47G Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0SBPWXD3ZKSG,CON_06P78WNSWSR0,1 Chapter 14 PRD_0SBPWXD3ZKSG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0TPN998ED6N0,CON_06P78WNSWSR0,1 Chapter 9 PRD_0TPN998ED6N0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0XR1FGF5VJRG,CON_06P78WNSWSR0,1 Chapter 12 PRD_0XR1FGF5VJRG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_0Y104NSQ38X0,CON_06P78WNSWSR0,1 Chapter 30 PRD_0Y104NSQ38X0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_14GW3SRDDEBG,CON_06P78WNSWSR0,1 Chapter 29 PRD_14GW3SRDDEBG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_193B09TWTK90,CON_06P78WNSWSR0,1 Chapter 3 PRD_193B09TWTK90 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1AEEENHF864G,CON_06P78WNSWSR0,1 Chapter 22 PRD_1AEEENHF864G Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1AJRPPRTYMA0,CON_06P78WNSWSR0,1 Chapter 6 PRD_1AJRPPRTYMA0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1JAVVD9YM3V0,CON_06P78WNSWSR0,1 Chapter 16 PRD_1JAVVD9YM3V0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1JQCMGBKTB10,CON_06P78WNSWSR0,1 Chapter 13 PRD_1JQCMGBKTB10 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1R8Y3912E860,CON_06P78WNSWSR0,1 Chapter 10 PRD_1R8Y3912E860 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_1SQFK5QPF4N0,CON_06P78WNSWSR0,1 Chapter 27 PRD_1SQFK5QPF4N0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2A51NSH1EHMG,CON_06P78WNSWSR0,1 Chapter 17 PRD_2A51NSH1EHMG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2CBBT6H39XC0,CON_06P78WNSWSR0,1 Chapter 28 PRD_2CBBT6H39XC0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2G3SNEEXW39G,CON_06P78WNSWSR0,1 Chapter 19 PRD_2G3SNEEXW39G Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2R372DY8YNGG,CON_06P78WNSWSR0,1 Chapter 1 PRD_2R372DY8YNGG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2V2EBK2YHKA0,CON_06P78WNSWSR0,1 Chapter 33 PRD_2V2EBK2YHKA0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2Z9K55DA0P60,CON_06P78WNSWSR0,1 Chapter 25 PRD_2Z9K55DA0P60 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_2ZQBX74C00EG,CON_06P78WNSWSR0,1 Chapter 20 PRD_2ZQBX74C00EG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3417MB6AA7N0,CON_06P78WNSWSR0,1 Chapter 21 PRD_3417MB6AA7N0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_38C8QXGNWTH0,CON_06P78WNSWSR0,1 Chapter 32 PRD_38C8QXGNWTH0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_38K5ZYR138PG,CON_06P78WNSWSR0,1 Chapter 18 PRD_38K5ZYR138PG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3F8KTJ51RKRG,CON_06P78WNSWSR0,1 Chapter 4 PRD_3F8KTJ51RKRG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3GST5SK5NXK0,CON_06P78WNSWSR0,1 Chapter 26 PRD_3GST5SK5NXK0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3GWQDTTGRBGG,CON_06P78WNSWSR0,1 Chapter 11 PRD_3GWQDTTGRBGG Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3X24Z5AY5SQ0,CON_06P78WNSWSR0,1 Chapter 5 PRD_3X24Z5AY5SQ0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3YDMDJ8VSTG0,CON_06P78WNSWSR0,1 Chapter 24 PRD_3YDMDJ8VSTG0 Marie Yoshida CON_06P78WNSWSR0 1  
PRD_3YG6NKG7C8NG,CON_06P78WNSWSR0,1 Chapter 8 PRD_3YG6NKG7C8NG Marie Yoshida CON_06P78WNSWSR0 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 10.629ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS