Home

SELECT `pro`.*, `pro_vari`.* FROM `products` as `pro` LEFT JOIN `products_variants` as `pro_vari` ON `pro_vari`.`p_id` = `pro`.`pid` WHERE `cat_id` LIKE '%120%' AND `pro`.`publish` = 1 ORDER BY `pro_vari`.`sale_price` ASC Home