Report question

Question: Mysql subquery result in "where" clause