i dont get it

[mull300]

would any one have any idea why this query would return a row that does not meet at least two of the requirements

SELECT 
COUNT(*) AS cnt FROM 
info AS a 
INNER JOIN exp AS b 
ON a.user_id=b.userId 
WHERE 
a.address_type='BT' 
AND a.delete_me='N' 
AND 
(b.industry=29 AND b.industry_private='N') 
AND 
(b.title LIKE 'web%' AND b.title_private='N')

the two that are red are the ones that dont match at all. in fact the user its pulling doesnt even have a row in the exp table.

[Fumigator]

You're selecting a count(*) so how do you know what IDs it's selecting?