query for join some tables

[mrezagolestan]

my tables structure:

estates (id)
estates_esspecvalues (estate_id,esspecvalue_id)
esspecvalues(id,esspecattribute_id,title)
esspecattributes(id,title)

i want to have a query for join this 4 table , i need output as an array to manipulate that.

output array should have

estates.id , esspecvalues.title , esspecattributes.(id , title)

when im using find and contain esspecvalues its done because my estates table have association with esspecvalues but i can`t contain esspecattributes

[AD7six]

This is not a help forum. The ticket tracker is reserved for possible
bugs and feature enhancements to the CakePHP framework. If you are
looking for help on how to implement a feature or to better understand
how to use the framework correctly, please visit one of the following:

The CakePHP Manual
The CakePHP online API
The CakePHP Google Group
Stackoverflow

or the #cakephp channel on irc.freenode.net, where we will be more than
happy to help answer your questions.

Thanks!

[markstory]

I would first figure out how to write the sql you need. After that you can use the querybuilder to replicate that sql.