BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_2BD548GFGHK0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01ATS6Y5CYN0,CON_2BD548GFGHK0,1 Winter Roses PRD_01ATS6Y5CYN0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_036WNZM5RXQ0,CON_2BD548GFGHK0,1 Night of Love PRD_036WNZM5RXQ0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_04BMQGS5KJY0,CON_2BD548GFGHK0,1 Blind Promises PRD_04BMQGS5KJY0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0BDQH74VZ5E0,CON_2BD548GFGHK0,1 Man Of Ice PRD_0BDQH74VZ5E0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0DJXGXYHFH20,CON_2BD548GFGHK0,1 Will of Steel PRD_0DJXGXYHFH20 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0PXFEFNHJWBG,CON_2BD548GFGHK0,1 Nelson's Brand PRD_0PXFEFNHJWBG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0TP8478DWC5G,CON_2BD548GFGHK0,1 Lady Love PRD_0TP8478DWC5G DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0WEVJJH67ZMG,CON_2BD548GFGHK0,1 Passion Flower PRD_0WEVJJH67ZMG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_0YAM40A4BEMG,CON_2BD548GFGHK0,1 Volume 2 PRD_0YAM40A4BEMG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_1020K4YAGPN0,CON_2BD548GFGHK0,1 Rawhide and Lace PRD_1020K4YAGPN0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_123F4JESS15G,CON_2BD548GFGHK0,1 September Morning PRD_123F4JESS15G DIANA PALMER CON_2BD548GFGHK0 1  
PRD_14GKYQRCWNM0,CON_2BD548GFGHK0,1 Heart of Stone PRD_14GKYQRCWNM0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_1C22EXPVW16G,CON_2BD548GFGHK0,1 Calhoun PRD_1C22EXPVW16G DIANA PALMER CON_2BD548GFGHK0 1  
PRD_1GJRA3VCMCB0,CON_2BD548GFGHK0,1 Evan PRD_1GJRA3VCMCB0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_1PZT9ZJKP680,CON_2BD548GFGHK0,1 Diamond In The Rough PRD_1PZT9ZJKP680 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_1X3F0EXKEE80,CON_2BD548GFGHK0,1 Loveplay PRD_1X3F0EXKEE80 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_22DWFE3QYHJ0,CON_2BD548GFGHK0,1 Fire and Ice PRD_22DWFE3QYHJ0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_245PW98KWQX0,CON_2BD548GFGHK0,1 The Wedding in White PRD_245PW98KWQX0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2A54GQH0Y750,CON_2BD548GFGHK0,1 Diamond Girl PRD_2A54GQH0Y750 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2JEK1XHPQGK0,CON_2BD548GFGHK0,1 Justin PRD_2JEK1XHPQGK0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2JN3EMV3X84G,CON_2BD548GFGHK0,1 Love by Proxy PRD_2JN3EMV3X84G DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2N39Y0KD9NB0,CON_2BD548GFGHK0,1 The Patient Nurse PRD_2N39Y0KD9NB0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2SJ4N7MFN5NG,CON_2BD548GFGHK0,1 Unlikely Lover PRD_2SJ4N7MFN5NG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2SMHSCE24500,CON_2BD548GFGHK0,1 The Maverick PRD_2SMHSCE24500 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_2V6YEJA9Q8R0,CON_2BD548GFGHK0,1 The Princess Bride PRD_2V6YEJA9Q8R0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_37NW8NMBZG80,CON_2BD548GFGHK0,1 Matt Caldwell: Texas Tycoon PRD_37NW8NMBZG80 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_39HHJNQJKZDG,CON_2BD548GFGHK0,1 His Girl Friday PRD_39HHJNQJKZDG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3ASVQ0AHTMBG,CON_2BD548GFGHK0,1 Heart of Stone PRD_3ASVQ0AHTMBG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3BSVT5QRNQ10,CON_2BD548GFGHK0,1 Redbird PRD_3BSVT5QRNQ10 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3C0BJMJKV2GG,CON_2BD548GFGHK0,1 Volume 1 PRD_3C0BJMJKV2GG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3E9SSWRYQAFG,CON_2BD548GFGHK0,1 Heartbreaker PRD_3E9SSWRYQAFG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3J2FRZ6HHER0,CON_2BD548GFGHK0,1 Luke PRD_3J2FRZ6HHER0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3NTS5AC9RGF0,CON_2BD548GFGHK0,1 Callaghan'S Bride PRD_3NTS5AC9RGF0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3SCKGQD98FT0,CON_2BD548GFGHK0,1 Darling Enemy PRD_3SCKGQD98FT0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3SV3WEPPHRKG,CON_2BD548GFGHK0,1 Dream's End PRD_3SV3WEPPHRKG DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3WRWWSXHPD9G,CON_2BD548GFGHK0,1 Iron Cowboy PRD_3WRWWSXHPD9G DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3XX22AEKMES0,CON_2BD548GFGHK0,1 The Rawhide Man PRD_3XX22AEKMES0 DIANA PALMER CON_2BD548GFGHK0 1  
PRD_3YADZFSWW4XG,CON_2BD548GFGHK0,1 Love On Trial PRD_3YADZFSWW4XG DIANA PALMER CON_2BD548GFGHK0 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 10.263ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS