SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_product_categories cc ON cc.product_id = c.id INNER JOIN cms_module_products_categories cs ON cs.id = cc.category_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 = 126 AND ordtbl.product_id = c.id) WHERE c.status = 'published' AND cs.name IN ('Nauja') AND ph.hierarchy_id IN (255,254,253,252,251,258,220,218,212,192,191,177,257,183,182,181,178,179,180,132,190,189,188,187,137,259,246,217,216,215,214,213,186,185,184,136,126) GROUP BY c.id ORDER BY cc.order_id ASC LIMIT 0, 100
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'agra_bioklab.cc.order_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by