That' query is coming from your search. If the result set is larger than your mysql configuration allows then it will have to create a temp table for sorting. I'd check what your maximum search results and search range is set to in the control panel.
