Missing search results when searching by group due to incorrect SQL query

See http://forum.civicrm.org/index.php/topic,14185.0.html

Replicated on demo

• try a basic search on group "Test Group Search". Search results page says "117 Results" / "Contact 1-50 of 117" but only actually lists 9. How I set this up:

(1) Created group "Test Group Search" & added all contacts as members.
(2) Created group "Test Group Search child group" as child of "Test Group Search" (didn't add any members).
(3) Added & removed some of the members to/from other groups: removed all the households from "Test Group Search", added all of the "Test Group Search" members beginning with "A" to several other groups.
(4) Basic search on group "Test Group Search".

Full details in forum post.

Dave J