Error in Selection query SELECT a.mem_subacaste_others,a.mobile_verfication,a.email_verfied,a.mem_mobilecode2,a.mem_mobile2,a.mem_preferred_time_contact,a.matri_id,a.mem_email,a.mem_fullname,a.mem_gender,b.mem_religion,b.mem_caste_division,b.mem_sub_caste,a.mem_age,a.mem_marital_status, DATE_FORMAT(a.mem_dob,'%d-%M-%Y') as mem_dob,a.any_issue,a.have_child, a.stay_child,DATE_FORMAT(a.mem_last_login,'%d-%b-%Y %h:%i %p') as mem_last_login, a.mem_child_male,a.mem_child_female, a.mem_divorce_no,DATE_FORMAT(a.mem_divorce_no,'%d-%M-%Y') as mem_divorce_date,a.mem_aboutme, a.mem_mobilecode, a.mem_mobile, a.mem_phonecode, a.mem_phone, a.mem_profile_created_by, a. mem_refname, a.mem_refrelation, a.mem_phot_self, a.mem_status, a.mem_plan_id, a.profile_completion,a.mem_selected_plan,a.admin_app_phot,a.mem_photo_horoscope,a.admin_app_horoscope,a.mem_membership_id,
a.delete_subject, a.mem_delete_reason,a.mem_del_other_reason,
b.mem_kottam, b.mem_kovil, b.time, b.mem_tob, b.place,b.mem_pob, b.mem_rasi, b.mem_star,b.mem_padham, b.mem_lagnam, b. mem_thisai_irrupu, b.mem_thisai_year , b.mem_thisai_month, b.mem_thisai_day, b.mem_dosham, b.mem_sev_position, b.mem_sev_parigaram, b.mem_rahu_position,b.mem_kedhu_position, b.language, c.mem_address1,c.mem_country,c.mem_state,c.mem_city,c.mem_pincode,c.mem_country_living,c.mem_native,c.mem_site, d.mem_edu, d.mem_edu_detail, d.empnature,d.mem_emp_job,d.mem_emp,d.mem_emp_country,d.mem_empinc_cur,d.mem_empinc_income,d.mem_emp_income, d.mem_empinc_type,e.mem_fathername,e.mem_fatherocc,e.mem_mothername,e.mem_motherocc,e.mem_nof_sis,e.mem_nof_sis_mar,e.mem_nof_bro, e.mem_nof_bro_mar,e.mem_family_status,e.mem_family_values,e.mem_fam_cur,e.mem_fam_income,e.mem_faminc_type,e.mem_family_details, e.mem_asset_details,e.mem_asset_value,f.mem_par_fromage, f.mem_par_toage, f.mem_par_edu, f.mem_par_empnature,f.mem_par_income,f.pe_drink,f.mem_par_currency,f.mem_parinc_amt, f.mem_parinc_type, f.mem_par_country1, f.mem_pe_abroad,f.pe_smoking,f.pe_horos_match,f.pe_dhosam,f.pe_raghu_keathu,f.pe_no_brothers, f.pe_no_sisters,f.pe_food_prefer,g.mem_complexion, g.mem_bodytype,g.mem_diet,g.mem_smoke,g.mem_drink,g.mem_spec_category, g.mem_special_other, g.mem_blood, g.mem_height, g.mem_weight,g.mem_spectacles FROM tbl_member AS a
Left JOIN tbl_mem_astrology AS b ON a.matri_id = b.matri_id
LEFT JOIN tbl_mem_com AS c ON a.matri_id = c.matri_id
LEFT JOIN tbl_mem_edu AS d ON a.matri_id = d.matri_id
LEFT JOIN tbl_mem_family AS e ON a.matri_id = e.matri_id
LEFT JOIN tbl_mem_pe AS f ON a.matri_id = f.matri_id
Left JOIN tbl_mem_physical AS g ON a.matri_id = g.matri_id where a.matri_id='SM12284' GROUP BY a.matri_id Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'swaramma_wrdp1.b.mem_religion' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
