Issues with ORDER BY caused by changing the DATE_FORMAT in the SELECT statement...

How to get smallest column value without triggering "Mixing of GROUP columns [...] with no GROU...

MySQL #1140 - Mixing of GROUP columns...

SQL count returns error when no GROUP BY clause...

MySQL: Include COUNT of SELECT Query Results as a Column (Without Grouping)...

MYSQL SELECT DISTINCT with additional column in result set...

MySQL aggregation problems...

Zend_Db_Select - Joins and Count - Possible Zend Bug?...