I have a query which works perfectly fine on mysql client and phpmyadmin, my query is :
select members.m_id, members.m_reach, members.m_member_num_groups, members.m_name, groups.tr_cat,
groups.tr_id, group_categories.tc_id, group_categories.tc_name,group_members.tm_owner_id,
group_members.tm_group_id from members join group_members on group_members.tm_owner_id = members.m_id
join groups on groups.tr_id = group_members.tm_owner_id
join group_categories on group.tr_cat = group_categories.tc_id
group by members.m_id
order by members.m_reach DESC limit 5
but when I try it with laravel DB::select I get error :
SQLSTATE[42000]: Syntax error or access violation: 1055 'muzikal.members.m_reach' isn't in GROUP BY
I have seen many people asking the same question but couldn't get to a proper answer
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire