BookWalker

home / database

product_contributors

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

27 rows where contributor_id = "CON_31Z374BXBA90"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00BAXVA2FD0G,CON_31Z374BXBA90,1 Chapter 3 PRD_00BAXVA2FD0G Naho Sagara CON_31Z374BXBA90 1  
PRD_01068Z8J647G,CON_31Z374BXBA90,1 Chapter 14 PRD_01068Z8J647G Naho Sagara CON_31Z374BXBA90 1  
PRD_02KQXCFFT50G,CON_31Z374BXBA90,1 Chapter 16 PRD_02KQXCFFT50G Naho Sagara CON_31Z374BXBA90 1  
PRD_05PPVJAM236G,CON_31Z374BXBA90,1 Chapter 12 PRD_05PPVJAM236G Naho Sagara CON_31Z374BXBA90 1  
PRD_0VCM06K3J72G,CON_31Z374BXBA90,1 Chapter 20 PRD_0VCM06K3J72G Naho Sagara CON_31Z374BXBA90 1  
PRD_0XP9A71CWGW0,CON_31Z374BXBA90,1 Chapter 5 PRD_0XP9A71CWGW0 Naho Sagara CON_31Z374BXBA90 1  
PRD_0XTVJ88R3E1G,CON_31Z374BXBA90,1 Chapter 4 PRD_0XTVJ88R3E1G Naho Sagara CON_31Z374BXBA90 1  
PRD_0ZX4KSD5Y61G,CON_31Z374BXBA90,1 Chapter 18 PRD_0ZX4KSD5Y61G Naho Sagara CON_31Z374BXBA90 1  
PRD_1341M7PNBMFG,CON_31Z374BXBA90,1 Chapter 2 PRD_1341M7PNBMFG Naho Sagara CON_31Z374BXBA90 1  
PRD_1H6YCZ79F980,CON_31Z374BXBA90,1 Chapter 5 PRD_1H6YCZ79F980 Naho Sagara CON_31Z374BXBA90 1  
PRD_1NQEZJ0KB8F0,CON_31Z374BXBA90,1 Chapter 3 PRD_1NQEZJ0KB8F0 Naho Sagara CON_31Z374BXBA90 1  
PRD_1R5S952NQQE0,CON_31Z374BXBA90,1 Chapter 1 PRD_1R5S952NQQE0 Naho Sagara CON_31Z374BXBA90 1  
PRD_1W9YJH29FV00,CON_31Z374BXBA90,1 Chapter 7 PRD_1W9YJH29FV00 Naho Sagara CON_31Z374BXBA90 1  
PRD_1WK42KD7S7B0,CON_31Z374BXBA90,1 Chapter 6 PRD_1WK42KD7S7B0 Naho Sagara CON_31Z374BXBA90 1  
PRD_20RZQPYCR5G0,CON_31Z374BXBA90,1 Chapter 15 PRD_20RZQPYCR5G0 Naho Sagara CON_31Z374BXBA90 1  
PRD_279E19VQ44Q0,CON_31Z374BXBA90,1 Chapter 13 PRD_279E19VQ44Q0 Naho Sagara CON_31Z374BXBA90 1  
PRD_2BZSCWNS03P0,CON_31Z374BXBA90,1 Chapter 11 PRD_2BZSCWNS03P0 Naho Sagara CON_31Z374BXBA90 1  
PRD_2SNWSF20G7J0,CON_31Z374BXBA90,1 Chapter 19 PRD_2SNWSF20G7J0 Naho Sagara CON_31Z374BXBA90 1  
PRD_2WAF43WAW6H0,CON_31Z374BXBA90,1 Chapter 17 PRD_2WAF43WAW6H0 Naho Sagara CON_31Z374BXBA90 1  
PRD_2Z96HYPFYGCG,CON_31Z374BXBA90,1 Chapter 8 PRD_2Z96HYPFYGCG Naho Sagara CON_31Z374BXBA90 1  
PRD_343RR33WNKY0,CON_31Z374BXBA90,1 Chapter 1 PRD_343RR33WNKY0 Naho Sagara CON_31Z374BXBA90 1  
PRD_3GSQVPM41ARG,CON_31Z374BXBA90,1 Chapter 6 PRD_3GSQVPM41ARG Naho Sagara CON_31Z374BXBA90 1  
PRD_3QBFV4E1S8V0,CON_31Z374BXBA90,1 Chapter 9 PRD_3QBFV4E1S8V0 Naho Sagara CON_31Z374BXBA90 1  
PRD_3QE659PED9ZG,CON_31Z374BXBA90,1 Chapter 4 PRD_3QE659PED9ZG Naho Sagara CON_31Z374BXBA90 1  
PRD_3VJ6ENH25XHG,CON_31Z374BXBA90,1 Chapter 10 PRD_3VJ6ENH25XHG Naho Sagara CON_31Z374BXBA90 1  
PRD_3VWPGWKG98YG,CON_31Z374BXBA90,1 Chapter 2 PRD_3VWPGWKG98YG Naho Sagara CON_31Z374BXBA90 1  
PRD_3ZD16MY1CAV0,CON_31Z374BXBA90,1 Chapter 7 PRD_3ZD16MY1CAV0 Naho Sagara CON_31Z374BXBA90 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.932ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS