SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Venda{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCity = 'Venda' OR prZip = 'Venda' OR prStreet LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Venda{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCountry = 'Venda') AND (prLocation LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}do{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCity = 'do' OR prZip = 'do' OR prStreet LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}do{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCountry = 'do') AND (prLocation LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Pinheiro{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCity = 'Pinheiro' OR prZip = 'Pinheiro' OR prStreet LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Pinheiro{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCountry = 'Pinheiro') AND (prLocation LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Portugal{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCity = 'Portugal' OR prZip = 'Portugal' OR prStreet LIKE '{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}Portugal{49dc92bea34e004526efd29da6953d854d50d50caf2d867283dfd4f0ed1367e7}' OR prCountry = 'Portugal')