SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Calvià{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Calvià{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCountry = 'Calvià') AND (prLocation LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}/{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}/{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCountry = '/') AND (prLocation LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Cala{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Cala{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCountry = 'Cala') AND (prLocation LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Vinyes{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCity = 'Vinyes' OR prZip = 'Vinyes' OR prStreet LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Vinyes{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCountry = 'Vinyes') AND (prLocation LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Spain{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}Spain{7cdab816aaf548c5300b72debe51c3c74ad452b5585ea5f998102a128d74ed15}' OR prCountry = 'Spain')