| Server IP : 172.64.80.1 / Your IP : 172.70.131.126 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admin_main/ |
Upload File : |
select `a`.`formNo` AS `formNo`,concat(`a`.`surname`,' ',`a`.`otherNames`) AS `names`,`a`.`level` AS `level`,`a`.`option` AS `course`,`a`.`state` AS `state`,`f`.`point` AS `ndpoint`,`c`.`score` AS `score`,(((`c`.`score` / 70) * 80) + `f`.`point`) AS `aggregate`,`d`.`olevel1` AS `olevel1`,`d`.`olevel2` AS `olevel2`,`e`.`inst` AS `inst`,`e`.`course` AS `ndCourse`,`e`.`result` AS `result`,`a`.`admStatus` AS `admstatus` from ((((`fedpoly`.`stddata` `a` left join `fedpoly`.`cbtscore` `c` on((`c`.`formNo` = `a`.`formNo`))) left join `fedpoly`.`preolevel` `d` on((`d`.`formNo` = `a`.`formNo`))) left join `fedpoly`.`ndresult` `e` on((`e`.`formNo` = `a`.`formNo`))) left join `fedpoly`.`ndgradepoint` `f` on((`f`.`grade` = convert(`e`.`result` using utf8)))) where (`a`.`level` in ('hdptForm','hndForm'))