TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`fkInspection` AS `fkInspection`,`jjlourens2`.`job`.`fkLeakDetection` AS `fkLeakDetection`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone`,`jjlourens2`.`job`.`fkInsApproval` AS `fkInsApproval`,`jjlourens2`.`job`.`fkExcessDelay` AS `fkExcessDelay`,`jjlourens2`.`job`.`fkInvoiced` AS `fkInvoiced`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`fkReportSent` AS `fkReportSent`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fkExcessGet` AS `fkExcessGet`,`jjlourens2`.`job`.`fkquote` AS `fkquote`,`jjlourens2`.`job`.`fkproofpay` AS `fkproofpay`,`jjlourens2`.`job`.`fkInvoice1` AS `fkInvoice1`,`jjlourens2`.`job`.`fkReportFinal` AS `fkReportFinal`,`jjlourens2`.`job`.`fkbluecard` AS `fkbluecard`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`setup_user2`.`pk_user` AS `pkuser2`,`setup_user2`.`userName` AS `finUsername`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job`.`fkCloseFile` AS `fkCloseFile`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job`.`finDelay` AS `finDelay` from ((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`userInCharge`))) join `jjlourens2`.`setup_user` `setup_user2` on((`setup_user2`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`)))
md5=bd60712017927cbcc025bcd4f2788fcb
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2023-10-17 19:02:51
create-version=1
source=select `clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`pk_job` AS `pk_job`,`job`.`jbdate` AS `jbdate`,`job`.`fkInspection` AS `fkInspection`,`job`.`fkLeakDetection` AS `fkLeakDetection`,`job`.`fkJobDone` AS `fkJobDone`,`job`.`fkInsApproval` AS `fkInsApproval`,`job`.`fkExcessDelay` AS `fkExcessDelay`,`job`.`fkInvoiced` AS `fkInvoiced`,`job`.`userInCharge` AS `userInCharge`,`setup_user`.`pk_user` AS `pk_user`,`setup_user`.`userName` AS `userName`,`job`.`fkReportSent` AS `fkReportSent`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`fkExcessGet` AS `fkExcessGet`,`job`.`fkquote` AS `fkquote`,`job`.`fkproofpay` AS `fkproofpay`,`job`.`fkInvoice1` AS `fkInvoice1`,`job`.`fkReportFinal` AS `fkReportFinal`,`job`.`fkbluecard` AS `fkbluecard`,`job`.`finuInCharge` AS `finuInCharge`,`setup_user2`.`pk_user` AS `pkuser2`,`setup_user2`.`userName` AS `finUsername`,`job_schedule`.`jobCat` AS `jobCat`,`job`.`fkCloseFile` AS `fkCloseFile`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job`.`finDelay` AS `finDelay` from ((((`job` join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`userInCharge`))) join `setup_user` `setup_user2` on((`setup_user2`.`pk_user` = `job`.`finuInCharge`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`fkInspection` AS `fkInspection`,`jjlourens2`.`job`.`fkLeakDetection` AS `fkLeakDetection`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone`,`jjlourens2`.`job`.`fkInsApproval` AS `fkInsApproval`,`jjlourens2`.`job`.`fkExcessDelay` AS `fkExcessDelay`,`jjlourens2`.`job`.`fkInvoiced` AS `fkInvoiced`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`fkReportSent` AS `fkReportSent`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fkExcessGet` AS `fkExcessGet`,`jjlourens2`.`job`.`fkquote` AS `fkquote`,`jjlourens2`.`job`.`fkproofpay` AS `fkproofpay`,`jjlourens2`.`job`.`fkInvoice1` AS `fkInvoice1`,`jjlourens2`.`job`.`fkReportFinal` AS `fkReportFinal`,`jjlourens2`.`job`.`fkbluecard` AS `fkbluecard`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`setup_user2`.`pk_user` AS `pkuser2`,`setup_user2`.`userName` AS `finUsername`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job`.`fkCloseFile` AS `fkCloseFile`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job`.`finDelay` AS `finDelay` from ((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`userInCharge`))) join `jjlourens2`.`setup_user` `setup_user2` on((`setup_user2`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`)))
mariadb-version=50568