help with query

[ryanschefke]

Hello,

I am trying to only show the rows where the sumHits value is >1 and it is not working. I confirmed if I remove the "sumHits>1" (currently in below query) it works just fine. Thanks in advance for your help.

SELECT v.organization, v.city, v.region, countries.printable_name, 
DATE_FORMAT(v.dateTime, '%m/%d/%Y %l:%i %p'), v.visitorID, v.searchWords, 

COUNT(h.hitID) as sumHits FROM visitors as v, hits as h, countries WHERE v.customerID='11222' AND cast(v.dateTime as date)='2008-08-30' AND 
h.visitorID=v.visitorID AND v.country=countries.country_code AND sumHits>1 GROUP BY 
h.visitorID ORDER BY v.dateTime DESC LIMIT 0, 20

[Piranha]

I think you should use HAVING in this case. Note that I haven't tested the query myself. It may have the wrong order of having and group by.

select count(*) as count
from table
having count > 1
group by column