Certificate for (ID : ) |
|
No certificate has been awarded to this jobseeker.
|
|
| Personal Details |
|
| First Name : |
|
| Surname : |
|
| Maiden Name : |
|
| ID Number : |
|
|
| Verification Request History |
| ID Number |
Order Number |
First Name |
Surname |
Date Requested |
ERROR!!1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (o.order_work_status='8' or o.order_work_status='10') AND j.jobseeker_key !=' at line 2
QUERY
select o.order_id,o.order_pending_date,o.order_pending_reason,d.datasheet_data,j.jobseeker_fname as fname,j.jobseeker_sname as sname,j.jobseeker_idno as IDNUM,j.jobseeker_vcno as CERT_NUM,j.jobseeker_key,d.jobseeker_id,d.datasheet_pack,datasheet_certificate,o.order_id,o.order_date,o.order_work_status from vreport_datasheet as d
INNER JOIN vreport_jobseeker as j ON j.jobseeker_id=d.jobseeker_id LEFT JOIN vreport_order as o ON d.datasheet_order=o.order_id WHERE j.jobseeker_idno = AND (o.order_work_status='8' or o.order_work_status='10') AND j.jobseeker_key != '' order by order_date desc
|
|
|
|
|
|
