BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_0RQ4C6CNXFVG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_02KARAFFDCH0,CON_0RQ4C6CNXFVG,0 Chapter 12 PRD_02KARAFFDCH0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_04VYF1G3Q380,CON_0RQ4C6CNXFVG,0 Chapter 19 PRD_04VYF1G3Q380 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_05PNPGAVNAQ0,CON_0RQ4C6CNXFVG,0 Chapter 11 PRD_05PNPGAVNAQ0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_0ASJFJXRF540,CON_0RQ4C6CNXFVG,0 Chapter 5 PRD_0ASJFJXRF540 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_0HFE2HS65BEG,CON_0RQ4C6CNXFVG,0 Chapter 24 PRD_0HFE2HS65BEG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_0HFE2HS65BEG,CON_0RQ4C6CNXFVG,1 Chapter 24 PRD_0HFE2HS65BEG HARUTO CHINO CON_0RQ4C6CNXFVG 1  
PRD_0P7ZJ27C1PAG,CON_0RQ4C6CNXFVG,0 Chapter 20 PRD_0P7ZJ27C1PAG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_10CD41RY8HCG,CON_0RQ4C6CNXFVG,0 Chapter 10 PRD_10CD41RY8HCG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_172XQMT0MHKG,CON_0RQ4C6CNXFVG,0 Chapter 7 PRD_172XQMT0MHKG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_17MN6DWPKBQ0,CON_0RQ4C6CNXFVG,0 Chapter 18 PRD_17MN6DWPKBQ0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_1CS8335ZKBH0,CON_0RQ4C6CNXFVG,0 Chapter 4 PRD_1CS8335ZKBH0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_1EMVMJGQMVQG,CON_0RQ4C6CNXFVG,0 Chapter 22 PRD_1EMVMJGQMVQG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_1PA0JM15RN8G,CON_0RQ4C6CNXFVG,0 Chapter 6 PRD_1PA0JM15RN8G HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2FQAJEE794TG,CON_0RQ4C6CNXFVG,0 Chapter 3 PRD_2FQAJEE794TG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2J00DM4HZ0XG,CON_0RQ4C6CNXFVG,0 Chapter 14 PRD_2J00DM4HZ0XG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2K6687E17CZ0,CON_0RQ4C6CNXFVG,0 Chapter 25 PRD_2K6687E17CZ0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2K6687E17CZ0,CON_0RQ4C6CNXFVG,1 Chapter 25 PRD_2K6687E17CZ0 HARUTO CHINO CON_0RQ4C6CNXFVG 1  
PRD_2N73AT0Y7E3G,CON_0RQ4C6CNXFVG,0 Chapter 15 PRD_2N73AT0Y7E3G HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2QMPVT8B3BY0,CON_0RQ4C6CNXFVG,0 Chapter 23 PRD_2QMPVT8B3BY0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_2QMPVT8B3BY0,CON_0RQ4C6CNXFVG,1 Chapter 23 PRD_2QMPVT8B3BY0 HARUTO CHINO CON_0RQ4C6CNXFVG 1  
PRD_2SNKMD203D2G,CON_0RQ4C6CNXFVG,0 Chapter 16 PRD_2SNKMD203D2G HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_32YJ3GGF9C0G,CON_0RQ4C6CNXFVG,0 Chapter 17 PRD_32YJ3GGF9C0G HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_36NNXAB3PHW0,CON_0RQ4C6CNXFVG,0 Chapter 8 PRD_36NNXAB3PHW0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_3DRSVBTCH0E0,CON_0RQ4C6CNXFVG,0 Chapter 13 PRD_3DRSVBTCH0E0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_3EG0ATTTNB1G,CON_0RQ4C6CNXFVG,0 Chapter 1 PRD_3EG0ATTTNB1G HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_3G2RRBP0TPS0,CON_0RQ4C6CNXFVG,0 Chapter 9 PRD_3G2RRBP0TPS0 HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_3J45X189N3SG,CON_0RQ4C6CNXFVG,0 Chapter 2 PRD_3J45X189N3SG HARUTO CHINO CON_0RQ4C6CNXFVG 0  
PRD_3Q50VQTS5F3G,CON_0RQ4C6CNXFVG,0 Chapter 21 PRD_3Q50VQTS5F3G HARUTO CHINO CON_0RQ4C6CNXFVG 0  

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.779ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS