jeudi 12 juillet 2018

Laravel query builder with joins

I am blocked in the conversion of my raw sql query to laravel query builder. Can someone give me a hand on the issue?

select p.name, p.`type`, p.`status`, p.state, ps1.* from pos_session ps1 right join pos p on ps1.pos_id = p.id where ps1.id = (select max(ps0.id) from pos_session ps0 where ps0.pos_id = ps1.pos_id) or p.site_id = '2' order by ps1.pos_id;



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire