select DISTINCT `user` from `tiki_history` where `pageName`=? order by `version` desc
Values:
0
PesticideUsageChecklistB
Message:
Expression #1 of ORDER BY clause is not in SELECT list, references column 'h2ogeoc_tw2.tiki_history.version' which is not in SELECT list; this is incompatible with DISTINCT
Built query was probably:
select DISTINCT `user` from `tiki_history` where `pageName`='PesticideUsageChecklistB' order by `version` desc
Error