SELECT count(1)
FROM `brokers`
LEFT JOIN agents ON agents.brokers_id = brokers.id
LEFT JOIN saved_flyers ON saved_flyers.user_id = agents.id AND saved_flyers.active > -1
LEFT JOIN referrals ON brokers.referral_id = referrals.id
WHERE saved_flyers.active = 1 AND saved_flyers.expiration > NOW() AND brokers.status = '1' AND (brokers.created > '2007-07-29' AND brokers.created < '2008-07-31')
GROUP BY brokers.id
LIMIT 1

/* ^^ That returns a count of 9 */

/* But if I do: */

SELECT brokers.*
FROM `brokers`
LEFT JOIN agents ON agents.brokers_id = brokers.id
LEFT JOIN saved_flyers ON saved_flyers.user_id = agents.id AND saved_flyers.active > -1
LEFT JOIN referrals ON brokers.referral_id = referrals.id
WHERE saved_flyers.active = 1 AND saved_flyers.expiration > NOW() AND brokers.status = '1' AND (brokers.created > '2007-07-29' AND brokers.created < '2008-07-31')
GROUP BY brokers.id

/* ^^ I get 5 results. */