BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_1H66SGNQJ4W0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04W8DBFPGQ60,CON_1H66SGNQJ4W0,2 Chapter 28 PRD_04W8DBFPGQ60 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0A0QNP2WZB1G,CON_1H66SGNQJ4W0,2 Chapter 29 PRD_0A0QNP2WZB1G Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0GM80NKXDHX0,CON_1H66SGNQJ4W0,2 Chapter 17 PRD_0GM80NKXDHX0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0KHBAC09VXFG,CON_1H66SGNQJ4W0,2 Chapter 31 PRD_0KHBAC09VXFG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0PJYCS2THRTG,CON_1H66SGNQJ4W0,2 Chapter 26 PRD_0PJYCS2THRTG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0VK790PDH850,CON_1H66SGNQJ4W0,2 Chapter 9 PRD_0VK790PDH850 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0W2KDTAS56PG,CON_1H66SGNQJ4W0,2 Chapter 30 PRD_0W2KDTAS56PG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0XF825CPPKCG,CON_1H66SGNQJ4W0,2 Chapter 16 PRD_0XF825CPPKCG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0XRHWG172BQ0,CON_1H66SGNQJ4W0,2 Chapter 27 PRD_0XRHWG172BQ0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_0Z8B2RGMDX1G,CON_1H66SGNQJ4W0,2 Chapter 35 PRD_0Z8B2RGMDX1G Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_10XT8BMSTD50,CON_1H66SGNQJ4W0,2 Chapter 1 PRD_10XT8BMSTD50 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_17JAVYPW6C40,CON_1H66SGNQJ4W0,2 Chapter 8 PRD_17JAVYPW6C40 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_189FR4ZZSHR0,CON_1H66SGNQJ4W0,2 Chapter 38 PRD_189FR4ZZSHR0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_18C2D5243R0G,CON_1H66SGNQJ4W0,2 Chapter 11 PRD_18C2D5243R0G Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_1N85PE0A5XDG,CON_1H66SGNQJ4W0,2 Chapter 13 PRD_1N85PE0A5XDG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_1WFBYRTQYE60,CON_1H66SGNQJ4W0,2 Chapter 5 PRD_1WFBYRTQYE60 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_1WXPANANJF4G,CON_1H66SGNQJ4W0,2 Chapter 15 PRD_1WXPANANJF4G Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_20FHV503NT20,CON_1H66SGNQJ4W0,2 Chapter 19 PRD_20FHV503NT20 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_20WQ39AWEGDG,CON_1H66SGNQJ4W0,2 Chapter 18 PRD_20WQ39AWEGDG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_233HTF99PBN0,CON_1H66SGNQJ4W0,2 Chapter 37 PRD_233HTF99PBN0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_23AZBHR03QR0,CON_1H66SGNQJ4W0,2 Chapter 36 PRD_23AZBHR03QR0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_24P8EPB3YFRG,CON_1H66SGNQJ4W0,2 Chapter 20 PRD_24P8EPB3YFRG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_2FZ9Q4818EEG,CON_1H66SGNQJ4W0,2 Chapter 10 PRD_2FZ9Q4818EEG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_2M3NYSX6MSHG,CON_1H66SGNQJ4W0,2 Chapter 14 PRD_2M3NYSX6MSHG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_2T7CGW84MQX0,CON_1H66SGNQJ4W0,2 Chapter 24 PRD_2T7CGW84MQX0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_2VVP7CRT7MGG,CON_1H66SGNQJ4W0,2 Chapter 12 PRD_2VVP7CRT7MGG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_31522M7YRDMG,CON_1H66SGNQJ4W0,2 Chapter 6 PRD_31522M7YRDMG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_32MKQ15MWENG,CON_1H66SGNQJ4W0,2 Chapter 7 PRD_32MKQ15MWENG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_32TDXC73S470,CON_1H66SGNQJ4W0,2 Chapter 32 PRD_32TDXC73S470 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_35WCDP1MR3X0,CON_1H66SGNQJ4W0,2 Chapter 23 PRD_35WCDP1MR3X0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3B0BM2M377RG,CON_1H66SGNQJ4W0,2 Chapter 25 PRD_3B0BM2M377RG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3NPN583YS2X0,CON_1H66SGNQJ4W0,2 Chapter 34 PRD_3NPN583YS2X0 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3Q30F8C681GG,CON_1H66SGNQJ4W0,2 Chapter 3 PRD_3Q30F8C681GG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3QP48TFFJ000,CON_1H66SGNQJ4W0,2 Chapter 22 PRD_3QP48TFFJ000 Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3S0ZX3XXXREG,CON_1H66SGNQJ4W0,2 Chapter 21 PRD_3S0ZX3XXXREG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3VHGTVE8M0QG,CON_1H66SGNQJ4W0,2 Chapter 2 PRD_3VHGTVE8M0QG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3Y634EBJGFPG,CON_1H66SGNQJ4W0,2 Chapter 4 PRD_3Y634EBJGFPG Tasuke Sakura CON_1H66SGNQJ4W0 2  
PRD_3Z94KK8Q0MC0,CON_1H66SGNQJ4W0,2 Chapter 33 PRD_3Z94KK8Q0MC0 Tasuke Sakura CON_1H66SGNQJ4W0 2  

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.325ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS