SELECT m.*, m.id AS masterid, p.orig_pic AS masterimage, p.spider_id AS spider_id, MATCH (gwsearch) AGAINST ("Elegant Wedding Impressions “He Loves Me. He Loves Me Not.” Ten-Piece, Flower-Petal Nail Files (Set of 12)") 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 ("Elegant Wedding Impressions “He Loves Me. He Loves Me Not.” Ten-Piece, Flower-Petal Nail Files (Set of 12)") AND m.status>0 AND p.status>0 AND p.status_type>0 
						  AND m.id!=58266 GROUP BY m.id ORDER BY score DESC LIMIT 0,3<br>Table 'p' is marked as crashed and should be repaired