BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_0R05H650XCKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03MBCWJAJ5Z0,CON_0R05H650XCKG,1 Chapter 18 PRD_03MBCWJAJ5Z0 Midori Akino CON_0R05H650XCKG 1  
PRD_060TJ7AVC2E0,CON_0R05H650XCKG,1 Chapter 24 PRD_060TJ7AVC2E0 Midori Akino CON_0R05H650XCKG 1  
PRD_06AVYFCCY4Y0,CON_0R05H650XCKG,1 Chapter 17 PRD_06AVYFCCY4Y0 Midori Akino CON_0R05H650XCKG 1  
PRD_099TMNBS62W0,CON_0R05H650XCKG,1 Chapter 13 PRD_099TMNBS62W0 Midori Akino CON_0R05H650XCKG 1  
PRD_0DYN68532130,CON_0R05H650XCKG,1 Chapter 11 PRD_0DYN68532130 Midori Akino CON_0R05H650XCKG 1  
PRD_0RH9QPPYA7S0,CON_0R05H650XCKG,1 Chapter 23 PRD_0RH9QPPYA7S0 Midori Akino CON_0R05H650XCKG 1  
PRD_0Z7R19G0P6R0,CON_0R05H650XCKG,1 Chapter 21 PRD_0Z7R19G0P6R0 Midori Akino CON_0R05H650XCKG 1  
PRD_12H6B8YXYC60,CON_0R05H650XCKG,1 Chapter 1 PRD_12H6B8YXYC60 Midori Akino CON_0R05H650XCKG 1  
PRD_15HMRDJYKW6G,CON_0R05H650XCKG,1 Chapter 15 PRD_15HMRDJYKW6G Midori Akino CON_0R05H650XCKG 1  
PRD_1GF5HV75E020,CON_0R05H650XCKG,1 Chapter 9 PRD_1GF5HV75E020 Midori Akino CON_0R05H650XCKG 1  
PRD_1MXM3E1FAF10,CON_0R05H650XCKG,1 Chapter 7 PRD_1MXM3E1FAF10 Midori Akino CON_0R05H650XCKG 1  
PRD_1VJ7E12HPE00,CON_0R05H650XCKG,1 Chapter 4 PRD_1VJ7E12HPE00 Midori Akino CON_0R05H650XCKG 1  
PRD_1Y0QSNWVJD70,CON_0R05H650XCKG,1 Chapter 2 PRD_1Y0QSNWVJD70 Midori Akino CON_0R05H650XCKG 1  
PRD_21XK56XFG4EG,CON_0R05H650XCKG,1 Chapter 16 PRD_21XK56XFG4EG Midori Akino CON_0R05H650XCKG 1  
PRD_24J3GSYHW3DG,CON_0R05H650XCKG,1 Chapter 14 PRD_24J3GSYHW3DG Midori Akino CON_0R05H650XCKG 1  
PRD_2B0J2CRVR2CG,CON_0R05H650XCKG,1 Chapter 12 PRD_2B0J2CRVR2CG Midori Akino CON_0R05H650XCKG 1  
PRD_2FHDDZTY42KG,CON_0R05H650XCKG,1 Chapter 10 PRD_2FHDDZTY42KG Midori Akino CON_0R05H650XCKG 1  
PRD_2T81XC7SC79G,CON_0R05H650XCKG,1 Chapter 22 PRD_2T81XC7SC79G Midori Akino CON_0R05H650XCKG 1  
PRD_2XF0VJ35M5FG,CON_0R05H650XCKG,1 Chapter 19 PRD_2XF0VJ35M5FG Midori Akino CON_0R05H650XCKG 1  
PRD_2YYG8Z13868G,CON_0R05H650XCKG,1 Chapter 20 PRD_2YYG8Z13868G Midori Akino CON_0R05H650XCKG 1  
PRD_3J7XRJM001JG,CON_0R05H650XCKG,1 Chapter 8 PRD_3J7XRJM001JG Midori Akino CON_0R05H650XCKG 1  
PRD_3NAWNRGC8FGG,CON_0R05H650XCKG,1 Chapter 5 PRD_3NAWNRGC8FGG Midori Akino CON_0R05H650XCKG 1  
PRD_3PMCA5PAC0HG,CON_0R05H650XCKG,1 Chapter 6 PRD_3PMCA5PAC0HG Midori Akino CON_0R05H650XCKG 1  
PRD_3SVF7BDPMEQG,CON_0R05H650XCKG,1 Chapter 3 PRD_3SVF7BDPMEQG Midori Akino CON_0R05H650XCKG 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.206ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS