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