Description
I have a client looking to add to their MSL team, focus in Oncology. Advance degree preferred, strong KOL experience/knowledge-base in Oncology is a must.
SELECT COUNT(*) as `cnt` FROM `wp_wpjb_job` AS `t1` INNER JOIN `wp_wpjb_job_search` AS `t4` ON `t1`.`id`=`t4`.`job_id` WHERE t1.is_active = 1 AND t1.job_created_at <= '2024-10-23' AND t1.job_expires_at >= '2024-10-23' AND t1.id NOT IN('130') AND MATCH(t4.title, t4.description, t4.company, t4.location)AGAINST ('MSL Expansion -- Nationwide' IN BOOLEAN MODE) ORDER BY t1.is_featured DESC, t1.job_created_at DESC, t1.id DESC