I wasn't refering to the number of different select statements but to how many searches of the indexes the database optimiser would need to do to get your complete list of friends. While it's easy to put these queries into one query that certainly doesn't make it any faster.

Also, was that the simplest search you could come up with for that query??? it looks a triumph of NZDF coding