Featured Employers in Resumes

An error occurred executing the following query;

SELECT DISTINCT AG_ID, AG_Agency, AG_URL, AG_LinkTo, dbo.GetRegion(AG_Postcode) As strRegion, NEWID() AS RandomID FROM (SELECT DISTINCT tblCactusAgencies.AG_ID, tblCactusAgencies.AG_Agency, tblCactusAgencies.AG_URL, tblCactusAgencies.AG_Postcode, tblCactusAgencies.AG_LinkTo FROM tblCactusAgencies INNER JOIN tblCactusVacancies ON tblCactusAgencies.AG_ID = tblCactusVacancies.VAC_AgencyID INNER JOIN tblCactusVacanciesRegionsLink ON tblCactusVacancies.VAC_ID = tblCactusVacanciesRegionsLink.VAC_REG_VacancyID INNER JOIN tblCactusRegions ON tblCactusVacanciesRegionsLink.VAC_REG_RegionID = tblCactusRegions.REG_ID INNER JOIN tblCactusInvoicing ON tblCactusAgencies.AG_ID = tblCactusInvoicing.INV_AG_ID WHERE (tblCactusRegions.REG_StateID = ) AND (ISNULL(tblCactusInvoicing.INV_Paid, N'y') = 'y') AND (tblCactusVacancies.VAC_Live = 'y') AND (tblCactusAgencies.AG_Live = 'y') AND (tblCactusAgencies.AG_Featured = 'y') AND (tblCactusVacancies.VAC_RealDateEntered > '1/7/2012 12:56:44 PM') AND (tblCactusVacancies.VAC_BlindPost = 'n')) AS Newtable2 ORDER BY RandomID

Error Description :

Incorrect syntax near ')'.

Page of error :

/404handler.asp

Query String :

404;http://resumes.localjobs.com:80/Resumes/help/help_XpertAdvice.htm