Dear friend,
i am using the below code please check the resource

SELECT * FROM tablename WHERE (Approved != 0) AND (111) AND (TO_DAYS( NOW( ) ) - TO_DAYS( expirydate ) <= 0) ORDER BY Sponser DESC, SponserRank DESC, SubmitDate DESC

Regards
Jitender