Comment to Ages can be -1?
-
Hello George!
It seems that query SELECT `c`.*, `p`.`account_id`, `p`.`id` AS `profile_id`, `a`.`email` AS `profile_email`, `p`.`status` AS `profile_status` FROM `bx_persons_data` AS `c` INNER JOIN `sys_profiles` AS`p` ON (`p`.`content_id` = `c`.`id` AND `p`.`type` = 'bx_persons') INNER JOIN `sys_accounts` AS `a` ON (`p`.`account_id` = `a`.`id`) WHERE c.`id`=[number of profile] returns incorrect result or field `birthday` has wrong value (like from future year).