SELECT
							ID, applno,
							SUBSTRING(CONCAT(IFNULL(firstname,''),' ',IFNULL(lastname,'')), 1, 20) name,
							createdDT elDT,
							DATE_FORMAT(createdDT, '%d/%m/%Y %H:%i %p') createdDT
						FROM salihin_cms.career_applicant
						WHERE status IN ('DRAFT', 'ACTIVE')
						ORDER BY createdDT DESC