fql.multiquery不像预期的那样工作

Question

$pairs = $facebook->api(array(
        'method' => 'fql.multiquery',
        'queries' => array(
            'query1' => 'SELECT uid1 FROM friend WHERE uid2 = me()',
            'query2' => 'SELECT uid1, uid2 FROM friend WHERE uid1 IN (#query1) AND uid2 IN (#query1)'
        )
));

这给了我一个Parser error: unexpected '#query1' at position 45.错误，我不明白。我以为上面这些都是该怎么做的？

Answer 1

构建query2的正确方法是

SELECT uid1, uid2 FROM friend WHERE uid1 IN (SELECT uid1 FROM #query1) AND uid2 IN (SELECT uid1 FROM #query1)

但总体而言，这一呼吁效率低下。请求将失败，因为它太耗费资源。你可能会和每个朋友的第二个电话分手。