chris smith-9 wrote:
> 
> Ah - that would be the group by doing that.
> 
> Removing those:
> 
> GROUP BY eta.id ORDER BY subcat_count DESC, eta.id
> 
> Does that get you what you want?
> 
> If it gives you one result - make sure it's right. Change a few id's, 
> make sure they match up to what your other query returns.
> 

I really appreciate your help by the way.

I've also tried that.  I do get a single value when I do that but the count
is too high!  Each of the esa associations gets counted separately rather
than just once.  The original COUNT and GROUP BY parts limit the number of
records by aggregating all the esa records per event into a single count -
which is what i want.




-- 
View this message in context: 
http://www.nabble.com/urgent%3A-Trying-to-get-COUNT-for-fairly-elaborate-query-tf2449123.html#a6827251
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to