[SOLVED] 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

[toplay]

Change the last part from this:

 

AND sumHits>1 GROUP BY h.visitorID ORDER BY v.dateTime DESC LIMIT 0, 20

 

to this:

 

GROUP BY h.visitorID having sumHits >1 ORDER BY v.dateTime DESC LIMIT 0, 20

[ryanschefke]

You are awesome! That worked!