|
SELECT mr.member_id, mr.title, mr.age, if(m.language=2,'serious-dating','rencontre-serieuse') as section
FROM member as m
INNER JOIN member_serious as mr
ON mr.member_id=m.member_id
WHERE
and m.state='2'
ORDER BY mr.last_visit_date desc, mr.age LIMIT 350
|