SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Calvià{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Calvià{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCountry = 'Calvià') AND (prLocation LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}/{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}/{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCountry = '/') AND (prLocation LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Bendinat/Cas{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCity = 'Bendinat/Cas' OR prZip = 'Bendinat/Cas' OR prStreet LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Bendinat/Cas{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCountry = 'Bendinat/Cas') AND (prLocation LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Catala{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCity = 'Catala' OR prZip = 'Catala' OR prStreet LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Catala{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCountry = 'Catala') AND (prLocation LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Spain{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}Spain{1937a1d945e43a25622f00d98ea91d7dd0bef45db4b33e63d6b9940222f8612c}' OR prCountry = 'Spain')