Level 88
The one I can think is probably this one
$user = User::whereNameAndEmailAndActive('John Doe', '[email protected]', true)->firstOrFail();
This produce a query like
select * from users where name = 'John Doe' and email = '[email protected]' and active = '1'
1 like