如何将复杂的MySQL查询转换为Doctrine2

I am trying to create a weighted search using doctrine. This is how i do it in straight sql. Im wondering how i would convert it to us the doctrine2 methods. I am trying to do this search using symfony2. I am trying to create a weighted search using d