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 (810,820,819,818,811,816,817,815,812,813,814,821,822,823,824,825,809,789,790,791,792,793,2410,2605,2606,2607,2608,2609,2975,794,795,796,797,798,799,800,801,802,2411,803,804,805,806,807,808,2409,2412,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2988,2989,3035,3038,3039,3040,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3029,3030,3031,3032,3033,3034,3036,3037,4865,4866,4867,4868,810,820,819,818,811,816,817,815,812,813,814,821,822,823,824,825,809,789,790,791,792,793,2410,2605,2606,2607,2608,2609,2975,794,795,796,797,798,799,800,801,802,2411,803,804,805,806,807,808,2409,2412,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2988,2989,3035,3038,3039,3040,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3029,3030,3031,3032,3033,3034,3036,3037,4865,4866,4867,4868) [TEP STOP]