Comment to 'Ages can be -1?'
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).