product_contributors

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

22 rows where contributor_id = "CON_2PJYGAWY7H4G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0179F4AZMY2G,CON_2PJYGAWY7H4G,2 The Runaway Princess PRD_0179F4AZMY2G YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_01PBWWQG15SG,CON_2PJYGAWY7H4G,2 Inherited: One Child PRD_01PBWWQG15SG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_04ZV0XXCRNBG,CON_2PJYGAWY7H4G,2 The Sheikh's Last Gamble PRD_04ZV0XXCRNBG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_0P9WYA85K8TG,CON_2PJYGAWY7H4G,2 Ordinary Girl in a Tiara PRD_0P9WYA85K8TG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_0S2AVD5WNEJG,CON_2PJYGAWY7H4G,2 The Groom's Daughter PRD_0S2AVD5WNEJG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_0T8GC5HBWJX0,CON_2PJYGAWY7H4G,2 Captive of Kadar PRD_0T8GC5HBWJX0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_16AVZBBNB5RG,CON_2PJYGAWY7H4G,2 Duty and the Beast PRD_16AVZBBNB5RG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_1D8YACC7WD10,CON_2PJYGAWY7H4G,2 The Italian Boss's Secret Child PRD_1D8YACC7WD10 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_1DA6PRXWPFG0,CON_2PJYGAWY7H4G,2 Bedded By Arrangement PRD_1DA6PRXWPFG0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_1P3C9SP8XPM0,CON_2PJYGAWY7H4G,2 Secrets of the Tycoon's Bride PRD_1P3C9SP8XPM0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_1VPNK5FX6P1G,CON_2PJYGAWY7H4G,2 Hot off the Press PRD_1VPNK5FX6P1G YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_1X10MTTVEYWG,CON_2PJYGAWY7H4G,2 The Ceo'S Nanny Affair PRD_1X10MTTVEYWG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_25X05RSHD7Y0,CON_2PJYGAWY7H4G,2 The Hawk and the Lamb PRD_25X05RSHD7Y0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_2EFVQV3RXWF0,CON_2PJYGAWY7H4G,2 The Return of the Stranger PRD_2EFVQV3RXWF0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_2NGF64NE2CPG,CON_2PJYGAWY7H4G,2 Taming Her Billionaire Boss PRD_2NGF64NE2CPG YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_2T4KYTPAX5Q0,CON_2PJYGAWY7H4G,2 Tycoon's Temptation PRD_2T4KYTPAX5Q0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_2VHR2AQ23ZQ0,CON_2PJYGAWY7H4G,2 Knight of Passion / Something Borrowed, Something Blue PRD_2VHR2AQ23ZQ0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_2VTEYQQNPW90,CON_2PJYGAWY7H4G,2 Hitched! PRD_2VTEYQQNPW90 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_32M321KVNNZ0,CON_2PJYGAWY7H4G,2 The Sheikh Doctor's Bride PRD_32M321KVNNZ0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_33HPX5MPSTQ0,CON_2PJYGAWY7H4G,2 Brazen & Burning PRD_33HPX5MPSTQ0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_33RWD64DK6T0,CON_2PJYGAWY7H4G,2 Under The Millionaire'S Influence PRD_33RWD64DK6T0 YUKI SHIOMIYA CON_2PJYGAWY7H4G 2  
PRD_3A25BFRJM20G,CON_2PJYGAWY7H4G,2 Valenti's One-Month Mistress PRD_3A25BFRJM20G YUKI SHIOMIYA CON_2PJYGAWY7H4G 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);