BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_2A9MZ4THK5DG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01V34AK4BWPG,CON_2A9MZ4THK5DG,1 Volume 15 PRD_01V34AK4BWPG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_049KQXDEQVNG,CON_2A9MZ4THK5DG,1 Volume 14 PRD_049KQXDEQVNG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_08BZG3B9B6F0,CON_2A9MZ4THK5DG,1 Volume 6 PRD_08BZG3B9B6F0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_08Y22GEGKTMG,CON_2A9MZ4THK5DG,1 Volume 12 PRD_08Y22GEGKTMG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0CRE3P4KQ5E0,CON_2A9MZ4THK5DG,1 Volume 5 PRD_0CRE3P4KQ5E0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0FCXC38TZSVG,CON_2A9MZ4THK5DG,1 Volume 11 PRD_0FCXC38TZSVG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0H7Q0RTBRQYG,CON_2A9MZ4THK5DG,1 Volume 3 PRD_0H7Q0RTBRQYG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0M7BE810ESB0,CON_2A9MZ4THK5DG,1 Volume 19 PRD_0M7BE810ESB0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0NM7JBME4PXG,CON_2A9MZ4THK5DG,1 Volume 7 PRD_0NM7JBME4PXG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0Q2J1HM4JW50,CON_2A9MZ4THK5DG,1 Volume 1 PRD_0Q2J1HM4JW50 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0QNKTY3ZEEG0,CON_2A9MZ4THK5DG,1 Volume 2 PRD_0QNKTY3ZEEG0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_0S80EEW64EBG,CON_2A9MZ4THK5DG,1 Volume 17 PRD_0S80EEW64EBG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_14XEBVH36P50,CON_2A9MZ4THK5DG,1 Volume 16 PRD_14XEBVH36P50 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1BRSSWVBW13G,CON_2A9MZ4THK5DG,1 Volume 4 PRD_1BRSSWVBW13G Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1KESD96NK4D0,CON_2A9MZ4THK5DG,1 Volume 2 PRD_1KESD96NK4D0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1PKW994747SG,CON_2A9MZ4THK5DG,1 Volume 8 PRD_1PKW994747SG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1SPZ6F3KC5ZG,CON_2A9MZ4THK5DG,1 Volume 6 PRD_1SPZ6F3KC5ZG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1V0KC9TR6E60,CON_2A9MZ4THK5DG,1 Volume 6 PRD_1V0KC9TR6E60 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_1ZH3ZWM22D50,CON_2A9MZ4THK5DG,1 Volume 9 PRD_1ZH3ZWM22D50 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_297AVTSNHS40,CON_2A9MZ4THK5DG,1 Volume 10 PRD_297AVTSNHS40 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2A4SQAXZXYDG,CON_2A9MZ4THK5DG,1 Volume 20 PRD_2A4SQAXZXYDG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2APT87ZKNT50,CON_2A9MZ4THK5DG,1 Volume 13 PRD_2APT87ZKNT50 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2CQBGRWETA3G,CON_2A9MZ4THK5DG,1 Volume 18 PRD_2CQBGRWETA3G Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2DM55DVZXRB0,CON_2A9MZ4THK5DG,1 Volume 9 PRD_2DM55DVZXRB0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2EK69DTE96YG,CON_2A9MZ4THK5DG,1 Volume 7 PRD_2EK69DTE96YG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2J4VXMBX8YPG,CON_2A9MZ4THK5DG,1 Volume 4 PRD_2J4VXMBX8YPG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2M2VK8JWCD7G,CON_2A9MZ4THK5DG,1 Volume 1 PRD_2M2VK8JWCD7G Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2VXE4M6K2ND0,CON_2A9MZ4THK5DG,1 Volume 2 PRD_2VXE4M6K2ND0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_2YKYP70NEMC0,CON_2A9MZ4THK5DG,1 Volume 8 PRD_2YKYP70NEMC0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_36X6NZEWJ2D0,CON_2A9MZ4THK5DG,1 Volume 3 PRD_36X6NZEWJ2D0 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3BJ5RZWNMASG,CON_2A9MZ4THK5DG,1 Volume 1 PRD_3BJ5RZWNMASG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3HP17KHTH4WG,CON_2A9MZ4THK5DG,1 Volume 3 PRD_3HP17KHTH4WG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3S9V6J5X4ENG,CON_2A9MZ4THK5DG,1 Volume 5 PRD_3S9V6J5X4ENG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3V9QD6HEE580,CON_2A9MZ4THK5DG,1 Volume 7 PRD_3V9QD6HEE580 Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3XYBG5770DMG,CON_2A9MZ4THK5DG,1 Volume 4 PRD_3XYBG5770DMG Haro Aso CON_2A9MZ4THK5DG 1  
PRD_3ZY7RSJGA4F0,CON_2A9MZ4THK5DG,1 Volume 5 PRD_3ZY7RSJGA4F0 Haro Aso CON_2A9MZ4THK5DG 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.614ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS