SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = LEFT JOIN cms_module_products_hierordering ordtbl ON (ordtbl.hier_id = 18 AND ordtbl.product_id = LEFT JOIN cms_module_products_fieldvals AS ord_vals ON ord_vals.product_id = WHERE c.status = 'published' AND ph.hierarchy_id = 18 GROUP BY ORDER BY CAST(ord_vals.value_122 AS DATE) ASC LIMIT 0, 10
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'a0014989_www.ord_vals.value_122' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by