Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'foninfo_eanb9.ebp_n_ad.ad' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select ebp_users.username,ebp_users.u1,ebp_users.u2,ebp_users.u3,ebp_users.u4,ebp_users.u5,ebp_users.joined,ebp_n_ad.ad,ebp_n_ad.ad_n from ebp_users,ebp_n_ad where ebp_n_ad.accept = '1' AND ebp_n_ad.approv = '1' AND ebp_n_ad.enabl = '1' AND ebp_n_ad.ad != '' AND ebp_users.suspended = 0 AND ebp_n_ad.size = '3' AND ebp_n_ad.user = ebp_users.n AND ebp_users.n = ebp_n_ad.user group by ebp_users.n,ebp_n_ad.ad_n