Report question

Question: MySQL - SELECT WHERE field IN (subquery) - Extremely slow why?