--SELECT P.* FROM projects P WHERE P.is_active=1 AND (UNIX_TIMESTAMP(DATE_ADD(P.`date`, INTERVAL P.`duration` DAY)) - UNIX_TIMESTAMP(NOW())) > 0 ORDER BY date DESC LIMIT 30-- http://www.freelancerbay.com/en/rss/projects en