SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Palma{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'Palma' OR prZip = 'Palma' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Palma{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'Palma') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}de{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}de{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'de') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Mallorca{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'Mallorca' OR prZip = 'Mallorca' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Mallorca{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'Mallorca') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}/{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}/{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = '/') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Cala{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Cala{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'Cala') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Major{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Major{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'Major') AND (prLocation LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Spain{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}Spain{28e17bab86c1b96595dc0ed973b75350d6e07fc9fed694594e8b9e544ea6b707}' OR prCountry = 'Spain')