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.ZIP_CODE = '33140' OR m.ZIP_CODE = '33141' OR m.CITY_ID = 'Y22391') OR (m.CITY_ID = 'Y27293') OR (m.CITY_ID = 'Y22388') OR (m.CITY_ID = 'Y22163') OR (m.CITY_ID = 'Y23064') OR (m.CITY_ID = '000016') OR (m.ZIP_CODE = '33139' OR m.CITY_ID = 'Y22391') OR (m.CITY_ID = 'Y21609') OR (m.ZIP_CODE = '33131' OR m.ZIP_CODE = '33130' OR m.ZIP_CODE = '33129' OR m.CITY_ID = 'Y27384') OR (m.CITY_ID = '003586') OR (m.CITY_ID = 'Y21628') OR (m.CITY_ID = 'Y21405' OR m.CITY_ID = 'Y21419' ) OR (m.CITY_ID = '001463') OR (m.LEGAL LIKE '%COCOPLUM%' OR m.SUBDIVISION LIKE '%COCOPLUM%' OR m.COMMUNITY_NAME LIKE '%COCOPLUM%' OR m.REMARKS LIKE '%COCOPLUM%') OR (m.LEGAL LIKE '%PONCE DAVIS%' OR m.SUBDIVISION LIKE '%PONCE DAVIS%' OR m.COMMUNITY_NAME LIKE '%PONCE DAVIS%' OR m.REMARKS LIKE '%PONCE DAVIS%') OR ((m.STREET_NAME LIKE '%Brickell Key%' OR m.STREET_NAME LIKE '%Claughton Island%')  AND m.ZIP_CODE = '33131') OR (m.LEGAL LIKE '%GABLES EST%' OR m.SUBDIVISION LIKE '%GABLES EST%' OR m.COMMUNITY_NAME LIKE '%GABLES EST%' OR m.REMARKS LIKE '%GABLES EST%') OR (m.CITY = 'Aventura' AND
m.STREET_NAME LIKE '%island%') OR (m.LEGAL LIKE '%DEERING BAY%' OR m.SUBDIVISION LIKE '%DEERING BAY%' OR m.COMMUNITY_NAME LIKE '%DEERING BAY%' OR m.REMARKS LIKE '%DEERING BAY%') OR (m.LEGAL LIKE '%HAMMOCK LAKE%' OR m.SUBDIVISION LIKE '%HAMMOCK LAKE%' OR m.COMMUNITY_NAME LIKE '%HAMMOCK LAKE%' OR m.REMARKS LIKE '%HAMMOCK LAKE%' OR
m.LEGAL LIKE '%HAMMOCK OAK%' OR m.SUBDIVISION LIKE '%HAMMOCK OAK%' OR m.COMMUNITY_NAME LIKE '%HAMMOCK OAK%' OR m.REMARKS LIKE '%HAMMOCK OAK%') OR (m.LEGAL LIKE '%TAHITI BEACH%' OR m.SUBDIVISION LIKE '%TAHITI BEACH%' OR m.COMMUNITY_NAME LIKE '%TAHITI BEACH%' OR m.REMARKS LIKE '%TAHITI BEACH%') OR (m.LEGAL LIKE '%GABLES BY THE SEA%' OR m.SUBDIVISION LIKE '%GABLES BY THE SEA%' OR m.COMMUNITY_NAME LIKE '%GABLES BY THE SEA%' OR m.REMARKS LIKE '%GABLES BY THE SEA%') OR (m.LEGAL LIKE '%BELLE MEADE%' OR m.SUBDIVISION LIKE '%BELLE MEADE%' OR m.COMMUNITY_NAME LIKE '%BELLE MEADE%' OR m.REMARKS LIKE '%BELLE MEADE%') OR (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%') OR (m.LEGAL LIKE '%SUNSET LAKE%' OR m.SUBDIVISION LIKE '%SUNSET LAKE%' OR m.COMMUNITY_NAME LIKE '%SUNSET LAKE%' OR m.REMARKS LIKE '%SUNSET LAKE%' OR
m.LEGAL LIKE '%SUNSET ISL%' OR m.SUBDIVISION LIKE '%SUNSET ISL%' OR m.COMMUNITY_NAME LIKE '%SUNSET ISL%' OR m.REMARKS LIKE '%SUNSET ISL%') OR (m.ZIP_CODE = '33109') OR (m.LEGAL LIKE '%KEYSTONE POINT%' OR m.SUBDIVISION LIKE '%KEYSTONE POINT%' OR m.COMMUNITY_NAME LIKE '%KEYSTONE POINT%' OR m.REMARKS LIKE '%KEYSTONE POINT%' OR
m.LEGAL LIKE '%KEYSTONE HARBOR CLUB%' OR m.SUBDIVISION LIKE '%KEYSTONE HARBOR CLUB%' OR m.COMMUNITY_NAME LIKE '%KEYSTONE HARBOR CLUB%' OR m.REMARKS LIKE '%KEYSTONE HARBOR CLUB%' OR 		
m.LEGAL LIKE '%KEYSTONE ISL%' OR m.SUBDIVISION LIKE '%KEYSTONE ISL%' OR m.COMMUNITY_NAME LIKE '%KEYSTONE ISL%' OR m.REMARKS LIKE '%KEYSTONE ISL%' OR 		
m.LEGAL LIKE '%KEYSTONE BAY%' OR m.SUBDIVISION LIKE '%KEYSTONE BAY%' OR m.COMMUNITY_NAME LIKE '%KEYSTONE BAY%' OR m.REMARKS LIKE '%KEYSTONE BAY%' OR 		
m.LEGAL LIKE '%KEYSTONE TOWER%' OR m.SUBDIVISION LIKE '%KEYSTONE TOWER%' OR m.COMMUNITY_NAME LIKE '%KEYSTONE TOWER%' OR m.REMARKS LIKE '%KEYSTONE TOWER%') OR (m.LEGAL LIKE '%EASTERN SHORE%' OR m.SUBDIVISION LIKE '%EASTERN SHORE%' OR m.COMMUNITY_NAME LIKE '%EASTERN SHORE%' OR m.REMARKS LIKE '%EASTERN SHORE%') OR  m.ZIP_CODE = '33141' OR  m.ZIP_CODE = '33140' OR  m.ZIP_CODE = '33139' OR  m.ZIP_CODE = '33132' OR  m.ZIP_CODE = '33109') AND ( m.ZIP_CODE = '33141' OR  m.ZIP_CODE = '33140' OR  m.ZIP_CODE = '33139' OR  m.ZIP_CODE = '33132' OR  m.ZIP_CODE = '33109')  AND ( m.SUBDIVISION LIKE "%ALLISON ISLAND%" OR m.COMMUNITY_NAME LIKE "%ALLISON ISLAND%" OR  m.SUBDIVISION LIKE "%ALTOS DEL MARALTOS DEL MAR%" OR m.COMMUNITY_NAME LIKE "%ALTOS DEL MARALTOS DEL MAR%" OR  m.SUBDIVISION LIKE "%BISCAYNE BEACH%" OR m.COMMUNITY_NAME LIKE "%BISCAYNE BEACH%" OR  m.SUBDIVISION LIKE "%BISCAYNE POINT%" OR m.COMMUNITY_NAME LIKE "%BISCAYNE POINT%" OR  m.SUBDIVISION LIKE "%DI LIDO ISLAND%" OR m.COMMUNITY_NAME LIKE "%DI LIDO ISLAND%" OR  m.SUBDIVISION LIKE "%FISHER ISLAND%" OR m.COMMUNITY_NAME LIKE "%FISHER ISLAND%" OR  m.SUBDIVISION LIKE "%HIBISCUS ISLAND%" OR m.COMMUNITY_NAME LIKE "%HIBISCUS ISLAND%" OR  m.SUBDIVISION LIKE "%INDIAN CREEK%" OR m.COMMUNITY_NAME LIKE "%INDIAN CREEK%" OR  m.SUBDIVISION LIKE "%LA GORCE%" OR m.COMMUNITY_NAME LIKE "%LA GORCE%" OR  m.SUBDIVISION LIKE "%ISLE OF NORMANDY%" OR m.COMMUNITY_NAME LIKE "%ISLE OF NORMANDY%" OR  m.SUBDIVISION LIKE "%NORMANDY GOLF%" OR m.COMMUNITY_NAME LIKE "%NORMANDY GOLF%" OR  m.SUBDIVISION LIKE "%NORMANDY WATER%" OR m.COMMUNITY_NAME LIKE "%NORMANDY WATER%" OR  m.SUBDIVISION LIKE "%NORTH BAY VILLAGE%" OR m.COMMUNITY_NAME LIKE "%NORTH BAY VILLAGE%" OR  m.SUBDIVISION LIKE "%NORTH BAY ISLAND%" OR m.COMMUNITY_NAME LIKE "%NORTH BAY ISLAND%" OR  m.SUBDIVISION LIKE "%NORTH BAY VILLAS%" OR m.COMMUNITY_NAME LIKE "%NORTH BAY VILLAS%" OR  m.SUBDIVISION LIKE "%PALM ISLAND%" OR m.COMMUNITY_NAME LIKE "%PALM ISLAND%" OR  m.SUBDIVISION LIKE "%STAR ISLAND%" OR m.COMMUNITY_NAME LIKE "%STAR ISLAND%" OR  m.SUBDIVISION LIKE "%SUNSET HARBOUR%" OR m.COMMUNITY_NAME LIKE "%SUNSET HARBOUR%" OR  m.SUBDIVISION LIKE "%SUNSET ISLAND%" OR m.COMMUNITY_NAME LIKE "%SUNSET ISLAND%" OR  m.SUBDIVISION LIKE "%VENETIAN%" OR m.COMMUNITY_NAME LIKE "%VENETIAN%")  AND (m.PROPERTY_TYPE_CODE = 'S' OR m.PROPERTY_TYPE_CODE = 'M')  AND m.SALE_PRICE >= '500000' )