BookWalker

home / database

product_contributors

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

29 rows where contributor_id = "CON_3BWTB1EXH8AG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0267NVTXG1FG,CON_3BWTB1EXH8AG,1 Volume 19 PRD_0267NVTXG1FG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_0556J1P9RFDG,CON_3BWTB1EXH8AG,1 Volume 15 PRD_0556J1P9RFDG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_06MP7EM7W0EG,CON_3BWTB1EXH8AG,1 Volume 18 PRD_06MP7EM7W0EG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_0C5Q76AAXZE0,CON_3BWTB1EXH8AG,1 Volume 13 PRD_0C5Q76AAXZE0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_0MJMD2XFC4AG,CON_3BWTB1EXH8AG,1 Volume 8 PRD_0MJMD2XFC4AG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_123PHK5TWT8G,CON_3BWTB1EXH8AG,1 Volume 4 PRD_123PHK5TWT8G Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_12W046Z59VH0,CON_3BWTB1EXH8AG,1 Volume 21 PRD_12W046Z59VH0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_156GES174REG,CON_3BWTB1EXH8AG,1 Volume 1 PRD_156GES174REG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_1QF34D928CHG,CON_3BWTB1EXH8AG,1 Volume 7 PRD_1QF34D928CHG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_1VXKQ0B4MBGG,CON_3BWTB1EXH8AG,1 Volume 6 PRD_1VXKQ0B4MBGG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_1X0XC66GW9PG,CON_3BWTB1EXH8AG,1 Volume 2 PRD_1X0XC66GW9PG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_1YFHTKX3DWJ0,CON_3BWTB1EXH8AG,1 Volume 23 PRD_1YFHTKX3DWJ0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_1YJ22K5EGAQG,CON_3BWTB1EXH8AG,1 Volume 4 PRD_1YJ22K5EGAQG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_20FEE452Y1Z0,CON_3BWTB1EXH8AG,1 Volume 20 PRD_20FEE452Y1Z0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_24XYSQ74T0Y0,CON_3BWTB1EXH8AG,1 Volume 17 PRD_24XYSQ74T0Y0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_2FWFEXV5ZGYG,CON_3BWTB1EXH8AG,1 Volume 14 PRD_2FWFEXV5ZGYG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_2KMX95G026M0,CON_3BWTB1EXH8AG,1 Volume 12 PRD_2KMX95G026M0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_2P5DMRJAE5V0,CON_3BWTB1EXH8AG,1 Volume 9 PRD_2P5DMRJAE5V0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_2S5J9X6B3NVG,CON_3BWTB1EXH8AG,1 Volume 24 PRD_2S5J9X6B3NVG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_30FBJYWB18XG,CON_3BWTB1EXH8AG,1 Volume 3 PRD_30FBJYWB18XG Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_33856GHNT860,CON_3BWTB1EXH8AG,1 Volume 1 PRD_33856GHNT860 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_34S9NGP26SZ0,CON_3BWTB1EXH8AG,1 Volume 2 PRD_34S9NGP26SZ0 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3ET9X8WDN900,CON_3BWTB1EXH8AG,1 Volume 16 PRD_3ET9X8WDN900 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3H7RK4YXAC20,CON_3BWTB1EXH8AG,1 Volume 10 PRD_3H7RK4YXAC20 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3JH81HWVED30,CON_3BWTB1EXH8AG,1 Volume 11 PRD_3JH81HWVED30 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3NHYPPGM3X3G,CON_3BWTB1EXH8AG,1 Volume 25 PRD_3NHYPPGM3X3G Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3RAT8AT9JA00,CON_3BWTB1EXH8AG,1 Volume 5 PRD_3RAT8AT9JA00 Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3WMSKWC0BV1G,CON_3BWTB1EXH8AG,1 Volume 22 PRD_3WMSKWC0BV1G Hiroshi Shiibashi CON_3BWTB1EXH8AG 1  
PRD_3WVAVXQKY970,CON_3BWTB1EXH8AG,1 Volume 3 PRD_3WVAVXQKY970 Hiroshi Shiibashi CON_3BWTB1EXH8AG 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 11.959ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS