title: Magento Inner Join and Ordering
body: <p>On Magento catalog page, there's a join attached to collection. The join works perfectly. </p>
  
  <pre><code>$products-&gt;joinTable(
      array('as_name' =&gt; 'some_table'),
      'product_id=entity_id',
      array('some_var' =&gt; 'variable'),
      array('store_id' =&gt; array('eq' =&gt; '1')),
      'inner'
  );
  </code></pre>
  
  <p>If I was to run the query raw, <code>some_var</code> column will have correct values. Also, if I add <code>ORDER BY some_var DESC</code> raw, it will order correctly. However, if I use Magento's <code>$products-&gt;setOrder('some_var', 'desc');</code> the query Magento submits becomes:</p>
  
  <pre><code>ORDER BY `e`.`some_var` DESC
  </code></pre>
  
  <p>How do I get Magento to not add <code>"e"</code> ? some_var is not part of that select, and should be <code>as_name</code>.</p>