BookWalker

home / database

product_contributors

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

15 rows where contributor_id = "CON_0WZS2RDS0F6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02267W5C56G0,CON_0WZS2RDS0F6G,1 Episode 03 PRD_02267W5C56G0 Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_02KR88187BR0,CON_0WZS2RDS0F6G,1 Episode 15 PRD_02KR88187BR0 Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_05JEXEN8RVRG,CON_0WZS2RDS0F6G,1 Episode 12 PRD_05JEXEN8RVRG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_11X7J7F5FH60,CON_0WZS2RDS0F6G,1 Episode 14 PRD_11X7J7F5FH60 Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_18DJY07AEWYG,CON_0WZS2RDS0F6G,1 Episode 01 PRD_18DJY07AEWYG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_1GP6WVP3AKNG,CON_0WZS2RDS0F6G,1 Episode 05 PRD_1GP6WVP3AKNG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_1Q4HEEG5PJMG,CON_0WZS2RDS0F6G,1 Episode 02 PRD_1Q4HEEG5PJMG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_1QZP0WZR237G,CON_0WZS2RDS0F6G,1 Episode 10 PRD_1QZP0WZR237G Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_20V02JGD5AFG,CON_0WZS2RDS0F6G,1 Episode 13 PRD_20V02JGD5AFG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_2BY3ZRFSD8DG,CON_0WZS2RDS0F6G,1 Episode 08 PRD_2BY3ZRFSD8DG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_2D1ZWZJGR5H0,CON_0WZS2RDS0F6G,1 Episode 11 PRD_2D1ZWZJGR5H0 Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_2ECJ9B939QCG,CON_0WZS2RDS0F6G,1 Episode 09 PRD_2ECJ9B939QCG Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_2FRFRY5M0M70,CON_0WZS2RDS0F6G,1 Episode 07 PRD_2FRFRY5M0M70 Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_2XTYEKTF760G,CON_0WZS2RDS0F6G,1 Episode 06 PRD_2XTYEKTF760G Atsuki Nakama CON_0WZS2RDS0F6G 1  
PRD_3A4A5QM50WF0,CON_0WZS2RDS0F6G,1 Episode 04 PRD_3A4A5QM50WF0 Atsuki Nakama CON_0WZS2RDS0F6G 1  

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