SELECT
							 career_main.ID,
							 career_main.title,
							 career_main.position,
							 career_main.image,
							 DATE_FORMAT(career_main.startDT,'%d/%m/%Y') startDT,
							 DATE_FORMAT(career_main.endDT,'%d/%m/%Y') endDT,
							 career_main.status
						FROM  salihin_cms.career_main
						WHERE 1 = 1  AND  career_main.status IN ('PUBLISHED')  ORDER BY title ASC