BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_0PZNRFT0TEVG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_03GNX41TE62G,CON_0PZNRFT0TEVG,18 Volume 08 PRD_03GNX41TE62G shirakaba CON_0PZNRFT0TEVG 18  
PRD_09F2NZE7FFAG,CON_0PZNRFT0TEVG,18 Volume 03 PRD_09F2NZE7FFAG shirakaba CON_0PZNRFT0TEVG 18  
PRD_0CQ09Y9WGZ3G,CON_0PZNRFT0TEVG,2 Volume 7 PRD_0CQ09Y9WGZ3G shirakaba CON_0PZNRFT0TEVG 2  
PRD_0D5GFDPJ5CV0,CON_0PZNRFT0TEVG,18 Volume 13 PRD_0D5GFDPJ5CV0 shirakaba CON_0PZNRFT0TEVG 18  
PRD_0HBY3Q6PBCS0,CON_0PZNRFT0TEVG,18 Volume 09 PRD_0HBY3Q6PBCS0 shirakaba CON_0PZNRFT0TEVG 18  
PRD_0NH3X9H1TFN0,CON_0PZNRFT0TEVG,18 Volume 12 PRD_0NH3X9H1TFN0 shirakaba CON_0PZNRFT0TEVG 18  
PRD_0SPCHKJ98B6G,CON_0PZNRFT0TEVG,2 Volume 9 PRD_0SPCHKJ98B6G shirakaba CON_0PZNRFT0TEVG 2  
PRD_0Z2FXESGFDV0,CON_0PZNRFT0TEVG,2 Volume 2 PRD_0Z2FXESGFDV0 shirakaba CON_0PZNRFT0TEVG 2  
PRD_1CQDFW55T9DG,CON_0PZNRFT0TEVG,18 Volume 05 PRD_1CQDFW55T9DG shirakaba CON_0PZNRFT0TEVG 18  
PRD_1PNYRE4RCEDG,CON_0PZNRFT0TEVG,2 Volume 6 PRD_1PNYRE4RCEDG shirakaba CON_0PZNRFT0TEVG 2  
PRD_1VE1ZAP12FBG,CON_0PZNRFT0TEVG,18 Volume 07 PRD_1VE1ZAP12FBG shirakaba CON_0PZNRFT0TEVG 18  
PRD_21BG8CZRHH00,CON_0PZNRFT0TEVG,2 Volume 5 PRD_21BG8CZRHH00 shirakaba CON_0PZNRFT0TEVG 2  
PRD_22RN20ZWH6KG,CON_0PZNRFT0TEVG,2 Volume 1 PRD_22RN20ZWH6KG shirakaba CON_0PZNRFT0TEVG 2  
PRD_25TXHW0N8G00,CON_0PZNRFT0TEVG,18 Volume 14 PRD_25TXHW0N8G00 shirakaba CON_0PZNRFT0TEVG 18  
PRD_27QD234R3HG0,CON_0PZNRFT0TEVG,2 Volume 4 PRD_27QD234R3HG0 shirakaba CON_0PZNRFT0TEVG 2  
PRD_28H4MJN1M9FG,CON_0PZNRFT0TEVG,18 Volume 11 PRD_28H4MJN1M9FG shirakaba CON_0PZNRFT0TEVG 18  
PRD_28WZCMCBM4G0,CON_0PZNRFT0TEVG,18 Volume 04 PRD_28WZCMCBM4G0 shirakaba CON_0PZNRFT0TEVG 18  
PRD_29CVE6VN5MAG,CON_0PZNRFT0TEVG,2 Volume 3 PRD_29CVE6VN5MAG shirakaba CON_0PZNRFT0TEVG 2  
PRD_2FHR68HS6HMG,CON_0PZNRFT0TEVG,18 Volume 01 PRD_2FHR68HS6HMG shirakaba CON_0PZNRFT0TEVG 18  
PRD_2K5XSF7868CG,CON_0PZNRFT0TEVG,18 Volume 06 PRD_2K5XSF7868CG shirakaba CON_0PZNRFT0TEVG 18  
PRD_2KCVAHP6KNQG,CON_0PZNRFT0TEVG,18 Volume 02 PRD_2KCVAHP6KNQG shirakaba CON_0PZNRFT0TEVG 18  
PRD_3RZ8N2DSEXNG,CON_0PZNRFT0TEVG,2 Volume 8 PRD_3RZ8N2DSEXNG shirakaba CON_0PZNRFT0TEVG 2  
PRD_3TZKPZM5B4H0,CON_0PZNRFT0TEVG,18 Volume 10 PRD_3TZKPZM5B4H0 shirakaba CON_0PZNRFT0TEVG 18  

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