1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SELECT MIN(p.products_id) as minpid,pd.products_name FROM products p,products_description pd,products_to_categories pc WHERE p.products_status=1 AND p.products_id=pc.products_id AND p.products_id=pd.products_id AND pc.categories_id IN (3,4,5,6,7,8,9,10,11,12,13,15,16,17,18,36,37,86,3,4,5,6,7,8,9,10,11,12,13,15,16,17,18,36,37,86) [TEP STOP]