BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_2D2SKSCB7G8G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00TWZD9TM07G,CON_2D2SKSCB7G8G,1 Volume 1 PRD_00TWZD9TM07G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_0402255DEZ8G,CON_2D2SKSCB7G8G,1 Volume 1 PRD_0402255DEZ8G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_0GJ5A3E9C0ZG,CON_2D2SKSCB7G8G,2 Volume 1 PRD_0GJ5A3E9C0ZG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_0N12GMG4032G,CON_2D2SKSCB7G8G,1 Lost pain PRD_0N12GMG4032G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_0PGJ51P2443G,CON_2D2SKSCB7G8G,1 SHINYDAYS, A Standard Love Affair PRD_0PGJ51P2443G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_0SQX27JEC21G,CON_2D2SKSCB7G8G,1 Fireworks PRD_0SQX27JEC21G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_0W4CDTFG810G,CON_2D2SKSCB7G8G,1 Shiny Days act.2 PRD_0W4CDTFG810G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_100GYD7KY440,CON_2D2SKSCB7G8G,2 Chapter 6 PRD_100GYD7KY440 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_14H3901NT3B0,CON_2D2SKSCB7G8G,2 Barely Lovers PRD_14H3901NT3B0 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_1B7KMK3R62A0,CON_2D2SKSCB7G8G,2 Chapter 4 PRD_1B7KMK3R62A0 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_1FM267X22190,CON_2D2SKSCB7G8G,2 Chapter 2 PRD_1FM267X22190 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_1XJ0CTA9J550,CON_2D2SKSCB7G8G,2 Chapter 8 PRD_1XJ0CTA9J550 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_22DM64YNP1G0,CON_2D2SKSCB7G8G,1 Shiny Days act.1 PRD_22DM64YNP1G0 Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_2JAJHTZ4E080,CON_2D2SKSCB7G8G,2 Volume 2 PRD_2JAJHTZ4E080 Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_2MSTYA1724K0,CON_2D2SKSCB7G8G,1 The Prince's Secret PRD_2MSTYA1724K0 Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_2QGRJXHTBR9G,CON_2D2SKSCB7G8G,1 Sing for Me PRD_2QGRJXHTBR9G Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_2VEN9X39E3J0,CON_2D2SKSCB7G8G,1 Anniversary PRD_2VEN9X39E3J0 Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_2WNVCPY3RJV0,CON_2D2SKSCB7G8G,1 Volume 1 PRD_2WNVCPY3RJV0 Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_2ZZ5MHWKA2H0,CON_2D2SKSCB7G8G,1 Shiny Days ~What happened after~ PRD_2ZZ5MHWKA2H0 Riyu Yamakami CON_2D2SKSCB7G8G 1  
PRD_33V854NEG5MG,CON_2D2SKSCB7G8G,2 Chapter 7 PRD_33V854NEG5MG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_369RGQPGW4VG,CON_2D2SKSCB7G8G,2 Chapter 5 PRD_369RGQPGW4VG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_39CTDXJX42SG,CON_2D2SKSCB7G8G,2 Chapter 3 PRD_39CTDXJX42SG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_3AYB2AGTR3TG,CON_2D2SKSCB7G8G,2 Enigmatic Man PRD_3AYB2AGTR3TG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_3DXARGC701RG,CON_2D2SKSCB7G8G,2 Chapter 1 PRD_3DXARGC701RG Riyu Yamakami CON_2D2SKSCB7G8G 2  
PRD_3ZASVHV4M6NG,CON_2D2SKSCB7G8G,2 1800 Days Later. PRD_3ZASVHV4M6NG Riyu Yamakami CON_2D2SKSCB7G8G 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.333ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS