BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_0FQ4AGE0W0TG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_0BYGEAMAK660,CON_0FQ4AGE0W0TG,24 Volume 12 PRD_0BYGEAMAK660 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_0NNJ63QKSGZG,CON_0FQ4AGE0W0TG,24 Volume 16 PRD_0NNJ63QKSGZG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_0ZCDKEX412EG,CON_0FQ4AGE0W0TG,24 Volume 15 PRD_0ZCDKEX412EG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_14SQXWYHYA10,CON_0FQ4AGE0W0TG,1 Volume 2 PRD_14SQXWYHYA10 Kotoba Inoya CON_0FQ4AGE0W0TG 1  
PRD_14SQXWYHYA10,CON_0FQ4AGE0W0TG,2 Volume 2 PRD_14SQXWYHYA10 Kotoba Inoya CON_0FQ4AGE0W0TG 2  
PRD_1JE1CTYK8SZ0,CON_0FQ4AGE0W0TG,24 Volume 22 PRD_1JE1CTYK8SZ0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_1WZAF3JC7K1G,CON_0FQ4AGE0W0TG,24 Volume 18 PRD_1WZAF3JC7K1G Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_23NNK05YGRH0,CON_0FQ4AGE0W0TG,24 Volume 10 PRD_23NNK05YGRH0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_29Z12NJJ8C50,CON_0FQ4AGE0W0TG,1 Volume 1 PRD_29Z12NJJ8C50 Kotoba Inoya CON_0FQ4AGE0W0TG 1  
PRD_2MVEFRPWCZHG,CON_0FQ4AGE0W0TG,24 Volume 5 PRD_2MVEFRPWCZHG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_2TNQ7QQAEY7G,CON_0FQ4AGE0W0TG,24 Volume 21 PRD_2TNQ7QQAEY7G Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_2V2T3HKZYJ4G,CON_0FQ4AGE0W0TG,24 Volume 13 PRD_2V2T3HKZYJ4G Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_2YY91S11XTT0,CON_0FQ4AGE0W0TG,24 Volume 8 PRD_2YY91S11XTT0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_32HBPQ7EQ0F0,CON_0FQ4AGE0W0TG,24 Volume 6 PRD_32HBPQ7EQ0F0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_33NHQTW70FQG,CON_0FQ4AGE0W0TG,24 Volume 14 PRD_33NHQTW70FQG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3AP2HKVR5F3G,CON_0FQ4AGE0W0TG,24 Volume 17 PRD_3AP2HKVR5F3G Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3BJ4YTVMT6E0,CON_0FQ4AGE0W0TG,24 Volume 4 PRD_3BJ4YTVMT6E0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3C38GY5FHAWG,CON_0FQ4AGE0W0TG,24 Volume 7 PRD_3C38GY5FHAWG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3ESS4CMVQ3PG,CON_0FQ4AGE0W0TG,24 Volume 19 PRD_3ESS4CMVQ3PG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3HMNFZ03RCFG,CON_0FQ4AGE0W0TG,24 Volume 20 PRD_3HMNFZ03RCFG Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3JTCCWQFFAW0,CON_0FQ4AGE0W0TG,24 Volume 3 PRD_3JTCCWQFFAW0 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3PKQ0JHNB590,CON_0FQ4AGE0W0TG,24 Volume 11 PRD_3PKQ0JHNB590 Kotoba Inoya CON_0FQ4AGE0W0TG 24  
PRD_3S0V00RXGFJG,CON_0FQ4AGE0W0TG,24 Volume 9 PRD_3S0V00RXGFJG Kotoba Inoya CON_0FQ4AGE0W0TG 24  

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.538ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS