Query to fetch latest rows data of second table CakePHP 3.x.

Query to fetch latest rows data of second table of a JOIN and all conditions as per the data of second table in CakePHP 3.x.

$inID = $this->TestOptions->OptionValues->find(); $inID = $inID->select(['opt_val' => $inID->func()->max('OptionValues.created')])->group(['OptionValues.option_id']); $res = $this->TestOptions->find() ->contain(['OptionValues']) ->where('TestOptions.id = OptionValues.option_id') ->where("OptionValues.created IN ($inID) AND DATE(OptionValues.created) > DATE('2016-06-10') AND DATE(OptionValues.created) < DATE('2016-06-19')") ->group('OptionValues.option_id') ->order('OptionValues.created DESC'); pr($res->toArray());