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

SELECT DISTINCT TOP 6 d_vacancies.f_salMin, d_vacancies.d_expires, l_durations.tx_duration, d_vacancies.f_salMax, d_vacancies.l_currencyID, d_vacancies.b_salaryType, d_vacancies.m_info2, d_vacancies.m_info1, d_vacancies.tx_benefits, d_vacancies.l_clientID, d_vacancies.tx_jobTitle,d_vacancies.k_id AS vacID, d_vacancies.tx_ref AS tx_ref, d_clients.tx_company,d_clients.yn_activated, d_clients.k_id AS cliID ,d_vacancies.d_date as vacDate, d_vacancies.tx_city, dbo.fn_getVacLocationList(d_vacancies.k_id) as locs, dbo.fn_getVacItemList(d_vacancies.k_id) as listItems, dbo.fn_getvacSectorList(d_vacancies.k_id) as secs FROM d_vacancies INNER JOIN d_clients ON d_vacancies.l_clientID = d_clients.k_id LEFT JOIN x_vacSectors on d_vacancies.k_id = x_vacSectors.l_vacID INNER JOIN l_durations ON d_vacancies.l_durationID = l_durations.k_id WHERE (d_clients.yn_activated = 1) AND (d_vacancies.yn_activated = 1) AND (d_vacancies.yn_filled = 0) ORDER BY d_vacancies.k_id DESC