SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Calvià{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Calvià{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCountry = 'Calvià') AND (prLocation LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}/{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}/{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCountry = '/') AND (prLocation LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Magaluf{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCity = 'Magaluf' OR prZip = 'Magaluf' OR prStreet LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Magaluf{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCountry = 'Magaluf') AND (prLocation LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Spain{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}Spain{a4f56869441aefd6a92e424093c02eb54aa479341acb70569c776b257c8a4ef0}' OR prCountry = 'Spain')