SELECT c.* FROM cms_module_products c LEFT JOIN cms_module_products_fieldvals AS ord_vals ON ord_vals.product_id = WHERE c.status = 'published' 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