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 (687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707) [TEP STOP]