SELECT aou_list.CommonName, aou_list.SPNO, PORC_records.record_number, PORC_records.species_number, PORC_records.accepted, PORC_records.obs_county, substr(PORC_records.record_number, 6, 4) AS myYear FROM PORC_records,aou_list WHERE species_number = ? and PORC_records.species_number=aou_list.SPNO GROUP BY record_number ORDER BY PORC_records.obs_date DESC

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pasiteguide.aou_list.CommonName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

#1 /home/w72w9xoqmrbx/public_html/porc/PORC_User_Species_Record_List.php(7): WA_MySQLi_RS->execute()