SELECT COUNT(u.user_id) FROM user AS u WHERE u.user_id!=0 AND hide_time=0 AND (DAYOFMONTH(birth)=DAYOFMONTH('2012-02-06 00:11:27') AND MONTH(birth)=MONTH('2012-02-06 00:11:27'));
SELECT u.*, YEAR(FROM_DAYS(TO_DAYS('2012-02-06 00:11:27')-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('2012-02-06 00:11:27') AND MONTH(birth)=MONTH('2012-02-06 00:11:27')) ORDER BY last_visit DESC, near DESC, user_id LIMIT 0,5; Free Dating Site and Free Online Dating Service
Profile View
Gallery View
List View
Send IM
