BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_1P3VQ62CJ000"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_03DDWT2KRSM0,CON_1P3VQ62CJ000,1 Chapter 4 PRD_03DDWT2KRSM0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_03FSRK15XN9G,CON_1P3VQ62CJ000,1 Chapter 30 PRD_03FSRK15XN9G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_063WEEWP4RV0,CON_1P3VQ62CJ000,1 Chapter 2 PRD_063WEEWP4RV0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0AGCS1YR17T0,CON_1P3VQ62CJ000,1 Chapter 1 PRD_0AGCS1YR17T0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0HB39EBV8XG0,CON_1P3VQ62CJ000,1 Chapter 12 PRD_0HB39EBV8XG0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0JTGZV9HCYH0,CON_1P3VQ62CJ000,1 Chapter 14 PRD_0JTGZV9HCYH0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0KXYGW0P6960,CON_1P3VQ62CJ000,1 Volume 2 PRD_0KXYGW0P6960 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0NSKM15XMWQ0,CON_1P3VQ62CJ000,1 Chapter 11 PRD_0NSKM15XMWQ0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0RE27M77GVP0,CON_1P3VQ62CJ000,1 Chapter 9 PRD_0RE27M77GVP0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0WWJH719WTN0,CON_1P3VQ62CJ000,1 Chapter 6 PRD_0WWJH719WTN0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_0Y3EMZVDY2HG,CON_1P3VQ62CJ000,1 Volume 6 PRD_0Y3EMZVDY2HG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_11D8CRE93J20,CON_1P3VQ62CJ000,1 Volume 5 PRD_11D8CRE93J20 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_12BFK57VYJXG,CON_1P3VQ62CJ000,1 Chapter 23 PRD_12BFK57VYJXG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_15E98B306G3G,CON_1P3VQ62CJ000,1 Chapter 19 PRD_15E98B306G3G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_16SYYR1XTHWG,CON_1P3VQ62CJ000,1 Chapter 20 PRD_16SYYR1XTHWG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_19WSVZXA2Z2G,CON_1P3VQ62CJ000,1 Chapter 17 PRD_19WSVZXA2Z2G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_1CD86JZCEY1G,CON_1P3VQ62CJ000,1 Chapter 15 PRD_1CD86JZCEY1G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_1MQWBCE5ANRG,CON_1P3VQ62CJ000,1 Chapter 29 PRD_1MQWBCE5ANRG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_1V4CPZ8FPMZG,CON_1P3VQ62CJ000,1 Chapter 26 PRD_1V4CPZ8FPMZG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_1ZTZ1J5HJKYG,CON_1P3VQ62CJ000,1 Chapter 24 PRD_1ZTZ1J5HJKYG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_21TNN4DH6RBG,CON_1P3VQ62CJ000,1 Chapter 3 PRD_21TNN4DH6RBG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_2K3RG5RPAX0G,CON_1P3VQ62CJ000,1 Chapter 13 PRD_2K3RG5RPAX0G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_2QGB3RTRPW7G,CON_1P3VQ62CJ000,1 Chapter 10 PRD_2QGB3RTRPW7G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_2T6TDBM2JV6G,CON_1P3VQ62CJ000,1 Chapter 8 PRD_2T6TDBM2JV6G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_2X45BHGETS4G,CON_1P3VQ62CJ000,1 Chapter 5 PRD_2X45BHGETS4G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_2YQARYP4YT5G,CON_1P3VQ62CJ000,1 Chapter 7 PRD_2YQARYP4YT5G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_30GP4FPRWHD0,CON_1P3VQ62CJ000,1 Chapter 22 PRD_30GP4FPRWHD0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_34TG865MRMF0,CON_1P3VQ62CJ000,1 Volume 3 PRD_34TG865MRMF0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3716Q2G2RGC0,CON_1P3VQ62CJ000,1 Chapter 21 PRD_3716Q2G2RGC0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_37TG52SE1JHG,CON_1P3VQ62CJ000,1 Volume 4 PRD_37TG52SE1JHG Yen Hioka CON_1P3VQ62CJ000 1  
PRD_38T2KPXYBX2G,CON_1P3VQ62CJ000,1 Volume 1 PRD_38T2KPXYBX2G Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3BQH2NJ54GK0,CON_1P3VQ62CJ000,1 Chapter 18 PRD_3BQH2NJ54GK0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3E40C8CF0ZJ0,CON_1P3VQ62CJ000,1 Chapter 16 PRD_3E40C8CF0ZJ0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3JPYJ5WR24Y0,CON_1P3VQ62CJ000,1 Volume 7 PRD_3JPYJ5WR24Y0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3SDQF9VCMKF0,CON_1P3VQ62CJ000,1 Chapter 27 PRD_3SDQF9VCMKF0 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3TZ4XPSA8M80,CON_1P3VQ62CJ000,1 Chapter 28 PRD_3TZ4XPSA8M80 Yen Hioka CON_1P3VQ62CJ000 1  
PRD_3W27TWMPGJE0,CON_1P3VQ62CJ000,1 Chapter 25 PRD_3W27TWMPGJE0 Yen Hioka CON_1P3VQ62CJ000 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 8.281ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS