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 (40,153,154,179,155,156,4345,4346,4347,4348,4349,4350,169,171,172,173,174,175,176,177,44,150,39,41,157,159,160,180,4303,4304,4305,4306,4307,4308,4738,4741,4742,4743,4744,4745,4746,4747,4748,4749,4750,4751,4752,4753,4754,4755,4756,4757,4758,4759,46,43,112,111,109,110,90,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,2906,77,78,79,80,81,82,83,84,2905,2911,85,96,97,98,99,100,101,102,103,104,105,106,107,3269,3270,3271,3272,3273,3274,3275,3321,3250,3251,3249,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,3267,3268,40,153,154,179,155,156,4345,4346,4347,4348,4349,4350,169,171,172,173,174,175,176,177,44,150,39,41,157,159,160,180,4303,4304,4305,4306,4307,4308,4738,4741,4742,4743,4744,4745,4746,4747,4748,4749,4750,4751,4752,4753,4754,4755,4756,4757,4758,4759,46,43,112,111,109,110,90,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,2906,77,78,79,80,81,82,83,84,2905,2911,85,96,97,98,99,100,101,102,103,104,105,106,107,3269,3270,3271,3272,3273,3274,3275,3321,3250,3251,3249,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,3267,3268) [TEP STOP]