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`
)$propertyArr = array();
$propertyArr[] = new SoapVar(
(object)['name' => 'Birthday', 'value' => '1999-01-01T00:00:00'],
SOAP_ENC_OBJECT,
'Property',
'core');
$propertyArr[] = new SoapVar(
(object)['name' => 'Duration', 'value' => '0001-01-01T00:30:00'],
SOAP_ENC_OBJECT,
'Property',
'core');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