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 (744,745,746,5111,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,747,748,749,750,4872,4875,4873,4874,4878,4879,4877,4876,3597,3598,3599,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,4869,4870,4871,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659,3660,3661,3662,3663,3664,3665,3666,3667,3668,751,752,753,754,4897,4898,4899,4900,4901,4902,4903,4904,4905,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,5112,5125,5126,5127,770,771,772,773,774,775,776,777,778,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3486,3487,3488,3489,3490,3491,3492,3493,3494,3495,3496,3497,3498,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,3542,3543,3544,3545,3546,3547,3548,3549,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4424,4425,4426,4427,4428,4429,4430,4431,4945,4946,4948,4949,4950,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4442,4443,4444,4445,4446,4447,4448,4449,4450,4451,4492,4493,4494,4495,4496,4497,4498,4499,4500,4501,4502,4503,4504,4505,4739,4708,4740,4709,4736,4727,4713,4734,4735,4714,4729,4728,4715,4716,4719,4730,4731,4732,4733,4723,4506,4507,4508,4509,4510,4511,4512,4513,4514,4515,4516,4517,4518,4519,4520,4521,4522,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4536,4537,4538,4539,4540,4541,4542,4543,4544,4545,4546,4547,4548,4549,4550,4551,4552,4553,4554,4555,4556,4557,4558,744,745,746,5111,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,747,748,749,750,4872,4875,4873,4874,4878,4879,4877,4876,3597,3598,3599,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,4869,4870,4871,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659,3660,3661,3662,3663,3664,3665,3666,3667,3668,751,752,753,754,4897,4898,4899,4900,4901,4902,4903,4904,4905,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,5112,5125,5126,5127,770,771,772,773,774,775,776,777,778,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3486,3487,3488,3489,3490,3491,3492,3493,3494,3495,3496,3497,3498,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,3542,3543,3544,3545,3546,3547,3548,3549,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4424,4425,4426,4427,4428,4429,4430,4431,4945,4946,4948,4949,4950,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4442,4443,4444,4445,4446,4447,4448,4449,4450,4451,4492,4493,4494,4495,4496,4497,4498,4499,4500,4501,4502,4503,4504,4505,4739,4708,4740,4709,4736,4727,4713,4734,4735,4714,4729,4728,4715,4716,4719,4730,4731,4732,4733,4723,4506,4507,4508,4509,4510,4511,4512,4513,4514,4515,4516,4517,4518,4519,4520,4521,4522,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4536,4537,4538,4539,4540,4541,4542,4543,4544,4545,4546,4547,4548,4549,4550,4551,4552,4553,4554,4555,4556,4557,4558) [TEP STOP]