/*SELECT
        node.*,
        parent.*,
        development.*,
        property.*
      FROM
        path AS node,
        path AS parent,
        development,
        property
      WHERE
        node.lft
      BETWEEN
        parent.lft AND  parent.rgt
      AND
        node.template_type =  'Property'
      AND
        parent.level = node.level - 1
      AND
        development.id = parent.object_id
      AND
        property.id = node.object_id*/

      $q = Doctrine_Query::create()

                ->select("node.*")
                ->addSelect("parent.*")
                ->addSelect("development.*")
                ->addSelect("property.*")

                ->from("Path node")
                ->addFrom("Path parent")
                ->addFrom("Development development")
                ->addFrom("Property property")

                ->where("node.lft BETWEEN parent.lft AND parent.rgt")
                ->addWhere("node.template_type = 'Property'")
                ->addWhere("parent.level = node.level - 1")
                ->addWhere("development.id = parent.object_id")
                ->addWhere("property.id = node.object_id");
      echo $q->getSqlQuery();