FUND SCREENER Take Control of Our Mutual Fund Database!
Unknown column 'MD.FID' in 'field list' QUERY - SELECT MD.FID, MD.FAV, MD.MROVERALL, MAS.MIN_INIT_INV, MAS.FNAME as fund_name, MAS.TICKER AS MAS_TICKER, MAS.EXP_RATIO as expense_ratio, MAS.RETURN5YR as five_year_return, MAS.RETURN_3YR as three_year_return, MAS.RETURN1YR as one_year_return, MAS.RETURN_YTD as YTD_return, MAS.LOAD, MAS.NO_LOAD, CATS.CATNAME, MAS.STANDEV_3_YR as std_dev_3,MAS.BETA_3_YR as beta_3,MAS.ALPHA_3_YR as alpha_3 FROM MAXDATA MD Inner JOIN CATS CATS on CATS.CATNUM = MD.CAT Inner JOIN MASTER_DATA MAS ON MAS.FID = MD.FID WHERE (MAS.FNAME IS NOT NULL) AND OBJ != 'IX' AND MAS.TICKER != -9999 AND (((MAS.PER_MAX_LOAD = -9.99 OR MAS.PER_MAX_LOAD = 0.00) AND (MAS.PER_MIN_LOAD = -9.99 OR MAS.PER_MIN_LOAD = 0.00) AND (MAS.PER_DEFERRED_LOAD = -9.99 OR MAS.PER_DEFERRED_LOAD = 0.00) AND MAS.PER_12B1_FEE <=0.25 AND MAS.MIN_INIT_INV < 25000) OR (((MAS.PER_MAX_LOAD != -9.99 AND MAS.PER_MAX_LOAD != 0) OR (MAS.PER_MIN_LOAD != -9.99 AND MAS.PER_MIN_LOAD != 0) OR (MAS.PER_DEFERRED_LOAD = -9.99 AND MAS.PER_DEFERRED_LOAD = 0) OR (MAS.PER_12B1_FEE >0.25 AND MAS.MIN_INIT_INV < 25000))))