In order to migrate data between ERP systems, I need to rename images to conform to a specific format for the new system, coming from Magento. I'm going to write a script to automate this but need some data to start.
I'm able to pull sku, name and description using the query in this Post
Currently all the paths for file images are in the 'value' column of the
I'm wondering if there is a way to join the above query with the
catalog_product_entity_media_gallery table in order to retrieve the sku, name, description, and image file path.