Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
In Laravel 4.2, I am trying to achieve a query that returns all users, that have all of certain activities. As of now, I have a query that returns all users that have one of many activities:
//$selectedActivities being an array
$userByActivities = User::with('activities')
->whereHas('activities', function($query) use($selectedActivities){
$query->whereIn('id', $selectedActivities);
})->get();
To be more clear: given activities a,b,c. I am looking for all users that have activity a AND b AND c. My query returns all users that have activity a OR b OR c.
Thank you for your help.
@musaya I suppose it is MySQL, so here it goes:
$userByActivities = User::with('activities')
->whereHas('activities', function($query) use($selectedActivities) {
$query->selectRaw('count(distinct id)')->whereIn('id', $selectedActivities);
}, '=', count($selectedActivities))->get();
It's five years later, but what about for SQL Server?
@JarekTkaczyk how much time did you spend playing with Eloquent ?
@bestmomo I suppose it was enough ;) I first touched Laravel when it was late v4.1.
Thank you very much for your help. I asked the same question on stackoverflow and maybe the answer is of interest for you. Here is the link:
http://stackoverflow.com/questions/28633389/laravel-eloquent-where-in-all
@musaya Yeah, lukasgeiter knows it as well. However this time his solution is overkill. It adds subquery for each id you want to check. The way I showed is what you should do here.
I have exact same problem but for me, lukasgeiter's solution on SO works but the accepted solution here gives me Cardinality violation: 1241 Operand should contain 2 column(s). I'd prefer to reduce the number of queries using @JarekTkaczyk's elegant solution. Any ideas? Let me know if you need more info.
Thanks
@irclever I ran into the same issue. Replacing ->selectRaw(...) with ->select(\DB::raw('count(distinct id)')) worked for me
Please or to participate in this conversation.