I am trying to run a query that returns all the latest tags that occurred in my friends photos.
Here is my request:
String query = "SELECT subject, created FROM photo_tag WHERE subject IN (SELECT uid2 FROM friend WHERE uid1 = me()) ORDER BY created DESC LIMIT 200";
The last 200 tags are expected to be returned.
Unfortunately, after watching the news, here are the first few results that I get (formatted SUBJECT to CREATED_TIME)
522274044 at Sun Sep 25 20:01:03 AEST 2011 522274044 at Sun Sep 25 20:00:26 AEST 2011 522274044 at Sun Sep 25 20:00:00 AEST 2011 522274044 at Sun Sep 25 20:00:00 AEST 2011 522274044 at Sun Sep 25 20:00:00 AEST 2011 522274044 at Sun Sep 25 20:00:00 AEST 2011 522274044 at Sun Sep 25 20:00:00 AEST 2011 521123280 at Sun Sep 25 16:39:19 AEST 2011 521123280 at Sun Sep 25 16:39:19 AEST 2011 522274044 at Sun Sep 25 15:00:04 AEST 2011 521342837 at Sun Sep 25 12:10:06 AEST 2011 521123280 at Sun Sep 25 11:20:45 AEST 2011 521123280 at Sun Sep 25 11:20:14 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011 521123280 at Sun Sep 25 11:16:51 AEST 2011
As you can see, there is a huge gap between 8:00 and 16:39 PM, and checking my news feed, during this time there are ALL PAYMENTS for the photos that should be listed here. Is my FQL query correct? or facebook servers just don't handle these types of requests. Also later on the list:
512328700 at Sun Jul 24 00:30:02 AEST 2011 523619736 at Sat Jul 23 17:36:37 AEST 2011 521342837 at Tue Jul 19 12:23:32 AEST 2011 519156948 at Fri Jul 15 15:08:11 AEST 2011
More massive inconsistencies. Is there any explanation for this? Thank you for your help!
UPDATE: Of all 200 results, I get only 10 unique names of UPDATE2 objects: I tried to request a bunch of names that were not in this list of 10 unique names above, and they led to the photos being tagged in them, in conclusion, their names do not appear from the larger query above, privacy, or something else. So maybe this is a server-side affair?
Rhys davis
source share