AS t LEFT JOIN products AS p ON t.upc=p.upc In MySQL, the same query thrashes really hard. After some experimentation, it seems like the subquery itself is the problem. For instance: Code ...