product_contributors

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

14 rows where contributor_id = "CON_1HRDCC8TJ050"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_062RQWPJRK60,CON_1HRDCC8TJ050,2 The Unexpected Holiday Gift PRD_062RQWPJRK60 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_0GMKFVKYVYKG,CON_1HRDCC8TJ050,2 The Greek's Long-Lost Son PRD_0GMKFVKYVYKG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_0HR5FNPMFDZG,CON_1HRDCC8TJ050,2 Relentless Seduction PRD_0HR5FNPMFDZG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_160RE1638AS0,CON_1HRDCC8TJ050,2 Holiday With The Millionaire PRD_160RE1638AS0 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_1NCAMJCNJ5F0,CON_1HRDCC8TJ050,2 A Baby To Save Their Marriage PRD_1NCAMJCNJ5F0 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_1YH9YVBM8XEG,CON_1HRDCC8TJ050,2 What the Prince Wants PRD_1YH9YVBM8XEG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_249HHE3YJGQG,CON_1HRDCC8TJ050,2 Marriage Reunited PRD_249HHE3YJGQG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_2DS5N1QDJWPG,CON_1HRDCC8TJ050,2 Married for Real PRD_2DS5N1QDJWPG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_2Q4JCCCEGC6G,CON_1HRDCC8TJ050,2 Bride by Friday PRD_2Q4JCCCEGC6G HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_2XHAK24S4XXG,CON_1HRDCC8TJ050,2 The Return Of The Rebel PRD_2XHAK24S4XXG HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_391BY6WNCRK0,CON_1HRDCC8TJ050,2 Shock: One-Night Heir PRD_391BY6WNCRK0 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_3EDVE1K9DK20,CON_1HRDCC8TJ050,2 Pregnant by the Greek Tycoon PRD_3EDVE1K9DK20 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_3KSSXJ6YA060,CON_1HRDCC8TJ050,2 A Bride for Glenmore PRD_3KSSXJ6YA060 HARUHI SAKURA CON_1HRDCC8TJ050 2  
PRD_3TGBD2RXCPJG,CON_1HRDCC8TJ050,2 Without Love PRD_3TGBD2RXCPJG HARUHI SAKURA CON_1HRDCC8TJ050 2  

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);