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