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