BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_10T4BG14JSY0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_021E06BTA3YG,CON_10T4BG14JSY0,1 Volume 29 PRD_021E06BTA3YG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_0549XC76J1WG,CON_10T4BG14JSY0,1 Volume 25 PRD_0549XC76J1WG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_05BHZPACVEB0,CON_10T4BG14JSY0,1 Volume 37 PRD_05BHZPACVEB0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_06QYKS5WP2XG,CON_10T4BG14JSY0,1 Volume 9 PRD_06QYKS5WP2XG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_0AYH5ACWJQM0,CON_10T4BG14JSY0,1 Volume 28 PRD_0AYH5ACWJQM0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_0CB8VJ2JTF2G,CON_10T4BG14JSY0,1 Volume 22 PRD_0CB8VJ2JTF2G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_0MDWRDJ466SG,CON_10T4BG14JSY0,1 Volume 18 PRD_0MDWRDJ466SG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_0W4142NHCE80,CON_10T4BG14JSY0,1 Volume 36 PRD_0W4142NHCE80 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_111V5J3RVFQG,CON_10T4BG14JSY0,1 Volume 33 PRD_111V5J3RVFQG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_11GMA5HQJ94G,CON_10T4BG14JSY0,1 Volume 10 PRD_11GMA5HQJ94G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1414NRKSY8BG,CON_10T4BG14JSY0,1 Volume 8 PRD_1414NRKSY8BG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_18QQ7BD3TQAG,CON_10T4BG14JSY0,1 Volume 6 PRD_18QQ7BD3TQAG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1GSV56WN6E1G,CON_10T4BG14JSY0,1 Volume 20 PRD_1GSV56WN6E1G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1Q7C0QF091XG,CON_10T4BG14JSY0,1 Volume 2 PRD_1Q7C0QF091XG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1QBAYNVJBC8G,CON_10T4BG14JSY0,1 Volume 32 PRD_1QBAYNVJBC8G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1X25RJMDPA5G,CON_10T4BG14JSY0,1 Volume 12 PRD_1X25RJMDPA5G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_1YER5YJR7X10,CON_10T4BG14JSY0,1 Volume 16 PRD_1YER5YJR7X10 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_20EPTGTZ82E0,CON_10T4BG14JSY0,1 Volume 30 PRD_20EPTGTZ82E0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_25YTFTD7AWK0,CON_10T4BG14JSY0,1 Volume 35 PRD_25YTFTD7AWK0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_26MBXXAQACS0,CON_10T4BG14JSY0,1 Volume 34 PRD_26MBXXAQACS0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2B97FNERDJEG,CON_10T4BG14JSY0,1 Volume 26 PRD_2B97FNERDJEG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2BAA7M7D7490,CON_10T4BG14JSY0,1 Volume 27 PRD_2BAA7M7D7490 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2FZQS8829HDG,CON_10T4BG14JSY0,1 Volume 23 PRD_2FZQS8829HDG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2KP5NG1WW7B0,CON_10T4BG14JSY0,1 Volume 21 PRD_2KP5NG1WW7B0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2R7YJDWM829G,CON_10T4BG14JSY0,1 Volume 31 PRD_2R7YJDWM829G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_2XNN7WH9SN9G,CON_10T4BG14JSY0,1 Volume 14 PRD_2XNN7WH9SN9G Tomohito Oda CON_10T4BG14JSY0 1  
PRD_33BDHV6JMAN0,CON_10T4BG14JSY0,1 Volume 11 PRD_33BDHV6JMAN0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3AEFE12YW8V0,CON_10T4BG14JSY0,1 Volume 7 PRD_3AEFE12YW8V0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3DEX37PZHRVG,CON_10T4BG14JSY0,1 Volume 4 PRD_3DEX37PZHRVG Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3EWZSNW0RQT0,CON_10T4BG14JSY0,1 Volume 5 PRD_3EWZSNW0RQT0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3H13YFFT4EH0,CON_10T4BG14JSY0,1 Volume 1 PRD_3H13YFFT4EH0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3J9NWT2SF2F0,CON_10T4BG14JSY0,1 Volume 24 PRD_3J9NWT2SF2F0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3JGKCWDQRFJ0,CON_10T4BG14JSY0,1 Volume 3 PRD_3JGKCWDQRFJ0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3NCMS1Y5Q0D0,CON_10T4BG14JSY0,1 Volume 19 PRD_3NCMS1Y5Q0D0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3R42MNB6CCQ0,CON_10T4BG14JSY0,1 Volume 15 PRD_3R42MNB6CCQ0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3SX74MRFKFC0,CON_10T4BG14JSY0,1 Volume 17 PRD_3SX74MRFKFC0 Tomohito Oda CON_10T4BG14JSY0 1  
PRD_3WTX68588BP0,CON_10T4BG14JSY0,1 Volume 13 PRD_3WTX68588BP0 Tomohito Oda CON_10T4BG14JSY0 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.253ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS