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