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

SELECT DISTINCT TOP 100 PERCENT d_searchableVacs.l_vacID as k_id FROM d_searchableVacs LEFT OUTER JOIN l_subscriptionTypes ON l_subTypeID = l_subscriptionTypes.k_id INNER JOIN x_vacLocations ON d_searchableVacs.l_vacID = x_vacLocations.l_vacID INNER JOIN x_vacItems ON d_searchableVacs.l_vacID = x_vacItems.l_vacID WHERE d_searchableVacs.k_id > 0 AND l_subTypeID in (SELECT k_id FROM l_subscriptionTypes WHERE l_groupID = 1) AND d_searchableVacs.l_vacID IN (SELECT l_vacID FROM x_activeVacSectors WHERE l_sectorID IN (SELECT l_sectorID FROM x_siteSectors WHERE l_siteID = 4)) AND l_clientID = 152