SELECT COUNT(u.user_id) FROM user AS u WHERE u.user_id!=0 AND hide_time=0 AND (DAYOFMONTH(birth)=DAYOFMONTH('2010-09-06 07:52:55') AND MONTH(birth)=MONTH('2010-09-06 07:52:55'));
SELECT u.*, YEAR(FROM_DAYS(TO_DAYS('2010-09-06 07:52:55')-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-09-06 07:52:55') AND MONTH(birth)=MONTH('2010-09-06 07:52:55')) ORDER BY last_visit DESC, near DESC, user_id LIMIT 2,1;