title: Get all of a user's likes (all of them) with FQL
body: <p>I'm trying to get ALL of a user's likes with FQL. Following is my research including what I've tried and the problems with each attempt.</p>
  
  <p>1) The most simple method would be to query the table on the uid. So this returns 57 (for me) likes on other's stream.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT object_id, post_id, user_id
  FROM like
  WHERE user_id = me()
  </code></pre>
  
  <p>XML looks like this (note unexplained absence of post_id)</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;like&gt;
      &lt;object_id&gt;10150695050005313&lt;/object_id&gt;
      &lt;post_id&gt;&lt;/post_id&gt;
      &lt;user_id&gt;xxxxxxxxxxx&lt;/user_id&gt;
  &lt;/like&gt;
  </code></pre>
  
  <p>The above seems like a logical step, but Facebook <a href="http://developers.facebook.com/docs/reference/fql/like/" rel="nofollow">doesn't index the user_id field</a> so I can't use the following code to get further details. This code does not work.</p>
  
  
  
  <pre class="lang-sql prettyprint-override"><code>SELECT post_id, message
  FROM stream
  WHERE post_id IN (
      SELECT object_id, post_id, user_id
      FROM like
      WHERE user_id = me()
  )
  </code></pre>
  
  <p>2) Using the Graph API: /me/likes/ retrieves information on 95 fan pages, but not from photos, videos, links, or offline content. The full url is: <a href="https://graph.facebook.com/me/likes?access_token=" rel="nofollow">https://graph.facebook.com/me/likes?access_token=</a> </p>
  
  <p>For example: </p>
  
  <pre class="lang-sql prettyprint-override"><code>{
  "data": [
    {
       "name": "BStU",
       "category": "Organization",
       "id": "136978696319967",
       "created_time": "2011-06-29T12:09:17+0000"
    },
    {
       "name": "Euchre",
       "category": "Interest",
       "id": "112355915446795",
       "created_time": "2011-06-29T12:06:07+0000"
    },
  </code></pre>
  
  <p>3) This FQL returns the same as the above code, 95 fan pages:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT page_id,name
  FROM page
  WHERE page_id IN (
      SELECT page_id
      FROM page_fan
      WHERE uid=me()
  )
  </code></pre>
  
  <p>So to summarize, ideally I would be able to return every like for a user, regardless of the object. I'm willing to move forward with a mixture of fan pages and stream posts though, if I can return them all, along with the data, with one FQL query.</p>
  
  <p>Any suggestions? I will add that I'm trying to do this without using the REST API because it is going to be degraded (someday?) so therefore using <a href="http://developers.facebook.com/docs/reference/rest/fql.multiquery/" rel="nofollow">fql.multiquery</a> is not an option.</p>