Do you know any good articles on Sigmund Freud theories?

Your best bet is to read The Interpretation of Dreams. Freud considered it his most important work as it set forth the dominance of the unconscious and the concept of psychic determanism. For what it's worth, he never said that kids want to have with either of their parents, ever. He talked about excitation and infantile uality as meaningful and important concepts. But people continually take this out of context about kids wanting to screw their parents.