BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_21DAGKDFAKKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_08QH6PTM8KB0,CON_21DAGKDFAKKG,1 Oh-So-Sensible Secretary PRD_08QH6PTM8KB0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_0E0ZGFH113Y0,CON_21DAGKDFAKKG,1 Cinderella's Wedding Wish PRD_0E0ZGFH113Y0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_0KVCCQE3Q9VG,CON_21DAGKDFAKKG,1 Baby at Bushman's Creek PRD_0KVCCQE3Q9VG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_0P9WYA85K8TG,CON_21DAGKDFAKKG,1 Ordinary Girl in a Tiara PRD_0P9WYA85K8TG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_0TDT9TBT9FKG,CON_21DAGKDFAKKG,1 Temporary Engagement PRD_0TDT9TBT9FKG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_0YVFBCT5R1FG,CON_21DAGKDFAKKG,1 A Bride for Barra Creek PRD_0YVFBCT5R1FG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_107N8SGSD2BG,CON_21DAGKDFAKKG,1 Juggling Briefcase & Baby PRD_107N8SGSD2BG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_10A2SJJBZK1G,CON_21DAGKDFAKKG,1 Oasis of the Heart PRD_10A2SJJBZK1G Jessica Hart CON_21DAGKDFAKKG 1  
PRD_17GKVJF65JYG,CON_21DAGKDFAKKG,1 Appointment at the Altar PRD_17GKVJF65JYG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_1F07Y42N5YXG,CON_21DAGKDFAKKG,1 Assignment: Baby PRD_1F07Y42N5YXG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_1P2MM475QQB0,CON_21DAGKDFAKKG,1 Christmas Eve Marriage PRD_1P2MM475QQB0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_1XV8SKQAM1YG,CON_21DAGKDFAKKG,1 Her Boss's Baby Plan PRD_1XV8SKQAM1YG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_249HHE3YJGQG,CON_21DAGKDFAKKG,1 Marriage Reunited PRD_249HHE3YJGQG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_29TYBHQRX5XG,CON_21DAGKDFAKKG,1 Newlyweds Of Convenience PRD_29TYBHQRX5XG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_2DEZ2JZGC4M0,CON_21DAGKDFAKKG,1 A Whirlwind Engagement PRD_2DEZ2JZGC4M0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_2RX17TMSP9Q0,CON_21DAGKDFAKKG,1 Business Arrangement Bride PRD_2RX17TMSP9Q0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_2TK3BHVG2X8G,CON_21DAGKDFAKKG,1 A Sensible Wife PRD_2TK3BHVG2X8G Jessica Hart CON_21DAGKDFAKKG 1  
PRD_2VTEYQQNPW90,CON_21DAGKDFAKKG,1 Hitched! PRD_2VTEYQQNPW90 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_35STCWYB3HE0,CON_21DAGKDFAKKG,1 Outback Boss, City Bride PRD_35STCWYB3HE0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_3HGY7EMD2A1G,CON_21DAGKDFAKKG,1 Contracted: Corporate Wife PRD_3HGY7EMD2A1G Jessica Hart CON_21DAGKDFAKKG 1  
PRD_3HX30HP28JFG,CON_21DAGKDFAKKG,1 Partner for Love PRD_3HX30HP28JFG Jessica Hart CON_21DAGKDFAKKG 1  
PRD_3KYPH7H1GFQ0,CON_21DAGKDFAKKG,1 Married for a Month PRD_3KYPH7H1GFQ0 Jessica Hart CON_21DAGKDFAKKG 1  
PRD_3MVPQTJ6QW2G,CON_21DAGKDFAKKG,1 Fiancé Wanted Fast! PRD_3MVPQTJ6QW2G Jessica Hart CON_21DAGKDFAKKG 1  
PRD_3QZ7H3JDN8C0,CON_21DAGKDFAKKG,1 Honeymoon with the Boss PRD_3QZ7H3JDN8C0 Jessica Hart CON_21DAGKDFAKKG 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 12.119ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS