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