OK, so the title mainly says it all. I want to get the number of likes that I gave to people, for which I am doing a query like:
SELECT object_id FROM like WHERE user_id = me()
However, for large accounts, this always returns 100, even if I add LIMIT 1000
at the end of the query. If I make the limit lower than 100 (eg. 50), it will only show 50 results, so LIMIT
works...
Is anyone aware of a limitation that Facebook imposes on the number of returned results in this table? I am mainly waiting for some Facebook engineers to help me with this, but if someone has encountered this issue, feel free to help me out.
EDIT: if I make the following query, it returns 1000 rows, but this query is useless, since I want to get all likes that I gave, not that a object received.
SELECT user_id FROM like WHERE object_id="10150146071791729" LIMIT 1000 // taken from a FQL example page