Querying multiple models for similar data in CakePHP (union?)

So, I have the following example tables:

Table A:
id
name
type
hat_size
created

Table B:
id
name
type
favorite_food
created

Table C:
id
name
type
some_other_thing
created

Let's say that I want to create a search with the results of the models A, Band Cusing id, name, typeand created.

My goal would be to find all three tables ordered by one of the fields (let's say use createdas a field ORDER_BY) and limited to, for example, 20 results.

Usually I would just do Union of the field order and LIMITresult.

, , ... , paginate, .. , SQL. MVC, , .

CakePHP?

,