where clause with count

[wxdqz]

I have a query like this:

SELECT *,count(table2.id) as thiscount
FROM table1
LEFT JOIN table2 ON table2.id = table1.id
GROUP BY table1.thiscolumn


but I only want to count values where
table2.Is_Deleted = '0'

since I can't do subselects, where can I specify table2.Is_Deleted='0'

thanks.