title: Get collection query string
body: <p>I'm using the following code to get some data from a table.</p>
  
  <pre><code>    $collection = Mage::getModel('bannerslider/bannerslider')-&gt;getCollection()
          -&gt;addFieldToFilter('status',1)
          -&gt;addFieldToFilter('is_home',$this-&gt;_display)
      -&gt;addOrder('position', 'ASC')
          ;
  </code></pre>
  
  <p>Just for my curiosity, I want to check the query that is executed here and I'm echo using this code</p>
  
  <pre><code>$collection-&gt;printLogQuery(true);
  
  var_dump((string)$collection-&gt;getSelect());
  </code></pre>
  
  <p>Now, my problem is that the string</p>
  
  <pre><code>SELECT `main_table`.* FROM `bannerslider` AS `main_table` WHERE (status = '1') AND (is_home = '0')
  </code></pre>
  
  <p>is not showing my last condition, addOrder but the collection is really ordered by position field, I checked that.</p>
  
  <p>What I don't understand is why the order condition is not visible in the query.
  Thank you.</p>