An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (DAYOFYEAR(CURDATE())-DAYOFYEAR(users.data_nasterii)<=0) ORDER BY users' at line 7

SELECT users.*, poze_user.nume AS poza_profil, users.username AS nickname , DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(users.data_nasterii)), '%Y')+0 AS age FROM users LEFT JOIN prefs_profil ON users.idusers=prefs_profil.idusers LEFT JOIN poze_user ON prefs_profil.idpoze_user=poze_user.idpoze_user LEFT JOIN prefs_confidentialitate ON users.idusers=prefs_confidentialitate.idusers WHERE prefs_confidentialitate.data_nasterii='da' AND users.activ='da' AND users.random='0' AND (DAYOFYEAR(CURDATE())-DAYOFYEAR(users.data_nasterii)>=-) AND (DAYOFYEAR(CURDATE())-DAYOFYEAR(users.data_nasterii)<=0) ORDER BY users.data_nasterii