BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_0R5K8YXNED5G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00BQ2XA2W7G0,CON_0R5K8YXNED5G,2 Volume 10 PRD_00BQ2XA2W7G0 Yasu CON_0R5K8YXNED5G 2  
PRD_0EX20R1J2DM0,CON_0R5K8YXNED5G,2 Volume 8 PRD_0EX20R1J2DM0 Yasu CON_0R5K8YXNED5G 2  
PRD_0HK0K65NRHVG,CON_0R5K8YXNED5G,2 Volume 1 PRD_0HK0K65NRHVG Yasu CON_0R5K8YXNED5G 2  
PRD_0RCKC3P98XGG,CON_0R5K8YXNED5G,24 Volume 1 PRD_0RCKC3P98XGG Yasu CON_0R5K8YXNED5G 24  
PRD_0VK8N8PFWEB0,CON_0R5K8YXNED5G,2 Volume 9 PRD_0VK8N8PFWEB0 Yasu CON_0R5K8YXNED5G 2  
PRD_0W4EJWFGRVG0,CON_0R5K8YXNED5G,2 Volume 10 PRD_0W4EJWFGRVG0 Yasu CON_0R5K8YXNED5G 2  
PRD_11QP1BMWT3C0,CON_0R5K8YXNED5G,2 Volume 5 PRD_11QP1BMWT3C0 Yasu CON_0R5K8YXNED5G 2  
PRD_13TMEZRTR2P0,CON_0R5K8YXNED5G,2 Volume 6 PRD_13TMEZRTR2P0 Yasu CON_0R5K8YXNED5G 2  
PRD_1YHH4PXM5APG,CON_0R5K8YXNED5G,2 Volume 4 PRD_1YHH4PXM5APG Yasu CON_0R5K8YXNED5G 2  
PRD_22X5XK0HF00G,CON_0R5K8YXNED5G,2 Volume 4 PRD_22X5XK0HF00G Yasu CON_0R5K8YXNED5G 2  
PRD_273JJZVC0C70,CON_0R5K8YXNED5G,24 Volume 2 PRD_273JJZVC0C70 Yasu CON_0R5K8YXNED5G 24  
PRD_2MZRQSYFKDQ0,CON_0R5K8YXNED5G,2 Volume 9 PRD_2MZRQSYFKDQ0 Yasu CON_0R5K8YXNED5G 2  
PRD_2QZRESP1JX50,CON_0R5K8YXNED5G,2 Volume 3 PRD_2QZRESP1JX50 Yasu CON_0R5K8YXNED5G 2  
PRD_2SG1PD6QE1J0,CON_0R5K8YXNED5G,2 Volume 2 PRD_2SG1PD6QE1J0 Yasu CON_0R5K8YXNED5G 2  
PRD_2YZN0HF6MBXG,CON_0R5K8YXNED5G,2 Volume 7 PRD_2YZN0HF6MBXG Yasu CON_0R5K8YXNED5G 2  
PRD_34GCJV52204G,CON_0R5K8YXNED5G,2 Volume 5 PRD_34GCJV52204G Yasu CON_0R5K8YXNED5G 2  
PRD_36679HDZTWV0,CON_0R5K8YXNED5G,24 Volume 4 PRD_36679HDZTWV0 Yasu CON_0R5K8YXNED5G 24  
PRD_3ES7AA7S8HN0,CON_0R5K8YXNED5G,2 Volume 7 PRD_3ES7AA7S8HN0 Yasu CON_0R5K8YXNED5G 2  
PRD_3GFWDEAQBQXG,CON_0R5K8YXNED5G,2 Volume 3 PRD_3GFWDEAQBQXG Yasu CON_0R5K8YXNED5G 2  
PRD_3J93QS7RB940,CON_0R5K8YXNED5G,2 Volume 8 PRD_3J93QS7RB940 Yasu CON_0R5K8YXNED5G 2  
PRD_3T90RY962GR0,CON_0R5K8YXNED5G,2 Volume 6 PRD_3T90RY962GR0 Yasu CON_0R5K8YXNED5G 2  
PRD_3TSKYAT3JYJ0,CON_0R5K8YXNED5G,2 Volume 1 PRD_3TSKYAT3JYJ0 Yasu CON_0R5K8YXNED5G 2  
PRD_3W6SAWV2A070,CON_0R5K8YXNED5G,24 Volume 3 PRD_3W6SAWV2A070 Yasu CON_0R5K8YXNED5G 24  
PRD_3WA7WMPH0QHG,CON_0R5K8YXNED5G,2 Volume 2 PRD_3WA7WMPH0QHG Yasu CON_0R5K8YXNED5G 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.965ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS