SELECT * FROM qry_exhibits_nl WHERE (PraxisPal=1 AND StartDate >= '2024-08-01 00:00:00' AND StartDate <= '2024-09-01 00:00:00' AND Country='United States' AND State<>'(Outside USA)' AND State='Rhode Island' AND nl_type='FESTIVAL') OR (top_pick=1 AND StartDate >= '2024-08-01 00:00:00' AND StartDate <= '2024-09-01 00:00:00' AND Country='United States' AND State<>'(Outside USA)' AND State='Rhode Island' AND nl_type='FESTIVAL') ORDER BY StartDate;
-2147467259
Transaction (Process ID 431) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.