SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Cala{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Cala{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCountry = 'Cala') AND (prLocation LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Major{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Major{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCountry = 'Major') AND (prLocation LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Spain{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}Spain{18b55b42c2c410959c9042d4875a021e98a848a1213440ac75d45c4e0400e59f}' OR prCountry = 'Spain')