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 (1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,3669,3670,3671,3672,3673,3674,3675,1472,1473,1474,1475,1476,1477,1478,2887,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,3526,3596,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,3669,3670,3671,3672,3673,3674,3675,1472,1473,1474,1475,1476,1477,1478,2887,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,3526,3596) [TEP STOP]