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 (1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,4098,1638,1639,1640,1641,1642,4099,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,4100,1655,1656,1657,1658,1659,1660,1661,1662,1663,1684,1685,1686,1687,1664,1665,4101,4102,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,2888,1680,1681,1682,1683,1688,1689,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,4098,1638,1639,1640,1641,1642,4099,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,4100,1655,1656,1657,1658,1659,1660,1661,1662,1663,1684,1685,1686,1687,1664,1665,4101,4102,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,2888,1680,1681,1682,1683,1688,1689) [TEP STOP]