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 '%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%')) AND m.PROPERTY_TYPE_CODE = 'M' AND m.SALE_PRICE >= '1000000' AND m.SALE_PRICE <= '3000000' )