BookWalker

home / database

product_contributors

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

39 rows where contributor_id = "CON_2Z5R8HD2YWG0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0737TEQ2QZV0,CON_2Z5R8HD2YWG0,1 Volume 20 PRD_0737TEQ2QZV0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_077G2FZDTDRG,CON_2Z5R8HD2YWG0,1 Volume 18 PRD_077G2FZDTDRG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0BM3D2RG6CZG,CON_2Z5R8HD2YWG0,1 Volume 16 PRD_0BM3D2RG6CZG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0EAKRNTT2BYG,CON_2Z5R8HD2YWG0,1 Volume 14 PRD_0EAKRNTT2BYG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0PF7XF5KE2NG,CON_2Z5R8HD2YWG0,1 Volume 11 PRD_0PF7XF5KE2NG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0RWY2QJ79RYG,CON_2Z5R8HD2YWG0,1 Volume 2 PRD_0RWY2QJ79RYG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0SJ6VN1ZP0VG,CON_2Z5R8HD2YWG0,1 Volume 7 PRD_0SJ6VN1ZP0VG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_0TQZG0CKAPC0,CON_2Z5R8HD2YWG0,1 Volume 1 PRD_0TQZG0CKAPC0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_13F2761KM730,CON_2Z5R8HD2YWG0,1 Volume 22 PRD_13F2761KM730 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_13KZF79YTN0G,CON_2Z5R8HD2YWG0,1 Volume 2 PRD_13KZF79YTN0G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1AJDWDXZW510,CON_2Z5R8HD2YWG0,1 Volume 1 PRD_1AJDWDXZW510 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1H50DTEV7VZ0,CON_2Z5R8HD2YWG0,1 Volume 30 PRD_1H50DTEV7VZ0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1H9JNVP6A9WG,CON_2Z5R8HD2YWG0,1 Volume 10 PRD_1H9JNVP6A9WG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1JMH27CGVWR0,CON_2Z5R8HD2YWG0,1 Volume 2 PRD_1JMH27CGVWR0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1JV2A8MWEAXG,CON_2Z5R8HD2YWG0,1 Volume 12 PRD_1JV2A8MWEAXG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1NVGZD8X3TY0,CON_2Z5R8HD2YWG0,1 Volume 28 PRD_1NVGZD8X3TY0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1NYD7EG8P83G,CON_2Z5R8HD2YWG0,1 Volume 8 PRD_1NYD7EG8P83G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1QB5FGWGP06G,CON_2Z5R8HD2YWG0,1 Volume 5 PRD_1QB5FGWGP06G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1R83A0A7FSX0,CON_2Z5R8HD2YWG0,1 Volume 26 PRD_1R83A0A7FSX0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1RCXJ1DJJQ2G,CON_2Z5R8HD2YWG0,1 Volume 6 PRD_1RCXJ1DJJQ2G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1VSNS3YTJF5G,CON_2Z5R8HD2YWG0,1 Volume 4 PRD_1VSNS3YTJF5G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1VTRH2QFFH00,CON_2Z5R8HD2YWG0,1 Volume 3 PRD_1VTRH2QFFH00 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1WXCXMFMYP1G,CON_2Z5R8HD2YWG0,1 Volume 4 PRD_1WXCXMFMYP1G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1WYKNK49BRW0,CON_2Z5R8HD2YWG0,1 Volume 24 PRD_1WYKNK49BRW0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_1YE44PRWYE4G,CON_2Z5R8HD2YWG0,1 Volume 1 PRD_1YE44PRWYE4G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_26Y895C8WD90,CON_2Z5R8HD2YWG0,1 Volume 3 PRD_26Y895C8WD90 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_29YYYA09HX9G,CON_2Z5R8HD2YWG0,1 Volume 17 PRD_29YYYA09HX9G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_2CKVHY5Z0AE0,CON_2Z5R8HD2YWG0,1 Volume 15 PRD_2CKVHY5Z0AE0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_2G7Z46VE0260,CON_2Z5R8HD2YWG0,1 Volume 13 PRD_2G7Z46VE0260 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_2NRNGVJ8SFDG,CON_2Z5R8HD2YWG0,1 Volume 3 PRD_2NRNGVJ8SFDG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_2VAY1CPT8040,CON_2Z5R8HD2YWG0,1 Volume 9 PRD_2VAY1CPT8040 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_2ZMW4Y8H1H5G,CON_2Z5R8HD2YWG0,1 Volume 25 PRD_2ZMW4Y8H1H5G Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_31MASGGGJ7JG,CON_2Z5R8HD2YWG0,1 Volume 21 PRD_31MASGGGJ7JG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3455B3JTY6HG,CON_2Z5R8HD2YWG0,1 Volume 19 PRD_3455B3JTY6HG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3H3JN6DK81Q0,CON_2Z5R8HD2YWG0,1 Volume 6 PRD_3H3JN6DK81Q0 Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3QJ864SR5TEG,CON_2Z5R8HD2YWG0,1 Volume 29 PRD_3QJ864SR5TEG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3T0RHQV21SDG,CON_2Z5R8HD2YWG0,1 Volume 27 PRD_3T0RHQV21SDG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3X7TEXQE9RKG,CON_2Z5R8HD2YWG0,1 Volume 23 PRD_3X7TEXQE9RKG Karuho Shiina CON_2Z5R8HD2YWG0 1  
PRD_3XAMPYYSWPH0,CON_2Z5R8HD2YWG0,1 Volume 5 PRD_3XAMPYYSWPH0 Karuho Shiina CON_2Z5R8HD2YWG0 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 9.212ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS