SELECT products.price  FROM products  INNER JOIN product_description ON products.pid=product_description.pid  LEFT JOIN admins ON products.vendorid=admins.aid  INNER JOIN catalog ON products.cid=catalog.cid  LEFT JOIN vendor ON vendor.vid=products.vendorid  WHERE products.is_visible='Yes'  AND ((product_description.description LIKE '%%' OR product_description.keywords LIKE '%%'  OR product_description.title LIKE '%%' OR products.product_id LIKE '%%'  OR products.mpn LIKE '%%' OR products.gtin LIKE '%%' OR (products.pid IN (SELECT product_fields_values.product_id as pid FROM product_fields_values  WHERE product_fields_values.field_value LIKE '%%'  AND product_fields_values.product_id=products.pid AND product_fields_values.language='en'))) OR (vendor.company LIKE '%%')) AND product_description.language='en' AND ((admins.isVendor='Yes' and admins.active='Yes') OR products.vendorid='0') AND products.is_approved ='approved'  AND ( products.product_expire_date>NOW() OR products.product_expire_date='0000-00-00' ) ORDER BY products.price DESC LIMIT 1