BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_1BKNS6ZDNTHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0207X6RVVV8G,CON_1BKNS6ZDNTHG,2 The Cozakis Bride PRD_0207X6RVVV8G Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_036WNZM5RXQ0,CON_1BKNS6ZDNTHG,2 Night of Love PRD_036WNZM5RXQ0 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_055YF07B9RZG,CON_1BKNS6ZDNTHG,2 The Secret Millionaire PRD_055YF07B9RZG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_05BCG90J25SG,CON_1BKNS6ZDNTHG,2 Georgia and the Tycoon PRD_05BCG90J25SG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_06QFWD51DSRG,CON_1BKNS6ZDNTHG,2 The Man, the Ring, the Wedding PRD_06QFWD51DSRG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_0DHSKSQX2NJG,CON_1BKNS6ZDNTHG,2 Desert Warrior PRD_0DHSKSQX2NJG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_0GERQSRMR3B0,CON_1BKNS6ZDNTHG,2 Secret Baby, Public affair PRD_0GERQSRMR3B0 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_0GPTW7CP71QG,CON_1BKNS6ZDNTHG,2 Coming Home PRD_0GPTW7CP71QG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_0VGMM0WCPZEG,CON_1BKNS6ZDNTHG,2 Convenient Marriage, inconvenient Husband PRD_0VGMM0WCPZEG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_13SSJ6T17N0G,CON_1BKNS6ZDNTHG,2 Mistress of Convenience PRD_13SSJ6T17N0G Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_1EDNWA1ZDJY0,CON_1BKNS6ZDNTHG,1 Volume 2 PRD_1EDNWA1ZDJY0 Harumo Sanazaki CON_1BKNS6ZDNTHG 1  
PRD_1ZB90KRYVP1G,CON_1BKNS6ZDNTHG,2 No Honourable Compromise PRD_1ZB90KRYVP1G Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_26B1ZGP61V70,CON_1BKNS6ZDNTHG,1 Volume 1 PRD_26B1ZGP61V70 Harumo Sanazaki CON_1BKNS6ZDNTHG 1  
PRD_2PBK3B6CGA10,CON_1BKNS6ZDNTHG,2 The Greek Billionaire'S Innocent Princess PRD_2PBK3B6CGA10 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_2XRZ4W9PXWS0,CON_1BKNS6ZDNTHG,2 The Vengeful Husband PRD_2XRZ4W9PXWS0 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_36S616XKHA10,CON_1BKNS6ZDNTHG,2 Undying Love PRD_36S616XKHA10 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3BNEJ4CDES3G,CON_1BKNS6ZDNTHG,2 Her Surprise Family PRD_3BNEJ4CDES3G Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3H1RVFWVJ630,CON_1BKNS6ZDNTHG,2 Married to a Mistress PRD_3H1RVFWVJ630 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3KMQ0XCFHMQG,CON_1BKNS6ZDNTHG,2 Billionaire Prince, Pregnant Mistress PRD_3KMQ0XCFHMQG Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3PPY7QK2SZ40,CON_1BKNS6ZDNTHG,2 A Royal Proposition PRD_3PPY7QK2SZ40 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3Q3GW867JSF0,CON_1BKNS6ZDNTHG,2 Escape From the Harem PRD_3Q3GW867JSF0 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3R4VHNR7T410,CON_1BKNS6ZDNTHG,2 Contract Baby PRD_3R4VHNR7T410 Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3WX2Z524XB3G,CON_1BKNS6ZDNTHG,2 Pretend Mistress, Bona Fide Boss PRD_3WX2Z524XB3G Harumo Sanazaki CON_1BKNS6ZDNTHG 2  
PRD_3XGHSWB3SPH0,CON_1BKNS6ZDNTHG,2 Fantasy Girl PRD_3XGHSWB3SPH0 Harumo Sanazaki CON_1BKNS6ZDNTHG 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);
Powered by Datasette · Queries took 8.479ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS