SELECT
							tracker_main.id,
							tracker_main.path,
							tracker_main.param,
							tracker_main.href,
							tracker_main.ip,
							tracker_main.full,
							tracker_main.route,
							tracker_main.city,
							tracker_main.state,
							tracker_main.postcode,
							tracker_main.country_long,
							tracker_main.country_short,
							tracker_main.lat,
							tracker_main.long,
							tracker_main.org,
							DATE_FORMAT(tracker_main.datetime,'%Y-%m-%d %h:%i %p') datetime
						FROM salihin_cms.tracker_main
						WHERE UPPER(path) = 'CAREERS/VIEW/'
						AND param = 10
						ORDER BY datetime DESC