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