SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_fieldvals AS eshop_limit ON eshop_limit.product_id = c.id INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = c.id LEFT JOIN cms_module_products_hierordering ordtbl ON (ordtbl.hier_id = 130 AND ordtbl.product_id = c.id) WHERE c.status = 'published' AND eshop_limit.value_125 != 'true' AND ph.hierarchy_id IN (271,275,274,273,272,269,265,266,263,262,176,175,249,221,219,174,173,172,171,159,158,157,156,155,154,260,247,153,151,150,149,148,268,267,170,169,168,167,135,162,161,160,134,166,164,276,163,133,256,147,146,144,143,142,131,130) GROUP BY c.id ORDER BY ordtbl.order_id ASC LIMIT 0, 12
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'agra_bioklab.ordtbl.order_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by