title: How to convert the SQL query to mongodb query
body: <p>I am using MongoDB Atlas in my project. I tried to build the query but i got some issues.</p>
  <p><a href="https://i.stack.imgur.com/9YWp7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9YWp7.jpg" alt="enter image description here" /></a></p>
  <pre class="lang-sql prettyprint-override"><code>select top 20 * 
  from users 
  where _id not in (select following=0
                       from users 
                       where _id = myuserid)
  </code></pre>
  <p>I tried to convert the query but I can't.</p>
  <pre><code>&quot;{\&quot;collection\&quot;:\&quot;users\&quot;,\&quot;stages\&quot;:[{\&quot;$match\&quot;:{\&quot;$and\&quot;:[{\&quot;status\&quot;:\&quot;active\&quot;},{\&quot;_id\&quot;:{\&quot;$ne\&quot;:{\&quot;$oid\&quot;:[{\&quot;$match\&quot;:[{\&quot;_id\&quot;:{\&quot;$oid\&quot;:\&quot;%%args.user\&quot;}},{\&quot;following\&quot;:{\&quot;$size\&quot;:0}}]},{\&quot;$project\&quot;:{\&quot;_id\&quot;:1}}]}}}]}}]}&quot;
  </code></pre>
  <p>Can you please help me out with the solution?.</p>
  <p>Thanks in advance.</p>