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