php

$options = ['Properties.id' => $id];
$contains = [
    'PropertyImages' => [
        'sort' => ['PropertyImages.sort_order' => 'ASC', 'PropertyImages.id' => 'ASC']
    ],
    'PropertyPeriods' => [
        'sort' => [
            'PropertyPeriods.start_date' => 'ASC'
        ],
        'Properties' => [
            'Rooms' => [
               'PropertyPrices' => function($q) {
                    return $q
                        ->select(['PropertyPrices.room_id'])
                        ->where([
                            'Rooms.id' => 'PropertyPrices.room_id'
                        ])
                    ;
                }
            ]
        ]
    ],
];

$property = $this->Properties->find()->where($options)->contain($contains)->first();