BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_3MEH3WTJPVJG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03EKTNP7R7B0,CON_3MEH3WTJPVJG,1 Volume 17 PRD_03EKTNP7R7B0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_07Z248GA46A0,CON_3MEH3WTJPVJG,1 Volume 15 PRD_07Z248GA46A0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_086FHAGSH7SG,CON_3MEH3WTJPVJG,1 Volume 5 PRD_086FHAGSH7SG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_092D1EFPC480,CON_3MEH3WTJPVJG,1 Volume 11 PRD_092D1EFPC480 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0ADJQVJC0590,CON_3MEH3WTJPVJG,1 Volume 13 PRD_0ADJQVJC0590 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0BMAT3QGT52G,CON_3MEH3WTJPVJG,1 Volume 7 PRD_0BMAT3QGT52G Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0DGWC19R83F0,CON_3MEH3WTJPVJG,1 Volume 9 PRD_0DGWC19R83F0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0M37E7MNFBS0,CON_3MEH3WTJPVJG,1 Volume 11 PRD_0M37E7MNFBS0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0NN1JWRHQT60,CON_3MEH3WTJPVJG,1 Volume 23 PRD_0NN1JWRHQT60 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0PS1PC476DD0,CON_3MEH3WTJPVJG,1 Volume 1 PRD_0PS1PC476DD0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0RBGWFTVKS50,CON_3MEH3WTJPVJG,1 Volume 21 PRD_0RBGWFTVKS50 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_0WR3F2MXZR40,CON_3MEH3WTJPVJG,1 Volume 19 PRD_0WR3F2MXZR40 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_1G1CZMB2M2E0,CON_3MEH3WTJPVJG,1 Volume 7 PRD_1G1CZMB2M2E0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_1K1CMGYVX0GG,CON_3MEH3WTJPVJG,1 Volume 25 PRD_1K1CMGYVX0GG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_1MQZ9754G1D0,CON_3MEH3WTJPVJG,1 Volume 5 PRD_1MQZ9754G1D0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_1V4FMT7EW0C0,CON_3MEH3WTJPVJG,1 Volume 3 PRD_1V4FMT7EW0C0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_1ZTY6D0GR0K0,CON_3MEH3WTJPVJG,1 Volume 1 PRD_1ZTY6D0GR0K0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_20NKR9P69DDG,CON_3MEH3WTJPVJG,1 Volume 3 PRD_20NKR9P69DDG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_21QVKY1567TG,CON_3MEH3WTJPVJG,1 Volume 16 PRD_21QVKY1567TG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_22HKY6C02ZEG,CON_3MEH3WTJPVJG,1 Volume 8 PRD_22HKY6C02ZEG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_22KDQKRXGA0G,CON_3MEH3WTJPVJG,1 Volume 4 PRD_22KDQKRXGA0G Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_244AYH3F26SG,CON_3MEH3WTJPVJG,1 Volume 14 PRD_244AYH3F26SG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2700TJEPJHD0,CON_3MEH3WTJPVJG,1 Volume 2 PRD_2700TJEPJHD0 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_28N585WHE5RG,CON_3MEH3WTJPVJG,1 Volume 12 PRD_28N585WHE5RG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2FBNVRYVA4ZG,CON_3MEH3WTJPVJG,1 Volume 10 PRD_2FBNVRYVA4ZG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2RCJCP4T4B20,CON_3MEH3WTJPVJG,1 Volume 6 PRD_2RCJCP4T4B20 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2T28B5BPNTNG,CON_3MEH3WTJPVJG,1 Volume 22 PRD_2T28B5BPNTNG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2X1B0B72XRVG,CON_3MEH3WTJPVJG,1 Volume 18 PRD_2X1B0B72XRVG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2X3D23MTG2FG,CON_3MEH3WTJPVJG,1 Volume 10 PRD_2X3D23MTG2FG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_2YGRPR5RHSMG,CON_3MEH3WTJPVJG,1 Volume 20 PRD_2YGRPR5RHSMG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3HEQDS9RVF00,CON_3MEH3WTJPVJG,1 Volume 24 PRD_3HEQDS9RVF00 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3JR426FPZ010,CON_3MEH3WTJPVJG,1 Volume 26 PRD_3JR426FPZ010 Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3KR45BRXP3YG,CON_3MEH3WTJPVJG,1 Volume 8 PRD_3KR45BRXP3YG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3NH97HNTEHSG,CON_3MEH3WTJPVJG,1 Volume 9 PRD_3NH97HNTEHSG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3PEMGYT7J2XG,CON_3MEH3WTJPVJG,1 Volume 6 PRD_3PEMGYT7J2XG Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3SDPD4HKT03G,CON_3MEH3WTJPVJG,1 Volume 2 PRD_3SDPD4HKT03G Tomonori Inoue CON_3MEH3WTJPVJG 1  
PRD_3TZ73HM9Y1WG,CON_3MEH3WTJPVJG,1 Volume 4 PRD_3TZ73HM9Y1WG Tomonori Inoue CON_3MEH3WTJPVJG 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 9.34ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS