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=72978
GROUP BY t.id
ORDER BY p.hits
LIMIT 8
The URL is:
http://photo.mzsky.cc
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: