BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_02G7BH75PE3G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_023SZX9KY6WG,CON_02G7BH75PE3G,1 Volume 19 PRD_023SZX9KY6WG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_06DZ1F0AQQY0,CON_02G7BH75PE3G,1 Volume 22 PRD_06DZ1F0AQQY0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_0HSZ5HPV1TRG,CON_02G7BH75PE3G,1 Volume 6 PRD_0HSZ5HPV1TRG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_0RRDTPAM3AS0,CON_02G7BH75PE3G,1 Volume 4 PRD_0RRDTPAM3AS0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_11EASVCXKY50,CON_02G7BH75PE3G,1 Volume 16 PRD_11EASVCXKY50 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_12N967B8110G,CON_02G7BH75PE3G,1 Volume 21 PRD_12N967B8110G Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_12STE8JVQZ60,CON_02G7BH75PE3G,1 Volume 23 PRD_12STE8JVQZ60 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_15Z5BEE7ZX40,CON_02G7BH75PE3G,1 Volume 17 PRD_15Z5BEE7ZX40 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_18DNP189VWB0,CON_02G7BH75PE3G,1 Volume 12 PRD_18DNP189VWB0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_1F241MAC7VA0,CON_02G7BH75PE3G,1 Volume 10 PRD_1F241MAC7VA0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_1YBBWNGHBG70,CON_02G7BH75PE3G,1 Volume 25 PRD_1YBBWNGHBG70 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_204Q86H59QEG,CON_02G7BH75PE3G,1 Volume 15 PRD_204Q86H59QEG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_20B1G7RGW5C0,CON_02G7BH75PE3G,1 Volume 20 PRD_20B1G7RGW5C0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2KGMK77P3T90,CON_02G7BH75PE3G,1 Volume 8 PRD_2KGMK77P3T90 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2P17YT1RFS80,CON_02G7BH75PE3G,1 Volume 7 PRD_2P17YT1RFS80 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2S1NK0NS198G,CON_02G7BH75PE3G,1 Volume 26 PRD_2S1NK0NS198G Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2S46V1X4M7E0,CON_02G7BH75PE3G,1 Volume 2 PRD_2S46V1X4M7E0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2TK50DVQ5A9G,CON_02G7BH75PE3G,1 Volume 5 PRD_2TK50DVQ5A9G Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2XP4YKQ3D8FG,CON_02G7BH75PE3G,1 Volume 24 PRD_2XP4YKQ3D8FG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_2XTH6MZEG6D0,CON_02G7BH75PE3G,1 Volume 1 PRD_2XTH6MZEG6D0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_37QJJ5Z2HYMG,CON_02G7BH75PE3G,1 Volume 18 PRD_37QJJ5Z2HYMG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3A1GNQHSQFP0,CON_02G7BH75PE3G,1 Volume 14 PRD_3A1GNQHSQFP0 Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3A4DXRS4XXVG,CON_02G7BH75PE3G,1 Volume 13 PRD_3A4DXRS4XXVG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3DBCTYMH5VSG,CON_02G7BH75PE3G,1 Volume 9 PRD_3DBCTYMH5VSG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3ETWFBVESWTG,CON_02G7BH75PE3G,1 Volume 11 PRD_3ETWFBVESWTG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3NDGRR4A1JGG,CON_02G7BH75PE3G,1 Volume 28 PRD_3NDGRR4A1JGG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3R23AB6CDHQG,CON_02G7BH75PE3G,1 Volume 27 PRD_3R23AB6CDHQG Katsura Hoshino CON_02G7BH75PE3G 1  
PRD_3WC1DYRB32H0,CON_02G7BH75PE3G,1 Volume 3 PRD_3WC1DYRB32H0 Katsura Hoshino CON_02G7BH75PE3G 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 7.957ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS