It looks like I’ve managed to work it out.
I needed to:
- JOIN to wp_posts
With the link keys:
- TABLE : wp_postmeta
- column : meta_key
- TABLE : wp_posts
- column : ID
SELECT * FROM wp_terms wpt LEFT JOIN wp_termmeta wptm ON wptm.term_id = wpt.term_id AND wptm.meta_key = 'thumbnail_id' LEFT JOIN wp_postmeta wppm ON wppm.post_id = wptm.meta_value AND wppm.meta_key = 'wp_attached_file' LEFT JOIN wp_posts wpp ON wpp.ID = wptm.meta_value WHERE wpt.term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy='product_cat')
That’s given me the listing I want.
I now have a column:
| category name | category slug | … | … | guid |
That has the image url:
I am now going to EXPORT to .CSV
Then I’ll try to work out how to get to my end goal:
My end goal is to do an SQL update to associate images with my product
categories. I have 1,400 product categories and counting – half-way
though importing 31,000 products. Probably 60% of the subcategories
share the same images. Doing the image links via the Admin GUI is too
So my aim will be to:
- find the thumbnail_id
- for each common image
- shared by each multiple ‘common’ Product Category
Then I should be able to update that thumbnail_id into each common Product Category directly in the database.