title: Symfony Propel criteria
body: <p>Is there any possible way to convert the MySQL object into criteria object? I tried this query:</p>
  
  <pre><code>select 
    p.disrepid, 
    p.subject, p.body, 
    c.disrepid as disrepid1, 
    c.subject as subject1, 
    c.body as body1 
  from discusreply as p, discusreply as c 
  where p.distopid=' . $this-&gt;id . ' 
    and (c.disrepid = p.parentid or c.parentid = p.distopid) 
  order by p.disrepid ASC
  </code></pre>
  
  <p>I tried a lot for converting this query into a <code>Criteria</code>, But nothing happened. I want this criteria object for passing this into Pager class for completing the pagination.
  <code>$pager-&gt;setCriteria($c);</code>.</p>