Query Error: SELECT m.id AS mid ,m.name AS mname, t.id AS tid,t.name AS tname FROM bg_items b, ph_info p , ph_machine m ,ph_mtype t WHERE b.itemid=p.id AND m.id=t.mid AND m.id=p.machine AND t.id=p.mtypeid AND m.id>0 AND t.id>0 AND b.uid=28938 GROUP BY t.id ORDER BY p.hits LIMIT 8

The URL is:

MySQL server error:
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'hakka.p.hits' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ( 1055 )

You can get help in: