Re: Sorting by data the lowest values

[Rick James]

The GROUP BY has to happen after the ORDER BY, so you need a subquery:

SELECT * FROM (
    SELECT  T1.*, T2.property
        FROM  T1
        JOIN  T2 ON T1.id=T2.owner
        WHERE  T1.menu='. $variable. '
        ORDER BY  T2.property, T1.date, T1.name 
                 ) x
    GROUP BY  x.owner
    ORDER BY  x.property, x.date, x.name