I am working on a module to remove images of all deleted products, which is not the standard M2 behavior. My initial query to found images path still used by products was : $connection = $this->connection->getConnection(); $select = "SELECT {$connection->getTableName('catalog_product_entity_media_gallery')}.value" ." FROM {$connection->getTableName('catalog_product_entity_media_gallery_value_to_entity')}" ." , {$connection->getTableName('catalog_product_entity_media_gallery')}" ." WHERE {$connection->getTableName('catalog_product_entity_media_gallery_value_to_entity')}" ." […]