Multi FQL query with limit

I do not know, how get all my threads and last message of each thread by FQL. I try:

fql?q={"threads":"SELECT subject, recipients, updated_time, unseen, unread, thread_id FROM thread WHERE folder_id = 0", 
"users": "SELECT uid, name FROM user WHERE uid IN (SELECT recipients FROM #threads)", 
"first_msg": "SELECT message_id, thread_id, body, created_time FROM message WHERE thread_id IN (SELECT thread_id FROM #threads) ORDER BY created_time DESC LIMIT 1"}

But ofcouse I get last message only for one (first) thread from list.

Answers


I see only one answer: add query for each thread to get last message. Plus check max count queries (if present too many threads)


Need Your Help

Real time processing large images in WPF

c# wpf image image-processing aforge

I have very large images (up to 12MPx) and I want to efficiently process them (panning, zooming, changing brightness and contrast), all must be done in WPF. I'm using AForge.NET library for image

Connect to h2 database

c# .net h2

From H2 database file layout, the db filename is xxx.h2.db

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.