BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_296TN3KRAEEG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02AS5VS9DZ0G,CON_296TN3KRAEEG,2 Volume 13 PRD_02AS5VS9DZ0G Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_09514E0C5Q80,CON_296TN3KRAEEG,2 Volume 7 PRD_09514E0C5Q80 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0DPZAH61P62G,CON_296TN3KRAEEG,2 Volume 10 PRD_0DPZAH61P62G Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0Q046HCHQ3MG,CON_296TN3KRAEEG,2 Volume 5 PRD_0Q046HCHQ3MG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0SG5CXN6WCWG,CON_296TN3KRAEEG,2 Volume 8 PRD_0SG5CXN6WCWG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0TW5R1SP403G,CON_296TN3KRAEEG,2 Volume 6 PRD_0TW5R1SP403G Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0VPMG4EVK2VG,CON_296TN3KRAEEG,2 Volume 2 PRD_0VPMG4EVK2VG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0VSJ06SJCEYG,CON_296TN3KRAEEG,2 Volume 1 PRD_0VSJ06SJCEYG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0WDATCQG30Z0,CON_296TN3KRAEEG,2 Volume 11 PRD_0WDATCQG30Z0 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_0Y0AVP0J8KN0,CON_296TN3KRAEEG,2 Volume 7 PRD_0Y0AVP0J8KN0 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_1B724E4Y5600,CON_296TN3KRAEEG,2 Volume 4 PRD_1B724E4Y5600 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_1CWPX674HBWG,CON_296TN3KRAEEG,2 Volume 4 PRD_1CWPX674HBWG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_1FNJQ1601570,CON_296TN3KRAEEG,2 Volume 3 PRD_1FNJQ1601570 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_1G4BVWE8CP50,CON_296TN3KRAEEG,2 Volume 9 PRD_1G4BVWE8CP50 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_1S1BD2SG7ZYG,CON_296TN3KRAEEG,2 Volume 5 PRD_1S1BD2SG7ZYG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_24DN1ZBDZJH0,CON_296TN3KRAEEG,2 Volume 9 PRD_24DN1ZBDZJH0 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_2AN52V73WF5G,CON_296TN3KRAEEG,2 Volume 10 PRD_2AN52V73WF5G Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_2N0ERFQG80W0,CON_296TN3KRAEEG,2 Volume 2 PRD_2N0ERFQG80W0 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_2WN4JD40K3YG,CON_296TN3KRAEEG,2 Volume 3 PRD_2WN4JD40K3YG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_2ZK5YZP7SN1G,CON_296TN3KRAEEG,2 Volume 1 PRD_2ZK5YZP7SN1G Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_3DQ2G9Y3FAE0,CON_296TN3KRAEEG,2 Volume 8 PRD_3DQ2G9Y3FAE0 Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_3RE88WBR5DTG,CON_296TN3KRAEEG,2 Volume 12 PRD_3RE88WBR5DTG Kotaro Yamada CON_296TN3KRAEEG 2  
PRD_3RNSSR20PTCG,CON_296TN3KRAEEG,2 Volume 6 PRD_3RNSSR20PTCG Kotaro Yamada CON_296TN3KRAEEG 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 8.16ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS