SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = c.id LEFT JOIN cms_module_products_hierordering ordtbl ON (ordtbl.hier_id = 100 AND ordtbl.product_id = c.id) LEFT JOIN cms_module_products_fieldvals FVA ON c.id = FVA.product_id WHERE c.status = 'published' AND ph.hierarchy_id = 100 AND FVA.value_116 = 'Produktas' AND (FVA.value_120 = 'Kvadrāts' and FVA.value_121 = 'Viengabalaini') AND c.id != 628 GROUP BY c.id ORDER BY ordtbl.order_id ASC LIMIT 0, 3
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'fielmann_texuslv.ordtbl.order_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by