How can I do subqueries in Laravel's fluent?

Question

Say I have this bit of SQL:

select * 
from `fluents`
inner join `tests` on `fluents`.`id` = `tests`.`fluent_test_id`
inner join (
    select `fluents`.`id` from `fluents` order by `fluents`.`id` desc limit 10
) as j on `fluents`.`id` = `j`.`id`
order by `fluents`.`created_at`;

I know I could run the raw SQL but as a learning exercise I'm trying to convert it to fluent and failing miserably, is this even possible?

I mean't using the query builder, not just simply executing the raw SQL. — rich97, Jul 11 '13 at 11:59
possible duplicate of [How to do this in Laravel, subquery where in](http://stackoverflow.com/questions/16815551/how-to-do-this-in-laravel-subquery-where-in) — Rob W, Jul 11 '13 at 14:17

score 6 · Accepted Answer · answered Jul 11 '13 at 13:09

I have done it this way in my project:

DB::table('fluents')->join('tests','tests.fluent_test_id','=','fluents.id')
                    ->join(DB::raw("(select fluents.id from fluents order by `fluents`.`id` desc limit 10) as j"),'j.id','=','fluents.id')
                    ->orderBy('fluents.created_at');

I hope this can be of some help.

How can I do subqueries in Laravel's fluent?

1 Answers1