Error: Query (Logged) /LOVD2/download.php returned VariantsView_all error for Query : SELECT v.*, p.*, p2v.allele, p2v.status, p2v.created_by AS ID_variant_created_by_, p2v.created_date AS variant_created_date_, p2v.edited_by AS ID_variant_edited_by_, p2v.edited_date AS variant_edited_date_, path.pathogenic, path.pathogenic_text AS pathogenic_, uvc.name AS variant_created_by_, uve.name AS variant_edited_by_, upc.name AS patient_created_by_, upe.name AS patient_edited_by_, CONCAT(s.firstname, " ", s.lastname) AS submitter_ FROM lovd2_DFNB31_variants AS v LEFT JOIN lovd2_patients2variants AS p2v ON (p2v.symbol = "DFNB31" AND v.variantid = p2v.variantid) LEFT JOIN lovd2_patients AS p USING (patientid) LEFT OUTER JOIN lovd2_variant_pathogenicity AS path ON (p2v.pathogenic = path.pathogenic) LEFT OUTER JOIN lovd2_users AS uvc ON (p2v.created_by = uvc.userid) LEFT OUTER JOIN lovd2_users AS uve ON (p2v.edited_by = uve.userid) LEFT OUTER JOIN lovd2_users AS upc ON (p.created_by = upc.userid) LEFT OUTER JOIN lovd2_users AS upe ON (p.edited_by = upe.userid) LEFT OUTER JOIN lovd2_submitters AS s ON (p.submitterid = s.submitterid) WHERE p2v.status >= 7 GROUP BY v.variantid, p.patientid, p2v.allele ORDER BY v.sort ASC, `Variant/DNA` ASC, p.patientid Error : Expression #39 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lovdext.p2v.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by