Query (SELECT offender.id as id,offender_id,f_name,m_name,l_name,suffix,dob,age,alias,level,offender_designation,sex,height,weight,race,ethnicity,hair_color,eye_color,scars_marks_tattoos,date_release,vehicle_info,date_verification,date_registration,victim_age,date_end_registration,registration_duration,victim_gender,status_probation,date_address,skin_color,age_at_offense,biometric,build,corrective_lens,offender_employment_restrictions,offender_exclusion,offender_repeat,offender_residency_restrictions,offending_methods,targets,verification_requirement,violations,url,url_picture,saved_image,crawl_id,Next_id,prev_id,next_name,prev_name,next_address,prev_address,offender.status as status, offender_url_id,address.state, 0 as pin_offender_id FROM offender  LEFT JOIN address ON offender.id = address.OffenderID  WHERE crawl_id = 21 and deleted='0' AND offender_id = 'X0000456'  group by offender.offender_id LIMIT 1) Failed. Error : Expression #55 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sexoffender_latest.address.State' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by