BookWalker

home / database

product_contributors

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

66 rows where contributor_id = "CON_3FNJK0R42QAG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00EW2V3F3MG0,CON_3FNJK0R42QAG,0 Volume 9 PRD_00EW2V3F3MG0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_00ZJAZ5FWA3G,CON_3FNJK0R42QAG,0 Volume 4 PRD_00ZJAZ5FWA3G William Flanagan CON_3FNJK0R42QAG 0  
PRD_04ZFCFWHFKQ0,CON_3FNJK0R42QAG,0 Volume 7 PRD_04ZFCFWHFKQ0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_07NM76EJ018G,CON_3FNJK0R42QAG,9 Volume 2 PRD_07NM76EJ018G William Flanagan CON_3FNJK0R42QAG 9  
PRD_0CHSASFQ250G,CON_3FNJK0R42QAG,9 Volume 3 PRD_0CHSASFQ250G William Flanagan CON_3FNJK0R42QAG 9  
PRD_0CJ4M8JEB20G,CON_3FNJK0R42QAG,0 Volume 3 PRD_0CJ4M8JEB20G William Flanagan CON_3FNJK0R42QAG 0  
PRD_0G4HW4J0GR9G,CON_3FNJK0R42QAG,0 Volume 1 PRD_0G4HW4J0GR9G William Flanagan CON_3FNJK0R42QAG 0  
PRD_0GAAGGB8H8Y0,CON_3FNJK0R42QAG,0 Volume 2 PRD_0GAAGGB8H8Y0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0GMZGK5Y7G40,CON_3FNJK0R42QAG,0 Volume 6 PRD_0GMZGK5Y7G40 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0J0MXZ81XHV0,CON_3FNJK0R42QAG,0 Volume 5 PRD_0J0MXZ81XHV0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0K2KDRW0M4W0,CON_3FNJK0R42QAG,0 Volume 3 PRD_0K2KDRW0M4W0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0MV5234JXQX0,CON_3FNJK0R42QAG,0 Volume 1 PRD_0MV5234JXQX0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0N7QT54E5ZS0,CON_3FNJK0R42QAG,0 Volume 1 PRD_0N7QT54E5ZS0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0PH78JABSGT0,CON_3FNJK0R42QAG,0 Volume 3 PRD_0PH78JABSGT0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0Q5E26703ZB0,CON_3FNJK0R42QAG,0 Volume 2 PRD_0Q5E26703ZB0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0QK3ZBYAG330,CON_3FNJK0R42QAG,0 Volume 1 PRD_0QK3ZBYAG330 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0TXRVZSNQPC0,CON_3FNJK0R42QAG,0 Volume 3 PRD_0TXRVZSNQPC0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0V9MDP6MSPW0,CON_3FNJK0R42QAG,0 Volume 2 PRD_0V9MDP6MSPW0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_0YB4HPYFADJ0,CON_3FNJK0R42QAG,9 Volume 13 PRD_0YB4HPYFADJ0 William Flanagan CON_3FNJK0R42QAG 9  
PRD_11V04T0K3CAG,CON_3FNJK0R42QAG,0 Volume 1 PRD_11V04T0K3CAG William Flanagan CON_3FNJK0R42QAG 0  
PRD_149GPD2NFB9G,CON_3FNJK0R42QAG,0 Volume 1 PRD_149GPD2NFB9G William Flanagan CON_3FNJK0R42QAG 0  
PRD_18NH3P14E7JG,CON_3FNJK0R42QAG,9 Volume 1 PRD_18NH3P14E7JG William Flanagan CON_3FNJK0R42QAG 9  
PRD_18Y311WZBA8G,CON_3FNJK0R42QAG,0 Volume 2 PRD_18Y311WZBA8G William Flanagan CON_3FNJK0R42QAG 0  
PRD_1B8M14ZCHKPG,CON_3FNJK0R42QAG,0 Volume 5 PRD_1B8M14ZCHKPG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1BP9Y8HQE6EG,CON_3FNJK0R42QAG,0 Volume 8 PRD_1BP9Y8HQE6EG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1DN8G90MZ2Q0,CON_3FNJK0R42QAG,0 Volume 10 PRD_1DN8G90MZ2Q0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_1E4R9VKSA5DG,CON_3FNJK0R42QAG,0 Volume 6 PRD_1E4R9VKSA5DG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1FCJCMY1Q9FG,CON_3FNJK0R42QAG,0 Volume 5 PRD_1FCJCMY1Q9FG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1GGBGEMVH3MG,CON_3FNJK0R42QAG,0 Volume 11 PRD_1GGBGEMVH3MG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1HT80TAVT720,CON_3FNJK0R42QAG,0 Volume 4 PRD_1HT80TAVT720 William Flanagan CON_3FNJK0R42QAG 0  
PRD_1K0Q7VFGQ17G,CON_3FNJK0R42QAG,0 Volume 1 PRD_1K0Q7VFGQ17G William Flanagan CON_3FNJK0R42QAG 0  
PRD_1PVHFSX7W5JG,CON_3FNJK0R42QAG,0 Volume 10 PRD_1PVHFSX7W5JG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1T7PW1BWZF5G,CON_3FNJK0R42QAG,0 Extra Story PRD_1T7PW1BWZF5G William Flanagan CON_3FNJK0R42QAG 0  
PRD_1XAHS7797DBG,CON_3FNJK0R42QAG,0 Volume 3 PRD_1XAHS7797DBG William Flanagan CON_3FNJK0R42QAG 0  
PRD_1YM1FM56VE4G,CON_3FNJK0R42QAG,0 Volume 2 PRD_1YM1FM56VE4G William Flanagan CON_3FNJK0R42QAG 0  
PRD_254Q6RFPDJ6G,CON_3FNJK0R42QAG,0 Volume 6 PRD_254Q6RFPDJ6G William Flanagan CON_3FNJK0R42QAG 0  
PRD_26P4V5JC1K7G,CON_3FNJK0R42QAG,0 Volume 8 PRD_26P4V5JC1K7G William Flanagan CON_3FNJK0R42QAG 0  
PRD_29B27DA54N1G,CON_3FNJK0R42QAG,0 Volume 12 PRD_29B27DA54N1G William Flanagan CON_3FNJK0R42QAG 0  
PRD_2B8XAZHNHK4G,CON_3FNJK0R42QAG,0 Volume 11 PRD_2B8XAZHNHK4G William Flanagan CON_3FNJK0R42QAG 0  
PRD_2BH4GD8TXQJ0,CON_3FNJK0R42QAG,0 Volume 15 PRD_2BH4GD8TXQJ0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_2G9WP9V6VGAG,CON_3FNJK0R42QAG,0 Volume 4 PRD_2G9WP9V6VGAG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2HBV61F5J4KG,CON_3FNJK0R42QAG,0 Volume 2 PRD_2HBV61F5J4KG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2JFQYATRSHMG,CON_3FNJK0R42QAG,0 Volume 1 PRD_2JFQYATRSHMG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2JN8VED3P4CG,CON_3FNJK0R42QAG,0 Volume 4 PRD_2JN8VED3P4CG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2KX2Y7RBK8EG,CON_3FNJK0R42QAG,0 Volume 3 PRD_2KX2Y7RBK8EG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2MYF1WN97Z9G,CON_3FNJK0R42QAG,0 Volume 2 PRD_2MYF1WN97Z9G William Flanagan CON_3FNJK0R42QAG 0  
PRD_2N0DVDQQVPCG,CON_3FNJK0R42QAG,0 Volume 1 PRD_2N0DVDQQVPCG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2NJPMGP51ZTG,CON_3FNJK0R42QAG,0 Volume 3 PRD_2NJPMGP51ZTG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2PKX9TTDZQDG,CON_3FNJK0R42QAG,0 Volume 2 PRD_2PKX9TTDZQDG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2SPW60HT7PKG,CON_3FNJK0R42QAG,0 Volume 1 PRD_2SPW60HT7PKG William Flanagan CON_3FNJK0R42QAG 0  
PRD_2VYKWDT6MTCG,CON_3FNJK0R42QAG,0 Volume 3 PRD_2VYKWDT6MTCG William Flanagan CON_3FNJK0R42QAG 0  
PRD_33KSKHPE5DV0,CON_3FNJK0R42QAG,0 Volume 2 PRD_33KSKHPE5DV0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_35915Y6J07Z0,CON_3FNJK0R42QAG,0 Volume 9 PRD_35915Y6J07Z0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3608X4KG1CT0,CON_3FNJK0R42QAG,0 Volume 2 PRD_3608X4KG1CT0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_38C69GFV7G7G,CON_3FNJK0R42QAG,0 Volume 5 PRD_38C69GFV7G7G William Flanagan CON_3FNJK0R42QAG 0  
PRD_397BTAFW9AR0,CON_3FNJK0R42QAG,0 Volume 1 PRD_397BTAFW9AR0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_39HWTD9HZJ60,CON_3FNJK0R42QAG,0 Volume 4 PRD_39HWTD9HZJ60 William Flanagan CON_3FNJK0R42QAG 0  
PRD_39ZHGH0MC6Y0,CON_3FNJK0R42QAG,0 Volume 7 PRD_39ZHGH0MC6Y0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3APV8QDTDBS0,CON_3FNJK0R42QAG,0 Volume 3 PRD_3APV8QDTDBS0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3CC0242Y85X0,CON_3FNJK0R42QAG,0 Volume 5 PRD_3CC0242Y85X0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3CMJR4VVDZT0,CON_3FNJK0R42QAG,9 Volume 14 PRD_3CMJR4VVDZT0 William Flanagan CON_3FNJK0R42QAG 9  
PRD_3DNT5X96N9Z0,CON_3FNJK0R42QAG,0 Volume 4 PRD_3DNT5X96N9Z0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3JVFEJWK92G0,CON_3FNJK0R42QAG,0 Volume 2 PRD_3JVFEJWK92G0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3KK52XGYWQ70,CON_3FNJK0R42QAG,0 Volume 2 PRD_3KK52XGYWQ70 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3RCYNBT1XFN0,CON_3FNJK0R42QAG,0 Volume 3 PRD_3RCYNBT1XFN0 William Flanagan CON_3FNJK0R42QAG 0  
PRD_3WX90YMBSEM0,CON_3FNJK0R42QAG,0 Volume 1 PRD_3WX90YMBSEM0 William Flanagan CON_3FNJK0R42QAG 0  

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