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