product_contributors

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

14 rows where contributor_id = "CON_2Y000E6ZBYH0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00KYHP3Y3MYG,CON_2Y000E6ZBYH0,1 Seize the Moment PRD_00KYHP3Y3MYG ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_075KRZQPRFC0,CON_2Y000E6ZBYH0,1 Terms of Engagement PRD_075KRZQPRFC0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_11EG3ZCYH140,CON_2Y000E6ZBYH0,1 His for the Taking PRD_11EG3ZCYH140 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_161H3PH6Y8A0,CON_2Y000E6ZBYH0,1 Ultimatum: Marriage PRD_161H3PH6Y8A0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_17F9YXMQ9580,CON_2Y000E6ZBYH0,1 The Bride Hunter PRD_17F9YXMQ9580 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_2200W0G5YQN0,CON_2Y000E6ZBYH0,1 The Wrong Man PRD_2200W0G5YQN0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_23F37QQTF8Q0,CON_2Y000E6ZBYH0,1 Mistress For A Month PRD_23F37QQTF8Q0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_30E465V5KEQ0,CON_2Y000E6ZBYH0,1 Nobody's Child PRD_30E465V5KEQ0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3A9XWHKMQW90,CON_2Y000E6ZBYH0,1 Marriage at the Cowboy's Command PRD_3A9XWHKMQW90 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3JPJ9CAS615G,CON_2Y000E6ZBYH0,1 Sold Into Marriage PRD_3JPJ9CAS615G ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3MGB7R3FTGZG,CON_2Y000E6ZBYH0,1 A Scandal So Sweet PRD_3MGB7R3FTGZG ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3S3649XZ85X0,CON_2Y000E6ZBYH0,1 The Throw-Away Bride PRD_3S3649XZ85X0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3V299BN6G1S0,CON_2Y000E6ZBYH0,1 Love Me True PRD_3V299BN6G1S0 ANN MAJOR CON_2Y000E6ZBYH0 1  
PRD_3W7Z6F167EBG,CON_2Y000E6ZBYH0,1 The Amalfi Bride PRD_3W7Z6F167EBG ANN MAJOR CON_2Y000E6ZBYH0 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);