BookWalker

home / database

product_contributors

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

14 rows where contributor_id = "CON_1G3BW5796KQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_05A8VXWFG4G0,CON_1G3BW5796KQ0,1 Familiar Stranger PRD_05A8VXWFG4G0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_07HFBD70R990,CON_1G3BW5796KQ0,1 A Place to Call Home PRD_07HFBD70R990 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_09RV6GSHW3Q0,CON_1G3BW5796KQ0,1 Shades of a Desperado PRD_09RV6GSHW3Q0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_0EGW3K7WFBYG,CON_1G3BW5796KQ0,1 Ryder's Wife PRD_0EGW3K7WFBYG SHARON SALA CON_1G3BW5796KQ0 1  
PRD_13XBG6HHRJH0,CON_1G3BW5796KQ0,1 A Place to Call Home PRD_13XBG6HHRJH0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_16XPACJD1DT0,CON_1G3BW5796KQ0,1 Amber by Night PRD_16XPACJD1DT0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_17QC3KPH80W0,CON_1G3BW5796KQ0,1 Penance PRD_17QC3KPH80W0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_1BEDCRXNJ0JG,CON_1G3BW5796KQ0,1 When You Call My Name PRD_1BEDCRXNJ0JG SHARON SALA CON_1G3BW5796KQ0 1  
PRD_2FKZAHQPHH60,CON_1G3BW5796KQ0,1 Honor's Promise PRD_2FKZAHQPHH60 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_3780W64SZQK0,CON_1G3BW5796KQ0,1 Annie and the Outlaw PRD_3780W64SZQK0 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_3CR811J451EG,CON_1G3BW5796KQ0,1 Royal's Child PRD_3CR811J451EG SHARON SALA CON_1G3BW5796KQ0 1  
PRD_3EYCE4DYKV80,CON_1G3BW5796KQ0,1 Sudden Danger PRD_3EYCE4DYKV80 SHARON SALA CON_1G3BW5796KQ0 1  
PRD_3NPCX94YJ29G,CON_1G3BW5796KQ0,1 The Miracle Man PRD_3NPCX94YJ29G SHARON SALA CON_1G3BW5796KQ0 1  
PRD_3Y36FDE62RTG,CON_1G3BW5796KQ0,1 The Fiercest Heart PRD_3Y36FDE62RTG SHARON SALA CON_1G3BW5796KQ0 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.088ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS