BookWalker

home / database

product_contributors

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

34 rows where contributor_id = "CON_0ARYQHJFTQ2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_010FPS2HJGFG,CON_0ARYQHJFTQ2G,24 Volume 6 PRD_010FPS2HJGFG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_02KZB61FPH8G,CON_0ARYQHJFTQ2G,24 Volume 19 PRD_02KZB61FPH8G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_0CHCPJGMGFF0,CON_0ARYQHJFTQ2G,24 Volume 35 PRD_0CHCPJGMGFF0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_0G9JHT9Q6N4G,CON_0ARYQHJFTQ2G,24 Volume 33 PRD_0G9JHT9Q6N4G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_0MYD3DBS2MBG,CON_0ARYQHJFTQ2G,24 Volume 10 PRD_0MYD3DBS2MBG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_0VCWE053EKAG,CON_0ARYQHJFTQ2G,24 Volume 3 PRD_0VCWE053EKAG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_0ZXCSK75AJ9G,CON_0ARYQHJFTQ2G,24 Volume 7 PRD_0ZXCSK75AJ9G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_11Y8547S8AH0,CON_0ARYQHJFTQ2G,24 Volume 20 PRD_11Y8547S8AH0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_14CRGQ13M9G0,CON_0ARYQHJFTQ2G,24 Volume 16 PRD_14CRGQ13M9G0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_18XB2A35G8Q0,CON_0ARYQHJFTQ2G,24 Volume 30 PRD_18XB2A35G8Q0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1FKTDYXFWQP0,CON_0ARYQHJFTQ2G,24 Volume 2 PRD_1FKTDYXFWQP0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1K7Z05JYWEE0,CON_0ARYQHJFTQ2G,24 Volume 32 PRD_1K7Z05JYWEE0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1QMFKRC0RDD0,CON_0ARYQHJFTQ2G,24 Volume 31 PRD_1QMFKRC0RDD0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1TAYXBEB4CC0,CON_0ARYQHJFTQ2G,24 Volume 28 PRD_1TAYXBEB4CC0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1X9SVH5QCBJ0,CON_0ARYQHJFTQ2G,24 Volume 25 PRD_1X9SVH5QCBJ0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_1YV98Y8D0CK0,CON_0ARYQHJFTQ2G,24 Volume 27 PRD_1YV98Y8D0CK0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_20V7XGGCMHR0,CON_0ARYQHJFTQ2G,24 Volume 9 PRD_20V7XGGCMHR0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_279PF3DPGGZ0,CON_0ARYQHJFTQ2G,24 Volume 1 PRD_279PF3DPGGZ0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2E84W81QJ0ZG,CON_0ARYQHJFTQ2G,24 Volume 36 PRD_2E84W81QJ0ZG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2J0ARHYHRPN0,CON_0ARYQHJFTQ2G,24 Volume 13 PRD_2J0ARHYHRPN0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2N7NNQTY0MV0,CON_0ARYQHJFTQ2G,24 Volume 12 PRD_2N7NNQTY0MV0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2PH5A4RM4NM0,CON_0ARYQHJFTQ2G,24 Volume 5 PRD_2PH5A4RM4NM0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2SM47AM0CKT0,CON_0ARYQHJFTQ2G,24 Volume 4 PRD_2SM47AM0CKT0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_2WAMJXPA8JS0,CON_0ARYQHJFTQ2G,24 Volume 17 PRD_2WAMJXPA8JS0 Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_33H0CVMMAA1G,CON_0ARYQHJFTQ2G,24 Volume 22/23/24 PRD_33H0CVMMAA1G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_367GYEPYP90G,CON_0ARYQHJFTQ2G,24 Volume 15 PRD_367GYEPYP90G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_39AKMMJAYQ6G,CON_0ARYQHJFTQ2G,24 Volume 18 PRD_39AKMMJAYQ6G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3AM391G0J87G,CON_0ARYQHJFTQ2G,24 Volume 8 PRD_3AM391G0J87G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3DV267CCTP5G,CON_0ARYQHJFTQ2G,24 Volume 21 PRD_3DV267CCTP5G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3HF7SFX3TEXG,CON_0ARYQHJFTQ2G,24 Volume 14 PRD_3HF7SFX3TEXG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3JYQFV3SYFYG,CON_0ARYQHJFTQ2G,24 Volume 34 PRD_3JYQFV3SYFYG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3NXP42Z66DWG,CON_0ARYQHJFTQ2G,24 Volume 11 PRD_3NXP42Z66DWG Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3RJ6QNS82C3G,CON_0ARYQHJFTQ2G,24 Volume 29 PRD_3RJ6QNS82C3G Tomoko Hayakawa CON_0ARYQHJFTQ2G 24  
PRD_3Z0H18TJEB2G,CON_0ARYQHJFTQ2G,24 Volume 26 PRD_3Z0H18TJEB2G Tomoko Hayakawa CON_0ARYQHJFTQ2G 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 8.394ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS