err#-2147467259
err desc:Transaction (Process ID 427) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(101, 76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.68352699279785 45.41230990069011,-75.70172309875488 45.40495853820099,-75.69966316223145 45.40086064220805,-75.70764541625977 45.39766648774011,-75.71022033691406 45.396641909379845,-75.70635795593262 45.394170791020564,-75.70146560668945 45.39133791264853,-75.7012939453125 45.39344751642487,-75.69597244262695 45.39411051849117,-75.69133758544922 45.394050245897446,-75.68777561187744 45.39612961323312,-75.68155288696289 45.39691312310666,-75.67889213562012 45.40040865018543,-75.68065166473389 45.40426553255637,-75.68155288696289 45.40730866795492,-75.68172454833984 45.40968882791646,-75.68352699279785 45.41230990069011)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/glebe/
Script Name: /index.asp