FQL语句获取两个人的照片（查询不可索引错误）

Question

SELECT pid FROM photo WHERE me() and $otherPerson IN ( SELECT subject FROM photo_tag WHERE pid=pid ) ORDER BY created DESC LIMIT 1

我正在尝试获取一张包含两个用户标签的照片（$otherPerson 被替换为用户 ID）。此查询返回：

604 Your statement is not indexable. The WHERE clause must contain an indexable column. Such columns are marked with * in the tables linked from http://wiki.developers.facebook.com/index.php/FQL_Tables

关于如何完成这项工作有什么想法吗？

更新：

我目前正在使用此查询，但我觉得好像有更好的方法可以进行。

SELECT pid, src_big FROM photo
 WHERE pid IN (
                 SELECT pid FROM photo_tag 
                 WHERE subject=$otherGuy
                 AND pid in (
                                SELECT pid FROM photo_tag WHERE subject=me()
                             )
               )

Answer 1

这应该可以解决问题。

SELECT pid, src_big
FROM photo
WHERE pid IN(
    SELECT pid  
    FROM photo_tag
    WHERE subject = me()
) 
AND pid IN(
    SELECT pid  
    FROM photo_tag
    WHERE subject = <friend_user_id>
)

Answer 2

怎么样：

  SELECT pid
    FROM photo
   WHERE me() IN (SELECT subject
                    FROM photo_tag
                   WHERE pid=pid)
     AND $otherPerson IN (SELECT subject
                            FROM photo_tag
                           WHERE pid=pid)
ORDER BY created DESC
   LIMIT 1

另外，pid=pid 是什么意思？

Answer 3

我尝试了其他解决方案并遇到了问题 - 如果您的朋友将其隐私设置设置为禁止应用程序访问他的照片，则以下 FQL 查询将返回一个空表：

"SELECT pid FROM photo_tag WHERE subject = <friend_user_id>"

我通过使用以下多重查询解决了此问题：

"query1" : "SELECT subject, pid FROM photo_tag WHERE pid IN (SELECT pid FROM photo_tag WHERE subject=me())"
"query2" : "SELECT pid FROM #query1 WHERE subject= <friend_user_id>"