ORDER BY `id` = :id DESC, `date`
SELECT *
FROM `primary`
WHERE `id` IN (
SELECT `s`.`primary_id`
FROM (
SELECT `primary_id`, MAX(`datetime`) AS `datetime`
FROM `secondary`
GROUP BY `primary_id`
) AS `t`
JOIN `secodary` AS `s` ON `s`.`state` = 1
AND `s`.`primary_id` = `t`.`primary_id`
AND `s`.`datetime` = `t`.`datetime`
)
CREATE TABLE `students` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`group` VARCHAR(20) NOT NULL,
`name` TINYTEXT,
`surname` TINYTEXT,
`patronymic` TINYTEXT,
`address` TINYTEXT,
`homePhone` TINYTEXT,
`contactPhone` VARCHAR(12) NOT NULL,
`yearOfEntry` DATE,
`avgGradePoint` FLOAT,
);