BookWalker

home / database

product_contributors

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

26 rows where contributor_id = "CON_051EX8XA3BNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_06D0865FMRN0,CON_051EX8XA3BNG,24 Volume 2 PRD_06D0865FMRN0 Miraijin A CON_051EX8XA3BNG 24  
PRD_06Z6Y683PX8G,CON_051EX8XA3BNG,24 Volume 4 PRD_06Z6Y683PX8G Miraijin A CON_051EX8XA3BNG 24  
PRD_09VY5KFCBE00,CON_051EX8XA3BNG,1 Volume 2 PRD_09VY5KFCBE00 Miraijin A CON_051EX8XA3BNG 1  
PRD_0ADWP2QDB240,CON_051EX8XA3BNG,24 Volume 5 PRD_0ADWP2QDB240 Miraijin A CON_051EX8XA3BNG 24  
PRD_0D720S3FK6D0,CON_051EX8XA3BNG,1 Volume 4 PRD_0D720S3FK6D0 Miraijin A CON_051EX8XA3BNG 1  
PRD_0ENPA87HHFPG,CON_051EX8XA3BNG,24 Volume 7 PRD_0ENPA87HHFPG Miraijin A CON_051EX8XA3BNG 24  
PRD_0GKAN3M85Q10,CON_051EX8XA3BNG,24 Volume 3 PRD_0GKAN3M85Q10 Miraijin A CON_051EX8XA3BNG 24  
PRD_0RSP0DFS0VG0,CON_051EX8XA3BNG,24 Volume 7 PRD_0RSP0DFS0VG0 Miraijin A CON_051EX8XA3BNG 24  
PRD_13PKW9CB4W90,CON_051EX8XA3BNG,24 Volume 9 PRD_13PKW9CB4W90 Miraijin A CON_051EX8XA3BNG 24  
PRD_14BFE1GC43YG,CON_051EX8XA3BNG,24 Volume 6 PRD_14BFE1GC43YG Miraijin A CON_051EX8XA3BNG 24  
PRD_18SZSMDP02XG,CON_051EX8XA3BNG,24 Volume 5 PRD_18SZSMDP02XG Miraijin A CON_051EX8XA3BNG 24  
PRD_1M3W421ZP45G,CON_051EX8XA3BNG,24 Volume 1 PRD_1M3W421ZP45G Miraijin A CON_051EX8XA3BNG 24  
PRD_1TE1M55TBCE0,CON_051EX8XA3BNG,24 Volume 6 PRD_1TE1M55TBCE0 Miraijin A CON_051EX8XA3BNG 24  
PRD_1XYWXTGGKM90,CON_051EX8XA3BNG,1 Volume 5 PRD_1XYWXTGGKM90 Miraijin A CON_051EX8XA3BNG 1  
PRD_2K0H7YCTBFX0,CON_051EX8XA3BNG,1 Volume 14 PRD_2K0H7YCTBFX0 Miraijin A CON_051EX8XA3BNG 1  
PRD_2K0H7YCTBFX0,CON_051EX8XA3BNG,2 Volume 14 PRD_2K0H7YCTBFX0 Miraijin A CON_051EX8XA3BNG 2  
PRD_2ZNZ6MPNB9SG,CON_051EX8XA3BNG,24 Volume 4 PRD_2ZNZ6MPNB9SG Miraijin A CON_051EX8XA3BNG 24  
PRD_33RSG33D9CY0,CON_051EX8XA3BNG,24 Volume 8 PRD_33RSG33D9CY0 Miraijin A CON_051EX8XA3BNG 24  
PRD_3825GKD7FM80,CON_051EX8XA3BNG,2 Volume 3 PRD_3825GKD7FM80 Miraijin A CON_051EX8XA3BNG 2  
PRD_3825GKD7FM80,CON_051EX8XA3BNG,24 Volume 3 PRD_3825GKD7FM80 Miraijin A CON_051EX8XA3BNG 24  
PRD_3ESQZBSTKAKG,CON_051EX8XA3BNG,1 Volume 1 PRD_3ESQZBSTKAKG Miraijin A CON_051EX8XA3BNG 1  
PRD_3HJ1HM095R50,CON_051EX8XA3BNG,2 Volume 8 PRD_3HJ1HM095R50 Miraijin A CON_051EX8XA3BNG 2  
PRD_3HJ1HM095R50,CON_051EX8XA3BNG,24 Volume 8 PRD_3HJ1HM095R50 Miraijin A CON_051EX8XA3BNG 24  
PRD_3Q4VV3XPSS90,CON_051EX8XA3BNG,1 Volume 3 PRD_3Q4VV3XPSS90 Miraijin A CON_051EX8XA3BNG 1  
PRD_3Q4ZG56Q3K50,CON_051EX8XA3BNG,24 Volume 7 PRD_3Q4ZG56Q3K50 Miraijin A CON_051EX8XA3BNG 24  
PRD_3TB4XCGWM4N0,CON_051EX8XA3BNG,24 Volume 2 PRD_3TB4XCGWM4N0 Miraijin A CON_051EX8XA3BNG 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.32ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS