title: It's possible to get a "friendly" URL using a SQL Query?
body: <p>I have a site (which is not my magento site) where I connect to magento's DB and use some SQL queries to show recent products. I know I should use the API, but is not the case now.</p>
  
  <p>I just append <code>"http://www.domain.com/catalog/product/view/id/"</code> to the product ids.</p>
  
  <p>It works fine, I just want to know if it's possible to get the same friendly urls for each product I get in the shop, like <code>http://www.domain.com/dvd/movies/matrix-3.html</code></p>
  
  <p>How can I do this?</p>