string(581) " SELECT u.uname, YEAR(CURDATE()) - YEAR(STR_TO_DATE(us.T1,'%d/%m/%Y')) + 1 AS age_avenir, DATEDIFF( DATE_ADD( STR_TO_DATE(CONCAT(YEAR(CURDATE()), '/', RIGHT(us.T1,5)), '%Y/%m/%d'), INTERVAL (STR_TO_DATE(CONCAT(YEAR(CURDATE()), '/', RIGHT(us.T1,5)), '%Y/%m/%d') < CURDATE()) YEAR ), CURDATE() ) AS jours FROM users_extend us INNER JOIN users u ON u.uid = us.uid INNER JOIN users_status s ON s.uid = u.uid WHERE s.open = '1' HAVING jours BETWEEN 1 AND 10 ORDER BY jours ASC, u.uname ASC "