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`
)
idmap config NT AUTHORITY : base_rid = 0
idmap config NT AUTHORITY : range = 1200000-1299999
idmap config NT AUTHORITY : backend = rid
idmap config BUILTIN : base_rid = 0
idmap config BUILTIN : range = 1000000-1099999
idmap config BUILTIN : backend = rid
idmap config ваш_домен : base_rid = 100
idmap config ваш_домен : range = 100-999999
idmap config ваш_домен : backend = rid
idmap config ваш_домен : default = yes
idmap config * : range = 1300000-1999999
idmap config * : backend = rid
acl:
admin:
user:
- "pupkin_v": "example.com"
- "sidorov": "example.com"
local:
server: "example.com"
access_rules:
...
muc_admin:
- allow: admin
muc_create:
- allow: local
muc:
- allow
...
modules:
...
mod_muc:
db_type: mnesia
access:
- allow
access_admin: muc_admin
access_create: muc_create
access_persistent: muc_create
...
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,
);