how to write following query in cakephp 2.x

Question

SELECT categories.category_name, categories.status, experts.name, experts.email, expert_categories.category_id, expert_categories.expert_id 
FROM categories, experts, expert_categories 
WHERE expert_categories.category_id = categories.id AND expert_categories.expert_id = experts.id AND categories.status = 'A'

Answer 1

If you know what you want then go with prepared statement:

 $db = $this->Category->getDataSource(); // if you make function in categories controller
 // $db = $this->getDataSource(); // if you make function in any model

 $result = $db->fetchAll("SELECT categories.category_name,categories.status,
       experts.name, experts.email, expert_categories.category_id, 
       expert_categories.expert_id FROM categories, experts, expert_categories 
       WHERE expert_categories.category_id = categories.id AND
       expert_categories.expert_id = experts.id AND categories.status = 'A'");

 // debug($result);

That is why cakephp prepared statement are made.

See here: Cakephp2 prepared statement.