Forcing left join on my simple inner join query

Question

The site is already built from years. I am doing some modifications to it. It has controllers "Posts" and "Topics". On the topics page all recent posts are displayed. So it is a simple find of posts from "Posts" table. The fetch is not all assiciated to topic as we are showing all "Posts" and not "Topic" specific "Posts". In Topics controller, App::import('Model', 'Post'); and $Posts = new Post; are added and I call the action "getDiscussions" from Model "Post". The problem is that though I am not using any left join with "Topics" and "Users" (which is one more model used to display user details with post), the query is adding Left joins with two tables and that is giving a wrong result.

Please help.

Many Thanks Yukti

Answer 1

I think it is better to try to find out why cake is doing these "joins", rather than performing yet another forced query, so you might want to look into your model associations to check dependancies. Also, you can set $this->Posts->recursive = -1; to make sure you don't import unwanted stuff.

In the end, I am not sure what query you are trying to perform, so I can't help you further. However, here is a sample of a query I have successfully used to perform a left join, as I've noticed that many examples I found while writing my own were bugged:

$user_record = $this->User->find('first', array(
        'conditions' => array('`Openidurl`.`openid`' => $openid),
        'joins' => array(
            array(
                'table' => 'openidurls',
                'alias' => 'Openidurl',
                'type' => 'LEFT',
                'foreignKey' => 'user_id',
                'conditions'=> array('`Openidurl`.`user_id` = `User`.`id`')
            )
        )
    )
);