Err No : 1055, detail : Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'k1331699_multindo.p.uri_en' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT m.*, COALESCE(p.uri_en, '') AS page_uri_en, COALESCE(p.uri_id, '') AS page_uri_id FROM menus m LEFT JOIN pages p ON m.menu_id=p.menu_id AND p.parent_id=0 AND p.hide=0 GROUP BY m.menu_id ORDER BY m.order_id, p.order_id