When you IN(), ANY(), etc. in a MySQL query the optimizer is unable to do anything intelligent and you effectively end up with a cross product query.  The results of rewriting this query that looks for duplicate entries (so they … Continue reading →