SELECT COUNT(u.user_id) FROM user AS u WHERE u.user_id!=0 AND hide_time=0 AND (DAYOFMONTH(birth)=DAYOFMONTH('2010-07-30 10:04:17') AND MONTH(birth)=MONTH('2010-07-30 10:04:17'));
SELECT u.*, YEAR(FROM_DAYS(TO_DAYS('2010-07-30 10:04:17')-TO_DAYS(birth))) AS age,
u.state AS state_title, u.country AS country_title, u.city AS city_title,
IF(u.city_id=0, 1, 0) +
IF(u.state_id=0, 1, 0) +
IF(u.country_id=0, 1, 0) AS near
FROM user AS u
WHERE u.user_id!=0 AND hide_time=0 AND (DAYOFMONTH(birth)=DAYOFMONTH('2010-07-30 10:04:17') AND MONTH(birth)=MONTH('2010-07-30 10:04:17')) ORDER BY last_visit DESC, near DESC, user_id LIMIT 0,5;