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