Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rangoliw_matka12.results.gamedate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query : select DATE_FORMAT(gamedate,'%Y-%m-%d') AS dtdate from results where 1 GROUP BY DATE_FORMAT(gamedate, '%Y-%m-%d') ORDER BY gamedate DESC LIMIT 1 File : /home/realbazar/public_html/index.php, Line : 27