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