I've see a lot of examples on how to do subquery with whereIn
, but i need to do the same with where
, like this:
select *
from products
where (select count(*)
from items
where items.product_id = products.id
and items.exported = 0) = 0;
I simply tried this code:
Product::where(function($q) {
$q->selectRaw('count(*)')
->from('items')
->whereRaw('items.product_id', 'products.id')
->where('items.exported', 0);
}, '=', 0);
In this solution the result query is something like this:
select *
from products
where (items.product_id and exported = 0);
The builder loose the subquery for some reason. How i can solve ?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire