BookWalker

home / database

product_contributors

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

16 rows where contributor_id = "CON_3JW2RNEXPSCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01JXVZX79J50,CON_3JW2RNEXPSCG,1 Volume 5 PRD_01JXVZX79J50 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_02WD8B3XDK60,CON_3JW2RNEXPSCG,1 Volume 6 PRD_02WD8B3XDK60 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_043C6JZ9NH40,CON_3JW2RNEXPSCG,1 Volume 4 PRD_043C6JZ9NH40 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_08HWG5RKHGB0,CON_3JW2RNEXPSCG,1 Volume 8 PRD_08HWG5RKHGB0 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_0F6F3RTNXZA0,CON_3JW2RNEXPSCG,1 Volume 10 PRD_0F6F3RTNXZA0 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_0VS3K57H5N00,CON_3JW2RNEXPSCG,1 Volume 7 PRD_0VS3K57H5N00 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_0YFJYR1V1M70,CON_3JW2RNEXPSCG,1 Volume 12 PRD_0YFJYR1V1M70 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_1KMYDBMZSY90,CON_3JW2RNEXPSCG,1 Volume TRUE END 14 PRD_1KMYDBMZSY90 Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_235N2NJ2BKNG,CON_3JW2RNEXPSCG,1 Volume TRUE END 13 PRD_235N2NJ2BKNG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_27T4C8C4QJMG,CON_3JW2RNEXPSCG,1 Volume TRUE END 15 PRD_27T4C8C4QJMG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_2A8MZVEEKHVG,CON_3JW2RNEXPSCG,1 Volume 11 PRD_2A8MZVEEKHVG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_2DFQM15TVZSG,CON_3JW2RNEXPSCG,1 Volume 2 PRD_2DFQM15TVZSG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_2ES79EBGZGTG,CON_3JW2RNEXPSCG,1 Volume 1 PRD_2ES79EBGZGTG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_2R6A4FPP3NQG,CON_3JW2RNEXPSCG,1 Volume 3 PRD_2R6A4FPP3NQG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_2WMTQ2GRFMPG,CON_3JW2RNEXPSCG,1 Volume 9 PRD_2WMTQ2GRFMPG Daisuke Nishijima CON_3JW2RNEXPSCG 1  
PRD_30YGAJ43G5RG,CON_3JW2RNEXPSCG,1 A Kindly World PRD_30YGAJ43G5RG Daisuke Nishijima CON_3JW2RNEXPSCG 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 7.575ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS