TYPE=VIEW query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`capDate` AS `capDate`,`jjlourens2`.`job_schedule`.`capUser` AS `capUser`,`jjlourens2`.`job_schedule`.`fk_plumber` AS `fk_plumber`,`jjlourens2`.`job_schedule`.`jobdescription` AS `jobdescription`,`jjlourens2`.`job_schedule`.`cancellTime` AS `cancellTime`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_schedule`.`cancelReason` AS `cancelReason`,`jjlourens2`.`job_schedule`.`cancelluser` AS `cancelluser`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job_schedule`.`jobDoneInfo` AS `jobDoneInfo`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`jobDoneUser` AS `jobDoneUser`,`jjlourens2`.`job_schedule`.`jobDoneTime` AS `jobDoneTime`,`jjlourens2`.`job_schedule`.`isActive` AS `isActive`,`jjlourens2`.`job_schedule`.`timeStart` AS `timeStart`,`jjlourens2`.`job_schedule`.`timeFinish` AS `timeFinish`,`jjlourens2`.`job_schedule`.`myrand1` AS `myrand1`,`jjlourens2`.`job_schedule`.`fk_job` AS `fk_job`,`jjlourens2`.`setup_plumber`.`pk_plumber` AS `pk_plumber`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`setup_plumber`.`ptel` AS `ptel`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`excessVal` AS `excessVal`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`clientdetails`.`fk_postal` AS `fk_postal`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clTel3` AS `clTel3`,`jjlourens2`.`job_schedule`.`snooze` AS `snooze`,`jjlourens2`.`job_schedule`.`t0` AS `t0`,`jjlourens2`.`job_schedule`.`t1` AS `t1`,`jjlourens2`.`job_schedule`.`t2` AS `t2`,`jjlourens2`.`job_schedule`.`t3` AS `t3`,`jjlourens2`.`job_schedule`.`t4` AS `t4`,`jjlourens2`.`job_schedule`.`t5` AS `t5`,`jjlourens2`.`job_schedule`.`t6` AS `t6`,`jjlourens2`.`job_schedule`.`t7` AS `t7`,`jjlourens2`.`job_schedule`.`t8` AS `t8`,`jjlourens2`.`job_schedule`.`t9` AS `t9`,`jjlourens2`.`job_schedule`.`t10` AS `t10`,`jjlourens2`.`job_schedule`.`t11` AS `t11`,`jjlourens2`.`job_schedule`.`t12` AS `t12`,`jjlourens2`.`job_schedule`.`t13` AS `t13`,`jjlourens2`.`job_schedule`.`t14` AS `t14`,`jjlourens2`.`job_schedule`.`t15` AS `t15`,`jjlourens2`.`job_schedule`.`t16` AS `t16`,`jjlourens2`.`job_schedule`.`t17` AS `t17`,`jjlourens2`.`job_schedule`.`t18` AS `t18`,`jjlourens2`.`job_schedule`.`t19` AS `t19`,`jjlourens2`.`job_schedule`.`t20` AS `t20`,`jjlourens2`.`job_schedule`.`t21` AS `t21`,`jjlourens2`.`job_schedule`.`t22` AS `t22`,`jjlourens2`.`job_schedule`.`t23` AS `t23`,`jjlourens2`.`job_schedule`.`t24` AS `t24`,`jjlourens2`.`job_schedule`.`t25` AS `t25`,`jjlourens2`.`job_schedule`.`t26` AS `t26`,`jjlourens2`.`job_schedule`.`t27` AS `t27`,`jjlourens2`.`job_schedule`.`t28` AS `t28`,`jjlourens2`.`job_schedule`.`t29` AS `t29`,`jjlourens2`.`job_schedule`.`t30` AS `t30`,`jjlourens2`.`job_schedule`.`t31` AS `t31`,`jjlourens2`.`job_schedule`.`t32` AS `t32`,`jjlourens2`.`job_schedule`.`t33` AS `t33`,`jjlourens2`.`job_schedule`.`t34` AS `t34`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`job`.`fkInspection` AS `fkInspection`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`setup_scheduletype`.`pkaction` AS `pkaction`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job_type`.`pk_jtype` AS `pk_jtype`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`job_type`.`tNameShort` AS `tNameShort`,`jjlourens2`.`setup_scheduletype`.`ActionShort` AS `ActionShort`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`job_schedule`.`plumberRank` AS `plumberRank`,`jjlourens2`.`setup_plumber`.`fk_plumberType` AS `fk_plumberType`,`jjlourens2`.`setup_plumber_type`.`typeName` AS `typeName`,`jjlourens2`.`setup_plumber_type`.`pk_plumberType` AS `pk_plumberType` from (((((((`jjlourens2`.`job` join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job_schedule`.`fk_job` = `jjlourens2`.`job`.`pk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_plumber_type` on((`jjlourens2`.`setup_plumber_type`.`pk_plumberType` = `jjlourens2`.`setup_plumber`.`fk_plumberType`))) md5=486b57e327a447b84b49db12ccf97295 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=3 timestamp=2012-03-22 02:05:26 create-version=1 source=select `job`.`pk_job` AS `pk_job`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`fk_client` AS `fk_client`,`job_schedule`.`pk_schedule` AS `pk_schedule`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`capDate` AS `capDate`,`job_schedule`.`capUser` AS `capUser`,`job_schedule`.`fk_plumber` AS `fk_plumber`,`job_schedule`.`jobdescription` AS `jobdescription`,`job_schedule`.`cancellTime` AS `cancellTime`,`job_schedule`.`cancelled` AS `cancelled`,`job_schedule`.`cancelReason` AS `cancelReason`,`job_schedule`.`cancelluser` AS `cancelluser`,`job_schedule`.`jobType` AS `jobType`,`job_schedule`.`jobDoneInfo` AS `jobDoneInfo`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`jobDoneUser` AS `jobDoneUser`,`job_schedule`.`jobDoneTime` AS `jobDoneTime`,`job_schedule`.`isActive` AS `isActive`,`job_schedule`.`timeStart` AS `timeStart`,`job_schedule`.`timeFinish` AS `timeFinish`,`job_schedule`.`myrand1` AS `myrand1`,`job_schedule`.`fk_job` AS `fk_job`,`setup_plumber`.`pk_plumber` AS `pk_plumber`,`setup_plumber`.`pname` AS `pname`,`setup_plumber`.`ptel` AS `ptel`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`excessVal` AS `excessVal`,`job`.`fk_insurer` AS `fk_insurer`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`clientdetails`.`fk_postal` AS `fk_postal`,`clientdetails`.`clPostal` AS `clPostal`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clTel3` AS `clTel3`,`job_schedule`.`snooze` AS `snooze`,`job_schedule`.`t0` AS `t0`,`job_schedule`.`t1` AS `t1`,`job_schedule`.`t2` AS `t2`,`job_schedule`.`t3` AS `t3`,`job_schedule`.`t4` AS `t4`,`job_schedule`.`t5` AS `t5`,`job_schedule`.`t6` AS `t6`,`job_schedule`.`t7` AS `t7`,`job_schedule`.`t8` AS `t8`,`job_schedule`.`t9` AS `t9`,`job_schedule`.`t10` AS `t10`,`job_schedule`.`t11` AS `t11`,`job_schedule`.`t12` AS `t12`,`job_schedule`.`t13` AS `t13`,`job_schedule`.`t14` AS `t14`,`job_schedule`.`t15` AS `t15`,`job_schedule`.`t16` AS `t16`,`job_schedule`.`t17` AS `t17`,`job_schedule`.`t18` AS `t18`,`job_schedule`.`t19` AS `t19`,`job_schedule`.`t20` AS `t20`,`job_schedule`.`t21` AS `t21`,`job_schedule`.`t22` AS `t22`,`job_schedule`.`t23` AS `t23`,`job_schedule`.`t24` AS `t24`,`job_schedule`.`t25` AS `t25`,`job_schedule`.`t26` AS `t26`,`job_schedule`.`t27` AS `t27`,`job_schedule`.`t28` AS `t28`,`job_schedule`.`t29` AS `t29`,`job_schedule`.`t30` AS `t30`,`job_schedule`.`t31` AS `t31`,`job_schedule`.`t32` AS `t32`,`job_schedule`.`t33` AS `t33`,`job_schedule`.`t34` AS `t34`,`job`.`userInCharge` AS `userInCharge`,`job`.`fkInspection` AS `fkInspection`,`setup_scheduletype`.`ActionName` AS `ActionName`,`setup_scheduletype`.`pkaction` AS `pkaction`,`job_schedule`.`jobCat` AS `jobCat`,`job_type`.`pk_jtype` AS `pk_jtype`,`job_type`.`tName` AS `tName`,`job_type`.`tNameShort` AS `tNameShort`,`setup_scheduletype`.`ActionShort` AS `ActionShort`,`job`.`jbRefVal` AS `jbRefVal`,`job_schedule`.`plumberRank` AS `plumberRank`,`setup_plumber`.`fk_plumberType` AS `fk_plumberType`,`setup_plumber_type`.`typeName` AS `typeName`,`setup_plumber_type`.`pk_plumberType` AS `pk_plumberType` from (((((((`job` join `job_schedule` on((`job_schedule`.`fk_job` = `job`.`pk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) join `setup_plumber_type` on((`setup_plumber_type`.`pk_plumberType` = `setup_plumber`.`fk_plumberType`)))