Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vanlog_db.lg.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `cle_post`.*, `lg`.`title`, `lg`.`content`, `lg`.`excerpt`, `lg`.`language`
FROM `cle_post`
JOIN `cle_relationships` as `r` ON `r`.`object_id` = `cle_post`.`id`
JOIN `cle_relationships` as `r2` ON `r2`.`object_id` = 28 AND `r`.`category_id` = `r2`.`category_id`
JOIN `cle_language` as `lg` ON `lg`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'service'
AND `cle_post`.`id` <> '28'
AND `r2`.`object_type` = 'post'
AND `lg`.`language` = 'en'
AND `lg`.`object_type` = 'post'
GROUP BY `r`.`object_id`
ORDER BY `order`, `created` desc
LIMIT 6