1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SELECT MAX(p.products_id) as maxpid, 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 (1727) [TEP STOP]