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 (1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553) [TEP STOP]