BookWalker

home / database

product_contributors

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

13 rows where contributor_id = "CON_0H9VH3JFVWNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_019Q161GKCTG,CON_0H9VH3JFVWNG,1 Something's Gotta Give PRD_019Q161GKCTG TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_01KYMVC4TQM0,CON_0H9VH3JFVWNG,1 Secret ingredient: Love PRD_01KYMVC4TQM0 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_029ZS30PZ340,CON_0H9VH3JFVWNG,1 The Last Marchetti Bachelor PRD_029ZS30PZ340 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_0N4710WHZ120,CON_0H9VH3JFVWNG,1 With a Little T.L.C. PRD_0N4710WHZ120 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_1CNJT6KEVRWG,CON_0H9VH3JFVWNG,1 The Sheikh's Reluctant Bride PRD_1CNJT6KEVRWG TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_1Q051JDTTQ2G,CON_0H9VH3JFVWNG,1 Winning Back His Bride PRD_1Q051JDTTQ2G TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_204JJAH6PTDG,CON_0H9VH3JFVWNG,1 Crazy About the Boss PRD_204JJAH6PTDG TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_2Y9PXY02RTS0,CON_0H9VH3JFVWNG,1 A Vow, a Ring, a Baby Swing PRD_2Y9PXY02RTS0 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_2Z9P03D9KXPG,CON_0H9VH3JFVWNG,1 Marrying the Virgin Nanny PRD_2Z9P03D9KXPG TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_33BY522D6FEG,CON_0H9VH3JFVWNG,1 The Doctor'S Secret Baby PRD_33BY522D6FEG TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_39BSTKX8G550,CON_0H9VH3JFVWNG,1 Expecting the Doctor's Baby PRD_39BSTKX8G550 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_3BZVP967HSE0,CON_0H9VH3JFVWNG,1 The Sheikh's Contract Bride PRD_3BZVP967HSE0 TERESA SOUTHWICK CON_0H9VH3JFVWNG 1  
PRD_3PJTQ6BKWXAG,CON_0H9VH3JFVWNG,1 And Then He Kissed Me PRD_3PJTQ6BKWXAG TERESA SOUTHWICK CON_0H9VH3JFVWNG 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.706ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS