SELECT fa.*, COUNT(DISTINCT CONCAT(strPropertyName, '|', strResortString)) AS intProperties, CAST(GROUP_CONCAT(DISTINCT rs.intPropertyID) AS CHAR) AS strPropertyIDsIN, strOwnerEmail, strOwnerWebsite, strOwnerTelephone, blnHideEmail, strLinkURL, intLinkNo, COALESCE(strOwnerName, o.strOwnerCompanyName) AS strOwnerName FROM vw_rentalsearch rs JOIN tbl_featuredads fa ON rs.intOwnerID = fa.intOwnerID JOIN tbl_owners o ON rs.intOwnerID = o.intOwnerID LEFT JOIN (tbl_propertylinks pl JOIN tbl_links li ON pl.intLinkID=li.intLinkID AND pl.intPropertyID=0 AND li.strLinkDescription='Luxury') ON rs.intOwnerID = li.intOwnerID WHERE blnExclusive = 1 AND blnActive = 1 GROUP BY rs.intOwnerID ORDER BY blnSpecial DESC, strOwnerName<br><br><b>ASP Error:</b> [MySQL][ODBC 9.5(w) Driver][mysqld-8.0.45-0ubuntu0.24.04.1]Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chaletsdirect.fa.strFeatureType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br>