BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_1S7EWQJV61KG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_014D5HF26Z40,CON_1S7EWQJV61KG,1 Volume 5 PRD_014D5HF26Z40 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_0DKGD93VHJBG,CON_1S7EWQJV61KG,1 Volume 10 PRD_0DKGD93VHJBG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_1NWB6P2GGDFG,CON_1S7EWQJV61KG,1 Volume 8 PRD_1NWB6P2GGDFG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_1Q87E01VSMF0,CON_1S7EWQJV61KG,1 Volume 7 PRD_1Q87E01VSMF0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_20606ER2CZN0,CON_1S7EWQJV61KG,1 Volume 3 PRD_20606ER2CZN0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_232V4PN59SRG,CON_1S7EWQJV61KG,1 Volume 12 PRD_232V4PN59SRG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_23D1Z5C2WHV0,CON_1S7EWQJV61KG,1 Volume 11 PRD_23D1Z5C2WHV0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_27X849T3QYK0,CON_1S7EWQJV61KG,1 Volume 14 PRD_27X849T3QYK0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_297FQHMM63SG,CON_1S7EWQJV61KG,1 Volume 1 PRD_297FQHMM63SG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2GK28NFZXCFG,CON_1S7EWQJV61KG,1 Volume 2 PRD_2GK28NFZXCFG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2M20Q2R1Q8TG,CON_1S7EWQJV61KG,1 Volume 1 PRD_2M20Q2R1Q8TG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2ME1DDXKH7F0,CON_1S7EWQJV61KG,1 Volume 13 PRD_2ME1DDXKH7F0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2NMG5TVZ0AT0,CON_1S7EWQJV61KG,1 Volume 9 PRD_2NMG5TVZ0AT0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2QPFMZE7WR8G,CON_1S7EWQJV61KG,1 Volume 4 PRD_2QPFMZE7WR8G Aya Shouto CON_1S7EWQJV61KG 1  
PRD_2S5RHXXBPMF0,CON_1S7EWQJV61KG,1 Volume 15 PRD_2S5RHXXBPMF0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_3314XEXZMCPG,CON_1S7EWQJV61KG,1 Volume 16 PRD_3314XEXZMCPG Aya Shouto CON_1S7EWQJV61KG 1  
PRD_3AV9B4JDG9K0,CON_1S7EWQJV61KG,1 Volume 2 PRD_3AV9B4JDG9K0 Aya Shouto CON_1S7EWQJV61KG 1  
PRD_3JDMNFA99QFG,CON_1S7EWQJV61KG,1 Volume 6 PRD_3JDMNFA99QFG Aya Shouto CON_1S7EWQJV61KG 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.895ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS