vendredi 13 avril 2018

convert MySql Query to laravel eloquent query

SELECT p.name, p.image, p.slug, p.type,( SELECT MIN( pvp.sale_price +( (10 * IFNULL(pv.weight, 0)) / IFNULL(pv.pack_size, 0) ) ) FROM product_variation_prices AS pvp INNER JOIN product_variations AS pv ON pvp.product_variation_id = pv.id WHERE pvp.p_id = p.id AND pv.status = 1 ) AS min_price from products as p HAVING min_price > 0



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire