BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_0N4JMBN3T7B0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04S3K8J9JQTG,CON_0N4JMBN3T7B0,1 The Bachelor PRD_04S3K8J9JQTG MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_0F0ZMK2FR6VG,CON_0N4JMBN3T7B0,1 Wanted:Husband, Will Train PRD_0F0ZMK2FR6VG MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_0H24334MRVMG,CON_0N4JMBN3T7B0,1 My Phony Valentine PRD_0H24334MRVMG MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_0NVJYRHNY6YG,CON_0N4JMBN3T7B0,1 Colton's Secret Service PRD_0NVJYRHNY6YG MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_1Q20D6MJT7E0,CON_0N4JMBN3T7B0,1 Remodeling the Bachelor PRD_1Q20D6MJT7E0 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_1ZGD28EY9F0G,CON_0N4JMBN3T7B0,1 Taming the Playboy PRD_1ZGD28EY9F0G MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_21YD2RY0DM10,CON_0N4JMBN3T7B0,1 Angus's Lost Lady PRD_21YD2RY0DM10 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_224X41VH55TG,CON_0N4JMBN3T7B0,1 Serena Mckee's Back in Town PRD_224X41VH55TG MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_28BXKNSS9V90,CON_0N4JMBN3T7B0,1 The Heart Of A Ruler PRD_28BXKNSS9V90 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_2NXM7F9YY3S0,CON_0N4JMBN3T7B0,1 The Amnesiac Bride PRD_2NXM7F9YY3S0 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_2WYGM4NG39G0,CON_0N4JMBN3T7B0,1 Suddenly... Marriage! PRD_2WYGM4NG39G0 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_3K7HRSAF4X40,CON_0N4JMBN3T7B0,1 Your Baby Or Mine? PRD_3K7HRSAF4X40 MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_3M1EJ1HQE90G,CON_0N4JMBN3T7B0,1 Fortune's Valentine Bride PRD_3M1EJ1HQE90G MARIE FERRARELLA CON_0N4JMBN3T7B0 1  
PRD_3NTHWZBFG0D0,CON_0N4JMBN3T7B0,1 A Doctor's Secret PRD_3NTHWZBFG0D0 MARIE FERRARELLA CON_0N4JMBN3T7B0 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 7.79ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS