BookWalker

home / database

product_contributors

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

33 rows where contributor_id = "CON_20MTSCVDAZV0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00EEJX9E9M90,CON_20MTSCVDAZV0,1 Volume 12 PRD_00EEJX9E9M90 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_04WSXGAGNK80,CON_20MTSCVDAZV0,1 Volume 10 PRD_04WSXGAGNK80 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_08MG7B0RJBZ0,CON_20MTSCVDAZV0,1 Volume 8 PRD_08MG7B0RJBZ0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0F7XFHZVBTGG,CON_20MTSCVDAZV0,1 Volume 2 PRD_0F7XFHZVBTGG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0P4CRHHNS850,CON_20MTSCVDAZV0,1 Volume 2 PRD_0P4CRHHNS850 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0SBFNQD21PB0,CON_20MTSCVDAZV0,1 Volume 16 PRD_0SBFNQD21PB0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0TTZA4KR5Q40,CON_20MTSCVDAZV0,1 Volume 18 PRD_0TTZA4KR5Q40 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0XSY7AF4DNA0,CON_20MTSCVDAZV0,1 Volume 14 PRD_0XSY7AF4DNA0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_0YH7GYGJR390,CON_20MTSCVDAZV0,1 Volume 7 PRD_0YH7GYGJR390 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_17P94T4D4YC0,CON_20MTSCVDAZV0,1 Volume 9 PRD_17P94T4D4YC0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_17TTCVFRBDHG,CON_20MTSCVDAZV0,1 Volume 7 PRD_17TTCVFRBDHG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1ABAYE92QCGG,CON_20MTSCVDAZV0,1 Volume 5 PRD_1ABAYE92QCGG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1DENMM5EZAPG,CON_20MTSCVDAZV0,1 Volume 22 PRD_1DENMM5EZAPG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1ER591B4KBQG,CON_20MTSCVDAZV0,1 Volume 3 PRD_1ER591B4KBQG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1G4VA15A1JF0,CON_20MTSCVDAZV0,1 Volume 3 PRD_1G4VA15A1JF0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1NHSN974ZBD0,CON_20MTSCVDAZV0,1 Volume 9 PRD_1NHSN974ZBD0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1WKEFM80WGE0,CON_20MTSCVDAZV0,1 Volume 17 PRD_1WKEFM80WGE0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1Y9Z413TJSJ0,CON_20MTSCVDAZV0,1 Volume 1 PRD_1Y9Z413TJSJ0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_1Y9Z413TJSJ0,CON_20MTSCVDAZV0,2 Volume 1 PRD_1Y9Z413TJSJ0 Q Hayashida CON_20MTSCVDAZV0 2  
PRD_2216SMY9BNSG,CON_20MTSCVDAZV0,1 Volume 13 PRD_2216SMY9BNSG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2541PTNNKKZG,CON_20MTSCVDAZV0,1 Volume 1 PRD_2541PTNNKKZG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_26K436G016V0,CON_20MTSCVDAZV0,1 Volume 8 PRD_26K436G016V0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_26QHB7VKQMRG,CON_20MTSCVDAZV0,1 Volume 11 PRD_26QHB7VKQMRG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2BYTVY1M2ETG,CON_20MTSCVDAZV0,1 Volume 4 PRD_2BYTVY1M2ETG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2HZ4676GV9NG,CON_20MTSCVDAZV0,1 Volume 20 PRD_2HZ4676GV9NG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2JV04XFBGEX0,CON_20MTSCVDAZV0,1 Volume 6 PRD_2JV04XFBGEX0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2MDMHT0V78MG,CON_20MTSCVDAZV0,1 Volume 19 PRD_2MDMHT0V78MG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_2ZGPE1W7FPTG,CON_20MTSCVDAZV0,1 Volume 15 PRD_2ZGPE1W7FPTG Q Hayashida CON_20MTSCVDAZV0 1  
PRD_342255YX9C10,CON_20MTSCVDAZV0,1 Volume 6 PRD_342255YX9C10 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_38GJGRR7NB00,CON_20MTSCVDAZV0,1 Volume 4 PRD_38GJGRR7NB00 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_3F1D2BT9HA70,CON_20MTSCVDAZV0,1 Volume 23 PRD_3F1D2BT9HA70 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_3GN6PJBRH2Z0,CON_20MTSCVDAZV0,1 Volume 21 PRD_3GN6PJBRH2Z0 Q Hayashida CON_20MTSCVDAZV0 1  
PRD_3QGA1FD09APG,CON_20MTSCVDAZV0,1 Volume 5 PRD_3QGA1FD09APG Q Hayashida CON_20MTSCVDAZV0 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 10.435ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS