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