SELECT m.*, m.id AS masterid, MATCH (gwsearch) AGAINST ('Fortune Cookie Favors') AS score, p.orig_pic AS masterimage, p.spider_id AS spider_id, MIN(p.price) AS lowest, MAX(p.msrp) AS highest, m.rate/(m.votes+0.01) AS rate_list FROM `master_products` m LEFT JOIN products p on p.status_type=m.id WHERE p.status>0 AND p.status_type>0 AND m.status>0 AND MATCH (gwsearch) AGAINST ('Fortune Cookie Favors') GROUP BY m.id LIMIT 0,3