BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_3NPB6ZTJPWA0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_019VDE1JY2RG,CON_3NPB6ZTJPWA0,1 Volume 8 PRD_019VDE1JY2RG Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_019VDE1JY2RG,CON_3NPB6ZTJPWA0,2 Volume 8 PRD_019VDE1JY2RG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0A76YG1ETW40,CON_3NPB6ZTJPWA0,2 Volume 2 PRD_0A76YG1ETW40 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0BXVDFHG1G10,CON_3NPB6ZTJPWA0,2 Volume 6 PRD_0BXVDFHG1G10 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0CYRD7QNZHR0,CON_3NPB6ZTJPWA0,1 Volume 1 PRD_0CYRD7QNZHR0 Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_0CYRD7QNZHR0,CON_3NPB6ZTJPWA0,2 Volume 1 PRD_0CYRD7QNZHR0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0EJBR2KTDZ00,CON_3NPB6ZTJPWA0,2 Volume 7 PRD_0EJBR2KTDZ00 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0F07X87C8X30,CON_3NPB6ZTJPWA0,1 Volume 2 PRD_0F07X87C8X30 Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_0F07X87C8X30,CON_3NPB6ZTJPWA0,2 Volume 2 PRD_0F07X87C8X30 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0N20REDYR9V0,CON_3NPB6ZTJPWA0,2 Volume 11 PRD_0N20REDYR9V0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0PDGEVKMWAM0,CON_3NPB6ZTJPWA0,2 Volume 12 PRD_0PDGEVKMWAM0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_0PY5EYJA2J20,CON_3NPB6ZTJPWA0,2 Volume 3 PRD_0PY5EYJA2J20 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_151XNWD274K0,CON_3NPB6ZTJPWA0,2 Volume 1 PRD_151XNWD274K0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_1KN0GW81VA7G,CON_3NPB6ZTJPWA0,1 Volume 7 PRD_1KN0GW81VA7G Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_1KN0GW81VA7G,CON_3NPB6ZTJPWA0,2 Volume 7 PRD_1KN0GW81VA7G Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_27NWFSR32ZDG,CON_3NPB6ZTJPWA0,1 Volume 6 PRD_27NWFSR32ZDG Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_27NWFSR32ZDG,CON_3NPB6ZTJPWA0,2 Volume 6 PRD_27NWFSR32ZDG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_2AACSCT5EYCG,CON_3NPB6ZTJPWA0,1 Volume 4 PRD_2AACSCT5EYCG Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_2AACSCT5EYCG,CON_3NPB6ZTJPWA0,2 Volume 4 PRD_2AACSCT5EYCG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_2EZ8C0ZTHCH0,CON_3NPB6ZTJPWA0,1 Volume 5 PRD_2EZ8C0ZTHCH0 Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_2EZ8C0ZTHCH0,CON_3NPB6ZTJPWA0,2 Volume 5 PRD_2EZ8C0ZTHCH0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_2MSNF5A51790,CON_3NPB6ZTJPWA0,2 Volume 9 PRD_2MSNF5A51790 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_39NA3A02Q5TG,CON_3NPB6ZTJPWA0,1 Volume 3 PRD_39NA3A02Q5TG Hajime Segawa CON_3NPB6ZTJPWA0 1  
PRD_39NA3A02Q5TG,CON_3NPB6ZTJPWA0,2 Volume 3 PRD_39NA3A02Q5TG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_3K82WZW1QYPG,CON_3NPB6ZTJPWA0,2 Volume 8 PRD_3K82WZW1QYPG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_3KCZ4Z4CTCM0,CON_3NPB6ZTJPWA0,2 Volume 5 PRD_3KCZ4Z4CTCM0 Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_3T46938Q2GHG,CON_3NPB6ZTJPWA0,2 Volume 10 PRD_3T46938Q2GHG Hajime Segawa CON_3NPB6ZTJPWA0 2  
PRD_3TKY153S2AT0,CON_3NPB6ZTJPWA0,2 Volume 4 PRD_3TKY153S2AT0 Hajime Segawa CON_3NPB6ZTJPWA0 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 9.595ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS