BookWalker

home / database

product_contributors

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

21 rows where contributor_id = "CON_2RG8MAMQY82G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0K447XFREK60,CON_2RG8MAMQY82G,1 Chapter 11 PRD_0K447XFREK60 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_0QTMJG92AJ50,CON_2RG8MAMQY82G,1 Chapter 9 PRD_0QTMJG92AJ50 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_0XE6S96GYZA0,CON_2RG8MAMQY82G,1 Chapter 3 PRD_0XE6S96GYZA0 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_104F1F3X3T40,CON_2RG8MAMQY82G,1 Chapter 6 PRD_104F1F3X3T40 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_10TKV752G8JG,CON_2RG8MAMQY82G,1 Chapter 1 PRD_10TKV752G8JG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1H58M0EMJ7DG,CON_2RG8MAMQY82G,1 Chapter 3 PRD_1H58M0EMJ7DG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1JMR9DCJ9REG,CON_2RG8MAMQY82G,1 Chapter 5 PRD_1JMR9DCJ9REG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1NVV7K8YY6CG,CON_2RG8MAMQY82G,1 Chapter 1 PRD_1NVV7K8YY6CG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1PC4STAYXX90,CON_2RG8MAMQY82G,1 Chapter 10 PRD_1PC4STAYXX90 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1SK7P06B5VF0,CON_2RG8MAMQY82G,1 Chapter 6 PRD_1SK7P06B5VF0 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1SQGY19P89CG,CON_2RG8MAMQY82G,1 Chapter 5 PRD_1SQGY19P89CG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_1YJN9S58EP60,CON_2RG8MAMQY82G,1 Chapter 9 PRD_1YJN9S58EP60 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_2M3ZBTR78JMG,CON_2RG8MAMQY82G,1 Chapter 7 PRD_2M3ZBTR78JMG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_2RGFNDT9MHVG,CON_2RG8MAMQY82G,1 Chapter 4 PRD_2RGFNDT9MHVG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_32DB2YTXJ830,CON_2RG8MAMQY82G,1 Chapter 2 PRD_32DB2YTXJ830 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_33Z786GR5VMG,CON_2RG8MAMQY82G,1 Chapter 7 PRD_33Z786GR5VMG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_3GW03QZQQRY0,CON_2RG8MAMQY82G,1 Chapter 4 PRD_3GW03QZQQRY0 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_3QJKDASSG7X0,CON_2RG8MAMQY82G,1 Chapter 2 PRD_3QJKDASSG7X0 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_3R52GGTB0QPG,CON_2RG8MAMQY82G,1 Chapter 10 PRD_3R52GGTB0QPG Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_3V72NPFTHET0,CON_2RG8MAMQY82G,1 Chapter 8 PRD_3V72NPFTHET0 Ui Shishiyama CON_2RG8MAMQY82G 1  
PRD_3WVX23MDCPNG,CON_2RG8MAMQY82G,1 Chapter 8 PRD_3WVX23MDCPNG Ui Shishiyama CON_2RG8MAMQY82G 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.466ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS