Couldn't execute query. (SELECT DISTINCT m.MLS_LISTING_ID, 
						m.PROPERTY_TYPE_CODE, 
						m.CITY,
						c.city AS CODE_CITY, 
						m.SALE_PRICE, 
						m.BEDROOMS, 
						m.BATHS_TOTAL,
						m.BATHS_FULL, 
						m.BATHS_HALF, 
						m.BUILDING_SQUARE_FOOTAGE, 
						m.LOT_SQUARE_FOOTAGE, 
						m.TOTAL_LOTS, 
						m.ACRES, 
						m.SUBDIVISION, 
						m.PHOTO_IND,
						m.PHOTO_URL, 
						m.REMARKS, 
						m.FEATURE_CODES, 
						m.LAST_MLS_UPDATE_DATE,
						m.STREET_NUMBER,
						m.STREET_DIRECTION,
						m.STREET_NAME,
						m.UNIT_NUMBER
						
				 FROM mlr_MLS m,
					  mlr_MLSCityCodes c,
					  mlr_Areas_NEW a,
					  mlr_AreaMLSCities amc WHERE m.CITY_ID = c.code AND amc.idArea = a.id 
					   AND amc.idMLSCity = c.id AND ((m.LEGAL LIKE '%RIVO ALTO%' OR m.SUBDIVISION LIKE '%RIVO ALTO%' OR m.COMMUNITY_NAME LIKE '%RIVO ALTO%' OR m.REMARKS LIKE '%RIVO ALTO%' OR
m.LEGAL LIKE '%DI LIDO ISL%' OR m.SUBDIVISION LIKE '%DI LIDO ISL%' OR m.COMMUNITY_NAME LIKE '%DI LIDO ISL%' OR m.REMARKS LIKE '%DI LIDO ISL%' OR
m.LEGAL LIKE '%SAN MARINO ISL%' OR m.SUBDIVISION LIKE '%SAN MARINO ISL%' OR m.COMMUNITY_NAME LIKE '%SAN MARINO ISL%' OR m.REMARKS LIKE '%SAN MARINO ISL%' OR
m.LEGAL LIKE '%VENETIAN WAY%' OR m.SUBDIVISION LIKE '%VENETIAN WAY%' OR m.COMMUNITY_NAME LIKE '%VENETIAN WAY%' OR m.REMARKS LIKE '%VENETIAN WAY%' OR
m.LEGAL LIKE '%BELLE ISL%' OR m.SUBDIVISION LIKE '%BELLE ISL%' OR m.COMMUNITY_NAME LIKE '%BELLE ISL%' OR m.REMARKS LIKE '%BELLE ISL%' OR
m.LEGAL LIKE '%VENETIAN ISLE%' OR m.SUBDIVISION LIKE '%VENETIAN ISLE%' OR m.COMMUNITY_NAME LIKE '%VENETIAN ISLE%' OR m.REMARKS LIKE '%VENETIAN ISLE%' OR
m.LEGAL LIKE '%GRAND VENETIAN%' OR m.SUBDIVISION LIKE '%GRAND VENETIAN%' OR m.COMMUNITY_NAME LIKE '%GRAND VENETIAN%' OR m.REMARKS LIKE '%GRAND VENETIAN%')) AND m.PROPERTY_TYPE_CODE = 'S' AND m.SALE_PRICE >= '1000000' )