Joomla 4. Mysql. ONLY_FULL_GROUP_BY deaktivieren.
$db->setQuery("SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");
$db->execute();
xyz
$db->setQuery("SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");
$db->execute();
xyz