Disk full (/tmp/#sql_8df_0); waiting for someone to free some space...
SELECT * FROM SC_products p WHERE (categoryID IN (2020)) AND (brendID>0) GROUP BY `brendID`