BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_3K9N2M8GPWB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_032CJ0CV2R10,CON_3K9N2M8GPWB0,1 Volume 15 PRD_032CJ0CV2R10 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_032CJ0CV2R10,CON_3K9N2M8GPWB0,2 Volume 15 PRD_032CJ0CV2R10 Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_035A22ZHW440,CON_3K9N2M8GPWB0,1 Volume 1 PRD_035A22ZHW440 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_05RFXFAKFNMG,CON_3K9N2M8GPWB0,1 Volume 6 PRD_05RFXFAKFNMG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_05RFXFAKFNMG,CON_3K9N2M8GPWB0,2 Volume 6 PRD_05RFXFAKFNMG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_07G8KGK3TMDG,CON_3K9N2M8GPWB0,24 Volume 7 PRD_07G8KGK3TMDG Miwa Ueda CON_3K9N2M8GPWB0 24  
PRD_07GZXKEXF700,CON_3K9N2M8GPWB0,1 Volume 13 PRD_07GZXKEXF700 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_07GZXKEXF700,CON_3K9N2M8GPWB0,2 Volume 13 PRD_07GZXKEXF700 Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_0A1EF687B670,CON_3K9N2M8GPWB0,1 Volume 11 PRD_0A1EF687B670 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_0A1EF687B670,CON_3K9N2M8GPWB0,2 Volume 11 PRD_0A1EF687B670 Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_0NHRT8638770,CON_3K9N2M8GPWB0,1 Volume 7 PRD_0NHRT8638770 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_0R6B5V05M660,CON_3K9N2M8GPWB0,1 Volume 5 PRD_0R6B5V05M660 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_0SZDNTHETT30,CON_3K9N2M8GPWB0,1 Volume 9 PRD_0SZDNTHETT30 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_0SZDNTHETT30,CON_3K9N2M8GPWB0,2 Volume 9 PRD_0SZDNTHETT30 Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_0WDW7DJH6S20,CON_3K9N2M8GPWB0,1 Volume 17 PRD_0WDW7DJH6S20 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_0WDW7DJH6S20,CON_3K9N2M8GPWB0,2 Volume 17 PRD_0WDW7DJH6S20 Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_0WMVQE2FG550,CON_3K9N2M8GPWB0,1 Volume 3 PRD_0WMVQE2FG550 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_13QV6YHFNMGG,CON_3K9N2M8GPWB0,1 Volume 4 PRD_13QV6YHFNMGG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_1NCJ1C6NEJQ0,CON_3K9N2M8GPWB0,1 Volume 3 PRD_1NCJ1C6NEJQ0 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_21BQBAZR0RGG,CON_3K9N2M8GPWB0,1 Volume 14 PRD_21BQBAZR0RGG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_21BQBAZR0RGG,CON_3K9N2M8GPWB0,2 Volume 14 PRD_21BQBAZR0RGG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_22N4SQXP4SHG,CON_3K9N2M8GPWB0,1 Volume 16 PRD_22N4SQXP4SHG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_22N4SQXP4SHG,CON_3K9N2M8GPWB0,2 Volume 16 PRD_22N4SQXP4SHG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_22W29RDCY5MG,CON_3K9N2M8GPWB0,1 Volume 2 PRD_22W29RDCY5MG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_25R7PXS2D7QG,CON_3K9N2M8GPWB0,1 Volume 12 PRD_25R7PXS2D7QG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_25R7PXS2D7QG,CON_3K9N2M8GPWB0,2 Volume 12 PRD_25R7PXS2D7QG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_28EP1GV496PG,CON_3K9N2M8GPWB0,1 Volume 10 PRD_28EP1GV496PG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_28EP1GV496PG,CON_3K9N2M8GPWB0,2 Volume 10 PRD_28EP1GV496PG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_2Q8G1ZQYDRQG,CON_3K9N2M8GPWB0,1 Volume 8 PRD_2Q8G1ZQYDRQG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_2VS3CJH0P7PG,CON_3K9N2M8GPWB0,1 Volume 6 PRD_2VS3CJH0P7PG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_2Y4ME33KRTJG,CON_3K9N2M8GPWB0,1 Volume 18 PRD_2Y4ME33KRTJG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_2Y4ME33KRTJG,CON_3K9N2M8GPWB0,2 Volume 18 PRD_2Y4ME33KRTJG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_2YFKY5KAJ6NG,CON_3K9N2M8GPWB0,1 Volume 4 PRD_2YFKY5KAJ6NG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_31SE4VB4K4KG,CON_3K9N2M8GPWB0,1 Volume 5 PRD_31SE4VB4K4KG Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_31SE4VB4K4KG,CON_3K9N2M8GPWB0,2 Volume 5 PRD_31SE4VB4K4KG Miwa Ueda CON_3K9N2M8GPWB0 2  
PRD_34CTN6JK9MP0,CON_3K9N2M8GPWB0,1 Volume 2 PRD_34CTN6JK9MP0 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_3BFY0WFAVV30,CON_3K9N2M8GPWB0,1 Volume 1 PRD_3BFY0WFAVV30 Miwa Ueda CON_3K9N2M8GPWB0 1  
PRD_3Q3EQ7B6Z040,CON_3K9N2M8GPWB0,24 Volume 8 PRD_3Q3EQ7B6Z040 Miwa Ueda CON_3K9N2M8GPWB0 24  

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 12.665ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS