SELECT goods_new.Id FROM goods_new LEFT JOIN availability ON goods_new.Id = availability.id INNER JOIN goods_props ON goods_props.zip = goods_new.Id LEFT JOIN rebra_new ON rebra_new.Idj = goods_new.Rebra WHERE ((LOWER(goods_new.Search_Text) LIKE '%%')) AND ( availability.itog > 0) ORDER BY availability.itog DESC, goods_new.Price ASC LIMIT 0, 12