mysql query to generate product url with images ?
 

Basically I want to generate image site map for google since there is no module available for it at this time.
I want to generate following results.
http://www.mysite.com/product-url.html
http://www.mysite.com/images/T/product-thumbnail.jpg
http://www.mysite.com/images/D/product-detil-image-1.jpg
http://www.mysite.com/images/D/product-detil-image-2.jpg

Once I will get the result, I can export it into excel & will add necessary xml code to make it valid xml site map for google images.

If any one has got better idea then please suggest me :)