product_contributors

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

13 rows where contributor_id = "CON_28PQG3S9K7P0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0DE38WQ5S3WG,CON_28PQG3S9K7P0,2 Marriage Material PRD_0DE38WQ5S3WG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_0R3PQ06TMWRG,CON_28PQG3S9K7P0,2 Highly Compromised Position PRD_0R3PQ06TMWRG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_0WFK6609DX5G,CON_28PQG3S9K7P0,2 Black-Tie Seduction PRD_0WFK6609DX5G Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_15H8PGQYXP2G,CON_28PQG3S9K7P0,2 Claiming King's Baby PRD_15H8PGQYXP2G Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_1FQJVXQS4KT0,CON_28PQG3S9K7P0,2 Less-Than-innocent invitation PRD_1FQJVXQS4KT0 Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_1KXZKX1ZDXC0,CON_28PQG3S9K7P0,2 Silent Desires PRD_1KXZKX1ZDXC0 Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_2CV0ZGDYV94G,CON_28PQG3S9K7P0,2 Salzano's Captive Bride PRD_2CV0ZGDYV94G Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_2HM4RAQVFGHG,CON_28PQG3S9K7P0,2 Romano'S Revenge PRD_2HM4RAQVFGHG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_2TXMBMT596PG,CON_28PQG3S9K7P0,2 Round-the-Clock Temptation PRD_2TXMBMT596PG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_37QRM9Z3Z1VG,CON_28PQG3S9K7P0,2 Conquering King's Heart PRD_37QRM9Z3Z1VG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_3HD5C2Z55TD0,CON_28PQG3S9K7P0,2 The Italian's One-Night Love-Child PRD_3HD5C2Z55TD0 Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_3QY3MP9B3QAG,CON_28PQG3S9K7P0,2 Wedding at King's Convenience PRD_3QY3MP9B3QAG Banana Sarusuberi CON_28PQG3S9K7P0 2  
PRD_3YG5GHG6ZY60,CON_28PQG3S9K7P0,2 A Most Shocking Revelation PRD_3YG5GHG6ZY60 Banana Sarusuberi CON_28PQG3S9K7P0 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);