title: Unknown column in order clause
body: <p><code>#1054 - Unknown column 'default_ps_products.manufacturer_id' in 'order clause'</code></p>
  
  <p>Why am I getting the above error with the statement below it works fine without the <code>p</code> in the statement and I am not using an order clause?</p>
  
  <pre><code>SELECT * FROM `default_ps_products` p WHERE p.`manufacturer_id` = 2
  </code></pre>