How to pull product urls from the mysql database

Hi,

Is there are a way that the product ulrs can be pulled out of the mysql database?

Thanks

urls are not stored. They are created based on the server details from the config and product_id from the database

http://www.mysite.com/index.php?product_id= <product id>