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 (577,578,579,580,581,582,583,584,585,586,587,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2896,588,2669,577,578,579,580,581,582,583,584,585,586,587,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2896,588,2669) [TEP STOP]