BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_2FGKSJR0GRA0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0CWDCKTWN8P0,CON_2FGKSJR0GRA0,1 Call Back Yesterday PRD_0CWDCKTWN8P0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_0FZNMTYJMPFG,CON_2FGKSJR0GRA0,1 Spellbinding PRD_0FZNMTYJMPFG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_0GVDQWVAECH0,CON_2FGKSJR0GRA0,1 Dark Master PRD_0GVDQWVAECH0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_0JWXE0EAN550,CON_2FGKSJR0GRA0,1 Twist of Fate PRD_0JWXE0EAN550 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_0N62EK49YHDG,CON_2FGKSJR0GRA0,1 The Seduction Business PRD_0N62EK49YHDG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_15SFT6HRWHPG,CON_2FGKSJR0GRA0,1 Betrayal PRD_15SFT6HRWHPG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_18TAT8FFAB7G,CON_2FGKSJR0GRA0,1 A Wild Affair PRD_18TAT8FFAB7G CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_19DK3AMHG27G,CON_2FGKSJR0GRA0,1 Sweet Compulsion PRD_19DK3AMHG27G CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1BTJRE72VR40,CON_2FGKSJR0GRA0,1 Seduction PRD_1BTJRE72VR40 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1D1GTBX931Y0,CON_2FGKSJR0GRA0,1 Disturbing Stranger PRD_1D1GTBX931Y0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1JJXV1BR6MZG,CON_2FGKSJR0GRA0,1 Desert Barbarian PRD_1JJXV1BR6MZG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1K08Y3NHBEF0,CON_2FGKSJR0GRA0,1 Master of Comus PRD_1K08Y3NHBEF0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1PV91YB038AG,CON_2FGKSJR0GRA0,1 Duel of Desire PRD_1PV91YB038AG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1QD9BPRAJ1XG,CON_2FGKSJR0GRA0,1 Forbidden Fruit PRD_1QD9BPRAJ1XG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_1TPGHSMNBPWG,CON_2FGKSJR0GRA0,1 Hot Surrender PRD_1TPGHSMNBPWG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_22NKC5XHHV60,CON_2FGKSJR0GRA0,1 Body and Soul PRD_22NKC5XHHV60 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_26CHX98NVVMG,CON_2FGKSJR0GRA0,1 Love In The Dark PRD_26CHX98NVVMG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_2M155XTCPJ00,CON_2FGKSJR0GRA0,1 The Girl From Nowhere PRD_2M155XTCPJ00 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_2V0TT6D1PRBG,CON_2FGKSJR0GRA0,1 The Long Surrender PRD_2V0TT6D1PRBG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_2WM7GY3XG85G,CON_2FGKSJR0GRA0,1 Dreaming PRD_2WM7GY3XG85G CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_2X8A8NWTB160,CON_2FGKSJR0GRA0,1 Abduction PRD_2X8A8NWTB160 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_2XS9GR6V7RHG,CON_2FGKSJR0GRA0,1 Whirlwind PRD_2XS9GR6V7RHG CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_3JD8DQGADNQ0,CON_2FGKSJR0GRA0,1 The Silken Trap PRD_3JD8DQGADNQ0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_3S21E99SXQJ0,CON_2FGKSJR0GRA0,1 An Excellent Wife? PRD_3S21E99SXQJ0 CHARLOTTE LAMB CON_2FGKSJR0GRA0 1  
PRD_3YX2HW4QBN8G,CON_2FGKSJR0GRA0,1 Out of Control PRD_3YX2HW4QBN8G CHARLOTTE LAMB CON_2FGKSJR0GRA0 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 8.636ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS