BookWalker

home / database

product_contributors

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

24 rows where contributor_id = "CON_1AZPW3YYFJT0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0AEY2SF7SY0G,CON_1AZPW3YYFJT0,1 Volume 9 PRD_0AEY2SF7SY0G Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0BNZ1TRNVPSG,CON_1AZPW3YYFJT0,1 Volume 15 PRD_0BNZ1TRNVPSG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0HVP5XSH2M60,CON_1AZPW3YYFJT0,1 Volume 14 PRD_0HVP5XSH2M60 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0KKPNV610TFG,CON_1AZPW3YYFJT0,1 Volume 3 PRD_0KKPNV610TFG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0M522ENF4CWG,CON_1AZPW3YYFJT0,1 Volume 22 PRD_0M522ENF4CWG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0MQS8JJXEDDG,CON_1AZPW3YYFJT0,1 Volume 13 PRD_0MQS8JJXEDDG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0SNKVNAPXB5G,CON_1AZPW3YYFJT0,1 Volume 8 PRD_0SNKVNAPXB5G Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0TPHJ12D8RDG,CON_1AZPW3YYFJT0,1 Volume 2 PRD_0TPHJ12D8RDG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0TTBYWKY6H60,CON_1AZPW3YYFJT0,1 Volume 12 PRD_0TTBYWKY6H60 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_0W26SKFYK0X0,CON_1AZPW3YYFJT0,1 Volume 23 PRD_0W26SKFYK0X0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_142AKJ7DHQTG,CON_1AZPW3YYFJT0,1 Volume 11 PRD_142AKJ7DHQTG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_1K6K1D4T5XAG,CON_1AZPW3YYFJT0,1 Volume 20 PRD_1K6K1D4T5XAG Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_21ZVNP379VY0,CON_1AZPW3YYFJT0,1 Volume 6 PRD_21ZVNP379VY0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_2D01909HZYM0,CON_1AZPW3YYFJT0,1 Volume 16 PRD_2D01909HZYM0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_2F2T6FDPNMA0,CON_1AZPW3YYFJT0,1 Volume 1 PRD_2F2T6FDPNMA0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_2FDXE50EA2Y0,CON_1AZPW3YYFJT0,1 Volume 17 PRD_2FDXE50EA2Y0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_2RZRBBCJPRX0,CON_1AZPW3YYFJT0,1 Volume 4 PRD_2RZRBBCJPRX0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_306MHDK4A2A0,CON_1AZPW3YYFJT0,1 Volume 21 PRD_306MHDK4A2A0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_30WZA0R4MEG0,CON_1AZPW3YYFJT0,1 Volume 10 PRD_30WZA0R4MEG0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_31ZYHHZFJ290,CON_1AZPW3YYFJT0,1 Volume 24 PRD_31ZYHHZFJ290 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_38E8Z8QC4MJ0,CON_1AZPW3YYFJT0,1 Volume 18 PRD_38E8Z8QC4MJ0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_3C1CBBXQHTH0,CON_1AZPW3YYFJT0,1 Volume 7 PRD_3C1CBBXQHTH0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_3FCJK7CJ2RS0,CON_1AZPW3YYFJT0,1 Volume 19 PRD_3FCJK7CJ2RS0 Tadahiro Miura CON_1AZPW3YYFJT0 1  
PRD_3FYNZ3G57ADG,CON_1AZPW3YYFJT0,1 Volume 5 PRD_3FYNZ3G57ADG Tadahiro Miura CON_1AZPW3YYFJT0 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.848ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS