Дмитрий

SELECT * 
FROM `my_table` 
WHERE `priceFrom` < 150000 
OR (`priceFrom` > 150000 AND `priceFrom` <= 180000);

SELECT *, `names` as `nm` 
FROM `product` 
HAVING `massa` = (
    SELECT max(`massa`) 
    FROM `product` 
    WHERE `names` = `nm`
) 
ORDER BY `names` 
ASC