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