1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hdwallpapersfun_pics.a.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br />SELECT a.*, b.*, COUNT(b.item_id) as `counter` FROM `ws_tags` a, `ws_tags_items` b, `ws_items` c WHERE c.id=b.item_id AND c.enabled=1 AND c.visible=1 AND a.id=b.tag_id GROUP BY a.name ORDER BY `counter` DESC