Now I want to get the number of hits and uniques for each webmaster in the system even if it is 0
So I got this query working:
Code: Select all
SELECT c.ID, count( DISTINCT w.IP) , count( w.IP) FROM Webmaster c LEFT JOIN Webhits w
ON ( c.ID = w.ID ) WHERE c.ID BETWEEN '1000' AND '3000'
GROUP BY c.Customer_IDCode: Select all
w.Timstamp BETWEEN '$firsttimestamp' AND '$lasttimestamp'How do I add this clause to get the desired result?