SELECT DISTINCT *, pd.name, p.image, MATCH(pd.name, pd.description) AGAINST ('/\\b\\b/i' IN NATURAL LANGUAGE MODE) AS score,(SELECT `pd2`.`price` FROM `oc_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1'AND `pd2`.`quantity` = '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1) AS `discount`, (SELECT `ps`.`price` FROM `oc_product_special` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM oc_product_to_store p2s 
					LEFT JOIN oc_product p 
					ON p.product_id = p2s.product_id AND p.status = '1' AND p2s.store_id = '0' AND p.date_available <= NOW()
					LEFT JOIN oc_manufacturer pm ON p.manufacturer_id = pm.manufacturer_id LEFT JOIN oc_product_description pd ON p.product_id = pd.product_id 
				WHERE pd.language_id = '1' AND MATCH(pd.name, pd.description) AGAINST ('/\\b\\b/i' IN NATURAL LANGUAGE MODE) > 0 AND (pd.name LIKE '%/\\b\\b/i%' OR LCASE(p.model) LIKE '%/\\b\\b/i%' OR LCASE(p.sku) LIKE '%/\\b\\b/i%' OR LCASE(p.upc) = '/\\b\\b/i' OR LCASE(pd.description) LIKE '%/\\b\\b/i%' OR pd.tag LIKE '%log044a1sso-6%') ORDER BY score DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30