BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_3T7PH0088670"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0380F47XKCS0,CON_3T7PH0088670,1 Volume 17 PRD_0380F47XKCS0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_1A3NVHA7D41G,CON_3T7PH0088670,1 Volume 10 PRD_1A3NVHA7D41G Souta Kuwahara CON_3T7PH0088670 1  
PRD_1B2W914AHRE0,CON_3T7PH0088670,1 Volume 5 PRD_1B2W914AHRE0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_1BTAQ320K8A0,CON_3T7PH0088670,1 Volume 13 PRD_1BTAQ320K8A0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_1C6VZPG6EJWG,CON_3T7PH0088670,1 Volume 4 PRD_1C6VZPG6EJWG Souta Kuwahara CON_3T7PH0088670 1  
PRD_1ZMTK188VGYG,CON_3T7PH0088670,1 Volume 8 PRD_1ZMTK188VGYG Souta Kuwahara CON_3T7PH0088670 1  
PRD_29SQVAHBFPVG,CON_3T7PH0088670,1 Volume 1 PRD_29SQVAHBFPVG Souta Kuwahara CON_3T7PH0088670 1  
PRD_2CJKEYTRY3R0,CON_3T7PH0088670,1 Volume 2 PRD_2CJKEYTRY3R0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_2F0ZTVAYJ4YG,CON_3T7PH0088670,1 Volume 14 PRD_2F0ZTVAYJ4YG Souta Kuwahara CON_3T7PH0088670 1  
PRD_2KZ9BT33JST0,CON_3T7PH0088670,1 Volume 7 PRD_2KZ9BT33JST0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_2VQMCBBFVY9G,CON_3T7PH0088670,1 Volume 12 PRD_2VQMCBBFVY9G Souta Kuwahara CON_3T7PH0088670 1  
PRD_2X7AYWWBVTF0,CON_3T7PH0088670,1 Volume 18 PRD_2X7AYWWBVTF0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_37AV1RWJW6S0,CON_3T7PH0088670,1 Volume 15 PRD_37AV1RWJW6S0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_3K6G2TP9PFS0,CON_3T7PH0088670,1 Volume 9 PRD_3K6G2TP9PFS0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_3RJFZMM89CQ0,CON_3T7PH0088670,1 Volume 11 PRD_3RJFZMM89CQ0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_3WRV5HQGJ020,CON_3T7PH0088670,1 Volume 6 PRD_3WRV5HQGJ020 Souta Kuwahara CON_3T7PH0088670 1  
PRD_3X04VAN5EBW0,CON_3T7PH0088670,1 Volume 16 PRD_3X04VAN5EBW0 Souta Kuwahara CON_3T7PH0088670 1  
PRD_3X9YVYQ6GW0G,CON_3T7PH0088670,1 Volume 3 PRD_3X9YVYQ6GW0G Souta Kuwahara CON_3T7PH0088670 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.451ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS