RN - Med Surg

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

SELECT DISTINCT TOP 6 d_searchableVacs.l_vacID as k_id, (SELECT tx_altText FROM d_vacancies WHERE k_id = d_searchableVacs.l_vacID) as tx_altText, d_searchableVacs.tx_benefits,d_searchableVacs.d_date,d_searchableVacs.yn_featured, d_searchableVacs.yn_branded, d_searchableVacs.yn_urgentVac, d_searchableVacs.tx_ref, d_searchableVacs.tx_jobTitle, d_searchableVacs.l_clientID, d_searchableVacs.l_currencyID, d_searchableVacs.f_salMin, d_searchableVacs.f_salMax, d_searchableVacs.b_salaryType, d_searchableVacs.l_ote, d_searchableVacs.tx_duration, d_searchableVacs.yn_showClient, d_searchableVacs.tx_city, d_searchableVacs.yn_negotiable, d_searchableVacs.tx_locations,d_searchableVacs.tx_logoImage, d_searchableVacs.tx_sectors, d_searchableVacs.tx_listItems, d_searchableVacs.tx_duration, (SELECT COUNT(k_id) as appCount FROM d_applicationItems WHERE l_itemID = d_searchableVacs.k_id) as vacAppCount, d_searchableVacs.yn_passportReq ,'' as distance, d_searchableVacs.l_agencyEmployerID FROM d_searchableVacs INNER JOIN x_vacLocations ON d_searchableVacs.l_vacID = x_vacLocations.l_vacID INNER JOIN x_vacSectors ON d_searchableVacs.l_vacID = x_vacSectors.l_vacID INNER JOIN l_durations ON d_searchableVacs.l_durationID = l_durations.k_id INNER JOIN x_vacItems ON d_searchableVacs.l_vacID = x_vacItems.l_vacID WHERE d_searchableVacs.l_vacID <> 304 AND (x_vacLocations.l_locationID IN (select x_vacLocations.l_locationID FROM x_vacLocations WHERE l_vacID = 304) ) AND (l_sectorID IN (select x_vacSectors.l_sectorID FROM x_vacSectors WHERE l_vacID = 304) ) AND (l_durationID = (SELECT l_durationID FROM d_vacancies WHERE k_id = 304)) AND (x_vacItems.l_itemID IN( SELECT k_id FROM l_listItems INNER JOIN x_vacItems ON l_listItems.k_id = x_vacItems.l_itemID WHERE l_listItems.l_listItemCategoryID = 2 AND x_vacItems.l_vacID = 304)) ORDER BY yn_branded DESC, yn_featured DESC