SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Calvià{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Calvià{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = 'Calvià') AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}/{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}/{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = '/') AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Costa{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = 'Costa' OR prZip = 'Costa' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Costa{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = 'Costa') AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}d\\\\\'en{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = 'd\\\\\'en' OR prZip = 'd\\\\\'en' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}d\\\\\'en{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = 'd\\\\\'en') AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Blanes{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = 'Blanes' OR prZip = 'Blanes' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Blanes{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = 'Blanes') AND (prLocation LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Spain{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}Spain{bbaaa7ce4e2de9ca4cbd4b9ee5c1e90b1185dace8a6c05b6ecef71dc9e872536}' OR prCountry = 'Spain')