SELECT B.* FROM (SELECT tb_id FROM products WHERE MATCH(mfg_part,mfg_mod_part,mfg,descr,grp, tb_id) AGAINST("+SENTINEL Software NOVELL*" IN BOOLEAN MODE) LIMIT 1000) A LEFT JOIN products B USING (tb_id) WHERE display=1 AND sale_price>0 AND img=1 AND qty>0 LIMIT 10;