BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_0KD6BYCRXMYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_060AX7GT5AQG,CON_0KD6BYCRXMYG,1 Volume 1 PRD_060AX7GT5AQG Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_060AX7GT5AQG,CON_0KD6BYCRXMYG,2 Volume 1 PRD_060AX7GT5AQG Yoko Nogiri CON_0KD6BYCRXMYG 2  
PRD_0DJ22HYP38X0,CON_0KD6BYCRXMYG,24 Volume 3 PRD_0DJ22HYP38X0 Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_0QGSJ939WAR0,CON_0KD6BYCRXMYG,24 Volume 5 PRD_0QGSJ939WAR0 Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_0QV313R5076G,CON_0KD6BYCRXMYG,24 Volume 4 PRD_0QV313R5076G Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_0RED4F276QAG,CON_0KD6BYCRXMYG,1 Volume 1 PRD_0RED4F276QAG Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_1FG489GG06Y0,CON_0KD6BYCRXMYG,1 Volume 2 PRD_1FG489GG06Y0 Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_1HRER83WB060,CON_0KD6BYCRXMYG,1 Volume 3 PRD_1HRER83WB060 Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_1K19SJYMDS00,CON_0KD6BYCRXMYG,1 Volume 2 PRD_1K19SJYMDS00 Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_24YJ2BZYB9VG,CON_0KD6BYCRXMYG,1 Volume 3 PRD_24YJ2BZYB9VG Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_2CX74HDQ2ESG,CON_0KD6BYCRXMYG,24 Volume 1 PRD_2CX74HDQ2ESG Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_2FXMGJWACQ60,CON_0KD6BYCRXMYG,24 Volume 6 PRD_2FXMGJWACQ60 Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_2Q626JQB6TXG,CON_0KD6BYCRXMYG,1 Volume 1 PRD_2Q626JQB6TXG Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_2QN664PC0SD0,CON_0KD6BYCRXMYG,24 Volume 2 PRD_2QN664PC0SD0 Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_3075ZV2E244G,CON_0KD6BYCRXMYG,1 Volume 4 PRD_3075ZV2E244G Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_3KTYB8YG83K0,CON_0KD6BYCRXMYG,24 Volume 7 PRD_3KTYB8YG83K0 Yoko Nogiri CON_0KD6BYCRXMYG 24  
PRD_3VZAH45KZ7V0,CON_0KD6BYCRXMYG,1 Volume 2 PRD_3VZAH45KZ7V0 Yoko Nogiri CON_0KD6BYCRXMYG 1  
PRD_3VZAH45KZ7V0,CON_0KD6BYCRXMYG,2 Volume 2 PRD_3VZAH45KZ7V0 Yoko Nogiri CON_0KD6BYCRXMYG 2  

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