title: FQL query limit
body: <p>I was trying this simple query on the Graph Explorer</p>
  
  <pre><code>SELECT eid FROM event_member 
             WHERE (uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) 
                    OR uid = me())
  </code></pre>
  
  <p>and it returns "error: Request Failed."</p>
  
  <p>Then, I started reading here and some forums and it had to do with the limits, so I've tried limiting by 20 my friend list and it worked.</p>
  
  <p>Which is the limit? and where (the query, or the results given)? There's nothing in the documentation as far as I know.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>What if I order my whole friends by <code>mutual_friend_count</code> and then limit by 200? I also added <code>start_time&gt;now()</code>. It's not the best way to find the closest friends, but it doesn't need permissions to access your stream (to check likes and comments from friends).</p>
  
  <pre><code>SELECT eid FROM event_member 
  WHERE (uid = me() 
  OR uid IN (SELECT uid FROM user 
             WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()
                           ORDER BY mutual_friend_count DESC) 
             LIMIT 200)
         )
  AND start_time &gt; now()
  </code></pre>
  
  <ol>
  <li>Is it too many queries inside another one? They are three actually.</li>
  <li>It isn't efficent
  in some cases. For example, in my case, the top mutual friends lives
  in my hometown, and I'm interested in events from my actual city.</li>
  </ol>
  
  <p>Imagine I limit the events retrieved by only 5 per user. It shouldn't be so hard ONLY IF the user had a list of upcoming events he/she is attending/unsure. </p>
  
  <p>For example, doing <code>graph.facebook.com/user-id/events</code> "seems" to work like that.</p>
  
  <p>However, I guess reading from event_member table it's not so easy because it would traversing a large database of events and checking one by one if any friend of mine is in there. Am I wrong?</p>