title: Zend framework order before group
body: <p>Any one have a example how to order before group with leftjoin in zend paginator adapter ?</p>
  
  <pre><code>new Zend_Paginator_Adapter_DbSelect($this-&gt;db-&gt;select()
  -&gt;from(array( 'a' =&gt; $this-&gt;prefix.'contest' ), array('id'))
  -&gt;joinLeft(array( 'b' =&gt; $this-&gt;prefix.'logo_to_contest'),'a.id=b.contest_id', array('img'))
  -&gt;group('a.id')
  -&gt;order('a.end','a.date_start DESC','b.id RAND()')
  )
  </code></pre>