I am trying to display WC product images (thumbnails) or just get the url to that image from database. But I can’t seem to find the column where the url are stored with the following. One thing I want my query to have is ability to select images of a certain category. I know _wp_attached_file is the meta key and through its associated post ID I can grab the image path but not sure how to write it.
select * from wp_posts where post_type = "product"
All helps appreciated