BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_1E7F4BSSFT9G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_06FX64C23RP0,CON_1E7F4BSSFT9G,0 Volume 3 PRD_06FX64C23RP0 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_0DAN7ZWN1G80,CON_1E7F4BSSFT9G,9 Volume 8 PRD_0DAN7ZWN1G80 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_0EYKZY306WHG,CON_1E7F4BSSFT9G,0 Volume 2 PRD_0EYKZY306WHG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_0G2XNY9FZG90,CON_1E7F4BSSFT9G,0 Volume 3 PRD_0G2XNY9FZG90 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_0G7Y4S9YZHQG,CON_1E7F4BSSFT9G,0 Volume 4 PRD_0G7Y4S9YZHQG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_0ZMET8Z71G1G,CON_1E7F4BSSFT9G,9 Volume 7 PRD_0ZMET8Z71G1G Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_0ZS63PTV8QYG,CON_1E7F4BSSFT9G,0 Volume 1 PRD_0ZS63PTV8QYG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_0ZSC5TTM9TXG,CON_1E7F4BSSFT9G,9 Volume 9 PRD_0ZSC5TTM9TXG Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_10Z4JJ5NPWN0,CON_1E7F4BSSFT9G,0 Megumi Hayashibara's The Characters Taught Me Everything PRD_10Z4JJ5NPWN0 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_12CXDXYAVR3G,CON_1E7F4BSSFT9G,0 Volume 3 PRD_12CXDXYAVR3G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_15352C7ZB8DG,CON_1E7F4BSSFT9G,9 Volume 2 PRD_15352C7ZB8DG Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_1AWPXGWD2DF0,CON_1E7F4BSSFT9G,0 Volume 12 PRD_1AWPXGWD2DF0 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_1GY3BNGYB08G,CON_1E7F4BSSFT9G,0 Volume 11 PRD_1GY3BNGYB08G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_1KJ9JYM4JHQ0,CON_1E7F4BSSFT9G,9 Volume 9 PRD_1KJ9JYM4JHQ0 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_1V50EHHJJRCG,CON_1E7F4BSSFT9G,0 Torture Princess: Fremd Torturchen PRD_1V50EHHJJRCG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_1WCG2H0MS9S0,CON_1E7F4BSSFT9G,9 Volume 7 PRD_1WCG2H0MS9S0 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_1ZJBDQCNYC0G,CON_1E7F4BSSFT9G,9 Volume 6 PRD_1ZJBDQCNYC0G Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_206NDVXX5R6G,CON_1E7F4BSSFT9G,0 Volume 2 PRD_206NDVXX5R6G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_289Q7TD0FE2G,CON_1E7F4BSSFT9G,0 Volume 5 PRD_289Q7TD0FE2G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_2CTC6KSSXM90,CON_1E7F4BSSFT9G,0 Volume 1 PRD_2CTC6KSSXM90 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_2W6MY35SQSD0,CON_1E7F4BSSFT9G,9 Volume 10 PRD_2W6MY35SQSD0 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_2X0A6W2ZVD2G,CON_1E7F4BSSFT9G,0 Volume 4 PRD_2X0A6W2ZVD2G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_2YKVV90NZE3G,CON_1E7F4BSSFT9G,0 Volume 13 PRD_2YKVV90NZE3G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_326ZJANGP95G,CON_1E7F4BSSFT9G,0 Volume 1 PRD_326ZJANGP95G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_339EC7TTVSX0,CON_1E7F4BSSFT9G,9 Volume 3 PRD_339EC7TTVSX0 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_33WZ7VFXXBTG,CON_1E7F4BSSFT9G,0 Volume 2 PRD_33WZ7VFXXBTG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_3AGVHESJPN0G,CON_1E7F4BSSFT9G,9 Volume 5 PRD_3AGVHESJPN0G Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3BH6N0Y25HNG,CON_1E7F4BSSFT9G,0 Volume 4 PRD_3BH6N0Y25HNG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_3D4HDVD5EK4G,CON_1E7F4BSSFT9G,9 Volume 5 PRD_3D4HDVD5EK4G Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3KD8PQVGA410,CON_1E7F4BSSFT9G,9 Volume 1 PRD_3KD8PQVGA410 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3KHHCM42CFC0,CON_1E7F4BSSFT9G,9 Volume 6 PRD_3KHHCM42CFC0 Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3QJB4ZMZBQ30,CON_1E7F4BSSFT9G,0 Volume 3 PRD_3QJB4ZMZBQ30 Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_3RESZ16T69WG,CON_1E7F4BSSFT9G,9 Volume 8 PRD_3RESZ16T69WG Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3ST89J2J0W7G,CON_1E7F4BSSFT9G,0 Volume 2 PRD_3ST89J2J0W7G Nathaniel Thrasher CON_1E7F4BSSFT9G 0  
PRD_3SZNX9Y0P92G,CON_1E7F4BSSFT9G,9 Volume 10 PRD_3SZNX9Y0P92G Nathaniel Thrasher CON_1E7F4BSSFT9G 9  
PRD_3ZECM8DVHCVG,CON_1E7F4BSSFT9G,0 Volume 2 PRD_3ZECM8DVHCVG Nathaniel Thrasher CON_1E7F4BSSFT9G 0  

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