## mark a section (Learn more)

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. */

This paste will be private.