Laravel select subquery

Question

I'm rather stuck trying to figure out how I can run this as a single query from the database rather than fetching the results using one query then executing the other.

$query->whereIn('page_user_id', Staff::lists('staff_id'));

Thanks for the help

Lakhwinder Singh · Accepted Answer · 2015-07-14 14:24:19Z

3

$query->join('staff', 'staff.staff_id', '=', 'user.page_user_id')->get();

I think this will help. For reference http://laravel.com/docs/5.1/queries

edited Jul 14, 2015 at 14:24

answered Jul 14, 2015 at 13:44

Lakhwinder Singh

5,5825 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Shardj Over a year ago

Thanks for trying, but that's three queries not one

Lakhwinder Singh Over a year ago

@Shard can you please send me full query So I can provide you correct solution.

Shardj Over a year ago

I could but the query builder is 150+ lines long and likely wouldn't help you come to a solution. I basically don't want to have to fetch the data Staff::all()->lists('staff_id') then query it. I want a select subquery within my whereIn that deals with the results all in one query from the database.

Lakhwinder Singh Over a year ago

ok, then you can use laravel join's $query->join('staff', 'staff.staff_id', '=', 'user.page_user_id')->get(); (laravel.com/docs/5.1/queries)

Shardj Over a year ago

Perfect dude, put that as an answer so I can tick it

Collectives™ on Stack Overflow

Laravel select subquery

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related