title: How to get product details from Magento Database with mysql query?
body: <p>I just want to know about how to get product details from magento database tables. I know how to run MySQL Query and get results from database. But the problem is magento database, I don't know which tables should I target.</p>
  
  <p>I need to retrieve:</p>
  
  <ol>
  <li>SKU</li>
  <li>Name</li>
  <li>Short Description</li>
  <li>Thumbnail</li>
  <li>Category ID</li>
  </ol>
  
  <p>But the problem is that magento have a huge database and I cannot find from which tables I can get these details.</p>
  
  <p>I just need tables name from which I can get these details. Because I will be getting these details in a PHP file out of magento. So will be using mysql_query("SELECT * FROM which_table");</p>
  
  <p>Please help :)</p>
  
  <p>Omer</p>