BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_3N39BZJSPX20"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02SQ39VHPCH0,CON_3N39BZJSPX20,1 Volume 16 PRD_02SQ39VHPCH0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_03FRXFW532Y0,CON_3N39BZJSPX20,1 Volume 6 PRD_03FRXFW532Y0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_0H9D5TZ3WCR0,CON_3N39BZJSPX20,1 Volume 15 PRD_0H9D5TZ3WCR0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_134WC47P8KA0,CON_3N39BZJSPX20,1 Volume 2 PRD_134WC47P8KA0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_18N0CHAACT8G,CON_3N39BZJSPX20,1 Volume 17 PRD_18N0CHAACT8G Higasa Akai CON_3N39BZJSPX20 1  
PRD_1FN4RXC5RS9G,CON_3N39BZJSPX20,1 Volume 14 PRD_1FN4RXC5RS9G Higasa Akai CON_3N39BZJSPX20 1  
PRD_1Z51234NPMTG,CON_3N39BZJSPX20,1 Volume 7 PRD_1Z51234NPMTG Higasa Akai CON_3N39BZJSPX20 1  
PRD_20115RJY3710,CON_3N39BZJSPX20,1 Volume 12 PRD_20115RJY3710 Higasa Akai CON_3N39BZJSPX20 1  
PRD_20D12AS9QMGG,CON_3N39BZJSPX20,1 Volume 5 PRD_20D12AS9QMGG Higasa Akai CON_3N39BZJSPX20 1  
PRD_2HE1WZVQMFYG,CON_3N39BZJSPX20,1 Volume 13 PRD_2HE1WZVQMFYG Higasa Akai CON_3N39BZJSPX20 1  
PRD_2NP5N78MB5RG,CON_3N39BZJSPX20,1 Volume 11 PRD_2NP5N78MB5RG Higasa Akai CON_3N39BZJSPX20 1  
PRD_2Y1V63R0JBD0,CON_3N39BZJSPX20,1 Volume 9 PRD_2Y1V63R0JBD0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_31C45EPVPKSG,CON_3N39BZJSPX20,1 Volume 1 PRD_31C45EPVPKSG Higasa Akai CON_3N39BZJSPX20 1  
PRD_32DEXWTX5ZKG,CON_3N39BZJSPX20,1 Chapter 103 PRD_32DEXWTX5ZKG Higasa Akai CON_3N39BZJSPX20 1  
PRD_330R3V4NSGKG,CON_3N39BZJSPX20,1 Volume 8 PRD_330R3V4NSGKG Higasa Akai CON_3N39BZJSPX20 1  
PRD_3GR48F5416M0,CON_3N39BZJSPX20,1 Volume 3 PRD_3GR48F5416M0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_3QEMV27ED5V0,CON_3N39BZJSPX20,1 Volume 4 PRD_3QEMV27ED5V0 Higasa Akai CON_3N39BZJSPX20 1  
PRD_3Y3FN705ZM2G,CON_3N39BZJSPX20,1 Volume 10 PRD_3Y3FN705ZM2G Higasa Akai CON_3N39BZJSPX20 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 8.018ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS