BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_24VQSG1ZN0BG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_08EP28JNYRKG,CON_24VQSG1ZN0BG,1 Volume 22 PRD_08EP28JNYRKG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0CDA4W44WT20,CON_24VQSG1ZN0BG,1 Volume 16 PRD_0CDA4W44WT20 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0CEGMW1S3C90,CON_24VQSG1ZN0BG,1 Volume 24 PRD_0CEGMW1S3C90 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0F2GV6E77XW0,CON_24VQSG1ZN0BG,1 Volume 25 PRD_0F2GV6E77XW0 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0G5R75X730ZG,CON_24VQSG1ZN0BG,1 Volume 5 PRD_0G5R75X730ZG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0J8P6YFXMJSG,CON_24VQSG1ZN0BG,1 Volume 21 PRD_0J8P6YFXMJSG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_0MT8JRZ9FFYG,CON_24VQSG1ZN0BG,1 Volume 2 PRD_0MT8JRZ9FFYG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_11DMG1KAV8CG,CON_24VQSG1ZN0BG,1 Volume 18 PRD_11DMG1KAV8CG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_11TQVFV9N440,CON_24VQSG1ZN0BG,1 Volume 9 PRD_11TQVFV9N440 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_14B662MKH3B0,CON_24VQSG1ZN0BG,1 Volume 7 PRD_14B662MKH3B0 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_171RKWSED4AG,CON_24VQSG1ZN0BG,1 Volume 17 PRD_171RKWSED4AG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_18SPHNPNX2A0,CON_24VQSG1ZN0BG,1 Volume 4 PRD_18SPHNPNX2A0 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_1C2KX2DNHD8G,CON_24VQSG1ZN0BG,1 Volume 23 PRD_1C2KX2DNHD8G Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_1CP4B3Z0KFTG,CON_24VQSG1ZN0BG,1 Volume 11 PRD_1CP4B3Z0KFTG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_1QGN123H4R00,CON_24VQSG1ZN0BG,1 Volume 14 PRD_1QGN123H4R00 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_1YQMY9ZXD660,CON_24VQSG1ZN0BG,1 Volume 13 PRD_1YQMY9ZXD660 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_2APQY30J18JG,CON_24VQSG1ZN0BG,1 Volume 19 PRD_2APQY30J18JG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_2PD0REC41FF0,CON_24VQSG1ZN0BG,1 Volume 3 PRD_2PD0REC41FF0 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_2SG3PMBG9DD0,CON_24VQSG1ZN0BG,1 Volume 1 PRD_2SG3PMBG9DD0 Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_32W52NDN463G,CON_24VQSG1ZN0BG,1 Volume 20 PRD_32W52NDN463G Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_363YDRAEK4VG,CON_24VQSG1ZN0BG,1 Volume 8 PRD_363YDRAEK4VG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_37RGXQTQSRGG,CON_24VQSG1ZN0BG,1 Volume 10 PRD_37RGXQTQSRGG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_3AGEZB7GZ3TG,CON_24VQSG1ZN0BG,1 Volume 6 PRD_3AGEZB7GZ3TG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_3HBD8SHC6SGG,CON_24VQSG1ZN0BG,1 Volume 15 PRD_3HBD8SHC6SGG Yoshifumi Tozuka CON_24VQSG1ZN0BG 1  
PRD_3WWWGJE2B6NG,CON_24VQSG1ZN0BG,1 Volume 12 PRD_3WWWGJE2B6NG Yoshifumi Tozuka CON_24VQSG1ZN0BG 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.349ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS