title: Link magento log_url_info table to products
body: <p>I want to create a report on the items which are viewed within my store. I have the relevant report writing and SQL skills, but am a little confused by the data within the log_url_info table.</p>
  
  <p>I understand that entries with a value in the url field such as 'http://www.mystore.com/catalog/product/view/id/526' demonstrate a visit to product with ID 526, but cannot see a simple way to link this data back to an individual product record in the relevant product tables, especially given the additional data also stored in this table.</p>
  
  <p>Anyone any ideas??</p>