I have the following query which I am struggling to use in Laravel. DB::raw()
is there but can't figure out how to set the subquery.
SELECT * from products
where status = 1
AND
id IN (
SELECT * FROM (
SELECT `product_id`
FROM `order_product`
order by `id` desc limit 8
) as T
)
I am using Laravel 5.6
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire