SELECT ncd_person_ncd_screen.pid
 ,person.birth
 ,YEAR( FROM_DAYS( DATEDIFF( NOW( ) ,person.birth ) ) ) AS age
 ,ncd_person_ncd_screen.screen_date
 ,person.dischargetype
 FROM ncd_person_ncd_screen
 INNER JOIN person ON ncd_person_ncd_screen.pcucode = person.pcucodeperson 
 AND ncd_person_ncd_screen.pid = person.pid
 WHERE person.dischargetype != 1 AND (YEAR(FROM_DAYS(DATEDIFF(NOW(),person.birth))) < 15)
 ORDER BY age;