SELECT m.*, m.id AS masterid, p.orig_pic AS masterimage, p.spider_id AS spider_id, MATCH (gwsearch) AGAINST ("Gift Shopping Zone Bear Log Candle Holder") AS score, 
	                      p.orig_pic AS masterimage, p.spider_id AS spider_id, MIN(p.price) AS lowest
						  FROM `master_products` m
	                      LEFT JOIN products p ON p.status_type=m.id 
						  WHERE MATCH (gwsearch) AGAINST ("Gift Shopping Zone Bear Log Candle Holder") AND m.status>0 AND p.status>0 AND p.status_type>0 
						  AND m.id!=28699 GROUP BY m.id ORDER BY score DESC LIMIT 0,3<br>Table 'p' is marked as crashed and should be repaired