PharmaJobs-Ireland.com
Title
Pharmajobs-Ireland.com
Description
Excerpted from the website:
- SELECT VAC_ID, VAC_Title, VAC_Live, VAC_DateEntered,VAC_ApplyURL, AG_JobsLive FROM (tblCactusVacancies INNER JOIN (tblCactusConsultants INNER JOIN tblCactusAgencies ON tblCactusConsultants.CON_AgencyID = tblCactusAgencies.AG_ID) ON tblCactusVacancies.VAC_ConsultantID = tblCactusConsultants.CON_ID) INNER JOIN tblCactusJobStatus ON tblCactusVacancies.VAC_JobStatusID = tblCactusJobStatus.JSTAT_ID WHERE AG_Jobslive='y' AND AG_Live = 'y' AND VAC_Live='y' AND VAC_DateEntered > '2007/7/14 12:37' AND VAC_ID IN (,lang=numLanguageID=4,ASPSESSIONIDCASRSAAD=PIPJFHMBDPDDCAAHIAOHBKOD) ORDER BY VAC_Title