BookWalker

home / database

product_contributors

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

17 rows where contributor_id = "CON_3CVMXMEN4ENG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_044P27HREETG,CON_3CVMXMEN4ENG,24 Volume 11 PRD_044P27HREETG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_0DPQWQC1XATG,CON_3CVMXMEN4ENG,24 Volume 22 PRD_0DPQWQC1XATG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_13R4PFZ2ZCK0,CON_3CVMXMEN4ENG,24 Volume 19 PRD_13R4PFZ2ZCK0 Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_1GAMGKBJNPVG,CON_3CVMXMEN4ENG,1 Volume 23 PRD_1GAMGKBJNPVG Yuto Yotsuba CON_3CVMXMEN4ENG 1  
PRD_1NR15WV6VWRG,CON_3CVMXMEN4ENG,2 Volume 9 PRD_1NR15WV6VWRG Yuto Yotsuba CON_3CVMXMEN4ENG 2  
PRD_1NR15WV6VWRG,CON_3CVMXMEN4ENG,24 Volume 9 PRD_1NR15WV6VWRG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_1S2Z76V5BM4G,CON_3CVMXMEN4ENG,24 Volume 17 PRD_1S2Z76V5BM4G Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_1V13SYE2SD3G,CON_3CVMXMEN4ENG,24 Volume 21 PRD_1V13SYE2SD3G Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_2BD00HV9Z4A0,CON_3CVMXMEN4ENG,24 Volume 16 PRD_2BD00HV9Z4A0 Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_2BTS23NAGWZ0,CON_3CVMXMEN4ENG,2 Volume 10 PRD_2BTS23NAGWZ0 Yuto Yotsuba CON_3CVMXMEN4ENG 2  
PRD_2BTS23NAGWZ0,CON_3CVMXMEN4ENG,24 Volume 10 PRD_2BTS23NAGWZ0 Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3BRAF59SW0ZG,CON_3CVMXMEN4ENG,24 Volume 12 PRD_3BRAF59SW0ZG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3M00E7BJ7EDG,CON_3CVMXMEN4ENG,24 Volume 20 PRD_3M00E7BJ7EDG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3N1TF8MZGY40,CON_3CVMXMEN4ENG,24 Volume 15 PRD_3N1TF8MZGY40 Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3TZ27TSBP7F0,CON_3CVMXMEN4ENG,24 Volume 18 PRD_3TZ27TSBP7F0 Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3Y33JA55SEYG,CON_3CVMXMEN4ENG,24 Volume 14 PRD_3Y33JA55SEYG Yuto Yotsuba CON_3CVMXMEN4ENG 24  
PRD_3ZXX91BZD1WG,CON_3CVMXMEN4ENG,24 Volume 13 PRD_3ZXX91BZD1WG Yuto Yotsuba CON_3CVMXMEN4ENG 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.758ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS