SQL for getting product image urls

[psusinbuts]

I want to make a SQL query to get image urls from a given product id, but i cant seem to find in what table are product_ids linked to resource_ids. Any help would be great.

Thanks

[abolabo]

you should find table resource_map in your database. There columns object_name (products) and object_id (product_id)