SELECT
							ID,
							title,
							position,
							description,
							requirement,
							image,
							salary,
							DATE_FORMAT(startDT, '%d/%m/%Y') startDT,
							DATE_FORMAT(endDT, '%d/%m/%Y') endDT,
							quota,
							showSalary,
							showStartDT,
							showEndDT,
							showQuota,
							canApplyOnline,
							status,
							DATE_FORMAT(createdDT, '%Y-%m-%d %H:%i:%s') createdDT,
							DATE_FORMAT(updatedDT, '%Y-%m-%d %H:%i:%s') updatedDT,
							IFNULL((SELECT penName FROM salihin_cms.people, salihin_cms.user WHERE user.peopleID = people.ID AND user.ID =  career_main.createdBy),'admin') createdBy,
							IFNULL((SELECT penName FROM salihin_cms.people, salihin_cms.user WHERE user.peopleID = people.ID AND user.ID =  career_main.updatedBy),'admin') updatedBy		
						FROM salihin_cms.career_main
						WHERE career_main.ID = 10