SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Palma{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCity = 'Palma' OR prZip = 'Palma' OR prStreet LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Palma{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCountry = 'Palma') AND (prLocation LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}de{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}de{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCountry = 'de') AND (prLocation LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Mallorca{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCity = 'Mallorca' OR prZip = 'Mallorca' OR prStreet LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Mallorca{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCountry = 'Mallorca') AND (prLocation LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Spanien{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCity = 'Spanien' OR prZip = 'Spanien' OR prStreet LIKE '{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}Spanien{b32187af300077ecb1a5e2af6f6e3017c0ad689f0526493837a68afa9659a8c3}' OR prCountry = 'Spanien')