An error occurred executing the following query;

SELECT DISTINCT TOP 20 VAC_Title,substring(VAC_Description,0,100) as shortdesc, VAC_Location, VAC_ID, VAC_DateEntered FROM ((tblCactusVacancies INNER JOIN tblCactusVacanciesLanguagesLink ON tblCactusVacancies.VAC_ID = tblCactusVacanciesLanguagesLink.VAC_LANG_VacancyID) INNER JOIN tblCactusAgencies ON VAC_AgencyID = AG_ID) WHERE (AG_Jobslive = 'y' AND AG_Live = 'y' AND VAC_Live = 'y' AND VAC_DateEntered > '2010/8/11 11:37:59 AM') and (VAC_LANG_LanguageID in (2,104,130)) ORDER BY VAC_DateEntered DESC

Error Description :

Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Page of error :

/404handler.asp

Query String :

404;http://www.jobs4scunthorpe.co.uk:80/viewjob-194454