err desc:The query processor could not start the necessary thread resources for parallel query execution.
sql:SELECT TOP 50 ID, List_Price, Photos_Updated_Timestamp, Address, Municipality, MLS_Number, List_Broker, Listing_Agent, Bedrooms, Bedrooms_Plus, Washrooms, ImagePathOfFirstImage, Sale_Lease FROM PropertiesFreeholdAndCondos WITH(NOLOCK) Where Status = 'A' AND List_Broker = 'OTTAWA PROPERTY SHOP REALTY INC.' AND (Agent_ID != '1819955' OR Agent_ID IS NULL) AND IDX_Approved = 1 AND Board IN(76,82) AND Sale_Lease = 'Sale' ORDER BY ID DESC
Query String:
Script Name: /index.asp