title: how to write inner join query in DQL(DOCTRINE) for select inside select
body: <p>i want to write this SQL query in DQL (DOCTRINE)</p>
  
  <pre><code>select &lt;cols&gt; from profile INNER JOIN (
   SELECT &lt;primary key cols&gt; FROM PROFILES
  WHERE x.sex='M' ORDER BY rating LIMIT 100000,10
  ) AS x USING (&lt;primary key cols&gt;);
  </code></pre>
  
  <p>Hey guys please help me </p>
  
  <p>any help will be appreciated</p>
  
  <p>thank you</p>