MySQL: Find records in one table that are not in another

Using NOT EXISTS is much faster than using LEFT JOIN to find records in one table that are not in another. Head over at for more details on the same