BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_04N3YZXJWWSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02T0S6345CJ0,CON_04N3YZXJWWSG,1 A Masterful Man PRD_02T0S6345CJ0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_0RS0GFNRPV90,CON_04N3YZXJWWSG,1 The Unconventional Bride PRD_0RS0GFNRPV90 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_0TRBPHD7Z750,CON_04N3YZXJWWSG,1 One-Night Pregnancy PRD_0TRBPHD7Z750 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_14PMH3GMX48G,CON_04N3YZXJWWSG,1 An Unusual Affair PRD_14PMH3GMX48G LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_1GCREY85BTY0,CON_04N3YZXJWWSG,1 Dangerous Deceiver PRD_1GCREY85BTY0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_2DS5N1QDJWPG,CON_04N3YZXJWWSG,1 Married for Real PRD_2DS5N1QDJWPG LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_2W2JCES9GM00,CON_04N3YZXJWWSG,1 The Rich Man's Virgin PRD_2W2JCES9GM00 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_333MP94HJJ00,CON_04N3YZXJWWSG,1 The Billionaire Boss's Innocent Bride PRD_333MP94HJJ00 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3C0F9WSCZFR0,CON_04N3YZXJWWSG,1 A Question of Marriage PRD_3C0F9WSCZFR0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3KWA5KE9GYBG,CON_04N3YZXJWWSG,1 An Exception to His Rule PRD_3KWA5KE9GYBG LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3M725DEZESN0,CON_04N3YZXJWWSG,1 When Only Diamonds Will Do PRD_3M725DEZESN0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3Q9CCJ7APHZ0,CON_04N3YZXJWWSG,1 The Return of Her Past PRD_3Q9CCJ7APHZ0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3X8QKEQ2T84G,CON_04N3YZXJWWSG,1 The Girl He Never Noticed PRD_3X8QKEQ2T84G LINDSAY ARMSTRONG CON_04N3YZXJWWSG 1  
PRD_3XGS27CYE6K0,CON_04N3YZXJWWSG,1 He'S My Husband! PRD_3XGS27CYE6K0 LINDSAY ARMSTRONG CON_04N3YZXJWWSG 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.692ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS