SQL: SELECT count(e.eqid) as [found_rows] FROM VIEW_ELSAPI_Equipment e left join equip_attributes ea on [e].eqid = ea.eqid left join company c on [e].Control = c.Control WHERE ( c.MasterControl = 'AB8003566811' AND [e].Control in ('217-283-5511','217-349-8338','217-388-7717','328-2820','786-908-8606') ) AND ( (select count(EqId) from equip_photos p where p.EqId = e.EqId) > 0 )
code: 1205
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.