Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'beton_svai.V.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT G.*, COUNT(L.id) as cnt_links, V.name FROM svai_linksgroups G LEFT JOIN svai_lexchange L ON L.gid = G.id AND L.confirmed="1" LEFT JOIN svai_linksgroups_values V ON V.id_linkgroup=G.id AND lang="ru" GROUP BY G.id ORDER BY sortby;
Обмен ссылками
Технотест

Обмен ссылками

Категории ссылок