BookWalker

home / database

product_contributors

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

25 rows where contributor_id = "CON_0AV9YFMDW2B0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_034J8JPF096G,CON_0AV9YFMDW2B0,1 Volume 1 PRD_034J8JPF096G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_03M24XQAF5BG,CON_0AV9YFMDW2B0,1 Volume 4 PRD_03M24XQAF5BG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_0917KTR3V2FG,CON_0AV9YFMDW2B0,1 Volume 16 PRD_0917KTR3V2FG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_09X5NNYB4AB0,CON_0AV9YFMDW2B0,1 Volume 7 PRD_09X5NNYB4AB0 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_0AMQM0BAKWMG,CON_0AV9YFMDW2B0,1 Volume 13 PRD_0AMQM0BAKWMG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_0FHCJD4DSDHG,CON_0AV9YFMDW2B0,1 Volume 3 PRD_0FHCJD4DSDHG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_0M0GW4SVTR6G,CON_0AV9YFMDW2B0,1 Volume 15 PRD_0M0GW4SVTR6G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_0M5WQNG9P2P0,CON_0AV9YFMDW2B0,1 Volume 11 PRD_0M5WQNG9P2P0 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_13ACNMAYFX70,CON_0AV9YFMDW2B0,1 Volume 2 PRD_13ACNMAYFX70 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_1697P2K6238G,CON_0AV9YFMDW2B0,1 Volume 4 PRD_1697P2K6238G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_17RR4940RPNG,CON_0AV9YFMDW2B0,1 Volume 14 PRD_17RR4940RPNG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_19H20YA0KY9G,CON_0AV9YFMDW2B0,1 Volume 12 PRD_19H20YA0KY9G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_1KPTTZZQSFMG,CON_0AV9YFMDW2B0,1 Volume 8 PRD_1KPTTZZQSFMG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_25S7JQ8712Q0,CON_0AV9YFMDW2B0,1 Volume 9 PRD_25S7JQ8712Q0 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_265610SX3SKG,CON_0AV9YFMDW2B0,1 Volume 1 PRD_265610SX3SKG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_28KPG4PT1S20,CON_0AV9YFMDW2B0,1 Volume 2 PRD_28KPG4PT1S20 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_2AYCSN2K3F7G,CON_0AV9YFMDW2B0,1 Volume 10 PRD_2AYCSN2K3F7G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_2CTVZWMMW4J0,CON_0AV9YFMDW2B0,1 Volume 2 PRD_2CTVZWMMW4J0 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_2DXFPWYZBD5G,CON_0AV9YFMDW2B0,1 Volume 3 PRD_2DXFPWYZBD5G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_2PJZC6CA2990,CON_0AV9YFMDW2B0,1 Volume 1 PRD_2PJZC6CA2990 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_30QVBVN7J8B0,CON_0AV9YFMDW2B0,1 Volume 5 PRD_30QVBVN7J8B0 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_33CC0F20DD0G,CON_0AV9YFMDW2B0,1 Volume 4 PRD_33CC0F20DD0G Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_348ACCC1A3KG,CON_0AV9YFMDW2B0,1 Volume 3 PRD_348ACCC1A3KG Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_3KMP6RBF7040,CON_0AV9YFMDW2B0,1 Volume 6 PRD_3KMP6RBF7040 Mitsubachi Miyuki CON_0AV9YFMDW2B0 1  
PRD_3SCJPJ88HVEG,CON_0AV9YFMDW2B0,1 Volume 5 PRD_3SCJPJ88HVEG Mitsubachi Miyuki CON_0AV9YFMDW2B0 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.235ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS