Tiny Baetis mayflies are perhaps the most commonly encountered and imitated by anglers on all American trout streams due to their great abundance, widespread distribution, and trout-friendly emergence habits.
SELECT fromdate FROM contentupdates WHERE livetime < NOW() WHERE fromdate IN ('2012-07-22','2012-07-18','2012-06-20','2012-06-03','2012-05-20','2012-05-16','2012-05-15','2012-05-06','2012-04-29','2012-04-25','2012-04-22','2012-04-21','2012-04-20','2012-04-19','2012-04-17','2012-04-07','2012-03-27','2012-03-26','2012-03-07','2011-10-05','2011-10-03','2011-09-26','2011-09-21','2011-09-15','2011-09-09','2011-09-05','2011-08-12','2011-08-10','2011-08-09','2011-08-04','2011-08-03','2011-07-27','2011-07-26','2011-07-24','2011-07-15','2011-07-14','2011-07-13','2011-07-09','2011-07-01','2011-06-30','2011-06-29','2011-06-25','2011-06-23','2011-06-19','2011-06-17','2011-06-15','2011-06-10','2011-06-06','2011-06-05','2011-05-31','2011-05-02','2010-10-05','2010-09-05','2010-07-31','2010-07-20','2010-07-09','2010-06-30','2010-06-19','2010-06-15','2010-04-15','2010-03-27','2010-03-13','2009-12-19','2009-09-16','2009-08-13','2009-07-15','2009-07-11','2009-07-04','2009-06-19','2009-05-10','2009-02-27','2008-07-17','2008-07-02','2008-06-25','2008-04-21','2008-02-01','2007-09-07','2007-08-31','2007-08-17','2007-08-00','2007-07-31','2007-07-12','2007-07-09','2007-07-05','2007-07-02','2007-06-29','2007-06-20','2007-06-12','2007-06-09','2007-06-05','2007-05-05','2007-05-01','2007-04-19','2007-04-04','2007-02-01','2007-00-00','2006-05-15','2006-04-29','2005-12-03','2005-11-23','2005-09-07','2005-08-26','2005-07-21','2005-07-10','2005-07-09','2005-07-05','2005-07-04','2005-07-03','2005-06-25','2005-06-24','2005-06-16','2005-06-14','2005-06-08','2005-06-05','2005-05-30','2005-05-27','2005-05-26','2005-05-25','2005-05-18','2005-05-14','2005-05-12','2005-05-09','2005-05-08','2005-05-01','2005-04-08','2005-03-12','2005-03-06','2005-03-05','2005-03-01','2005-02-27','2002-06-15','0000-00-00') ORDER BY fromdate DESC LIMIT 100,5