query:
SELECT DISTINCT
`wp_famtree_members`.`*`,
(SELECT
`wp_famtree_events`.`date`
FROM `wp_famtree_events`
INNER JOIN `wp_famtree_members2events` ON `wp_famtree_members2events`.`eventsid` = `wp_famtree_events`.`id`
WHERE
`wp_famtree_members2events`.`membersid` = `wp_famtree_members`.`id`
AND `wp_famtree_events`.`eventtypesid` = 1
) AS borned,
(SELECT
`wp_famtree_events`.`date`
FROM `wp_famtree_events`
INNER JOIN `wp_famtree_members2events` ON `wp_famtree_members2events`.`eventsid` = `wp_famtree_events`.`id`
WHERE
`wp_famtree_members2events`.`membersid` = `wp_famtree_members`.`id`
AND `wp_famtree_events`.`eventtypesid` = 2
) AS dead
FROM `wp_famtree_members`
LEFT JOIN `wp_famtree_members2events` ON `wp_famtree_members2events`.`membersid` = `wp_famtree_members`.`id`
LEFT JOIN `wp_famtree_events` ON `wp_famtree_members2events`.`eventsid` = `wp_famtree_events`.`id`
LEFT JOIN `wp_famtree_eventtypes` ON `wp_famtree_events`.`eventtypesid` = `wp_famtree_eventtypes`.`id`
WHERE
`wp_famtree_members`.`motherid` = 0
OR `wp_famtree_members`.`fatherid` = 0
ORDER BY `wp_famtree_events`.`date` ASC
mmmmm
Array
(
)
Array
(
[me] =>
)