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`,`jjlourens2`.`setup_plumber`.`rank` AS `rank`,`jjlourens2`.`job_schedule`.`specifictime` AS `specifictime`,`jjlourens2`.`job_schedule`.`excessInfo` AS `excessInfo`,`jjlourens2`.`job`.`limitVal` AS `limitVal`,`jjlourens2`.`job`.`salessms` AS `salessms`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user` 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`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job_schedule`.`capUser`)))
md5=608b7dcdde2ee5baaf6efa65a7c91832
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=3
timestamp=2016-06-19 14:44:13
create-version=1
source=SELECT
\njob.pk_job AS pk_job,
\nclientDetails.pk_client AS pk_client,
\nclientDetails.clSurname AS clSurname,
\nclientDetails.clName AS clName,
\njob.fk_client AS fk_client,
\njob_schedule.pk_schedule AS pk_schedule,
\njob_schedule.sheduleDate AS sheduleDate,
\njob_schedule.capDate AS capDate,
\njob_schedule.capUser AS capUser,
\njob_schedule.fk_plumber AS fk_plumber,
\njob_schedule.jobdescription AS jobdescription,
\njob_schedule.cancellTime AS cancellTime,
\njob_schedule.cancelled AS cancelled,
\njob_schedule.cancelReason AS cancelReason,
\njob_schedule.cancelluser AS cancelluser,
\njob_schedule.jobType AS jobType,
\njob_schedule.jobDoneInfo AS jobDoneInfo,
\njob_schedule.jobDone AS jobDone,
\njob_schedule.jobDoneUser AS jobDoneUser,
\njob_schedule.jobDoneTime AS jobDoneTime,
\njob_schedule.isActive AS isActive,
\njob_schedule.timeStart AS timeStart,
\njob_schedule.timeFinish AS timeFinish,
\njob_schedule.myrand1 AS myrand1,
\njob_schedule.fk_job AS fk_job,
\nsetup_plumber.pk_plumber AS pk_plumber,
\nsetup_plumber.pname AS pname,
\nsetup_plumber.ptel AS ptel,
\njob.jbClaimNo AS jbClaimNo,
\njob.excessVal AS excessVal,
\njob.fk_insurer AS fk_insurer,
\nsetup_insurer.pk_insurer AS pk_insurer,
\nsetup_insurer.insName AS insName,
\nclientDetails.fk_postal AS fk_postal,
\nclientDetails.clPostal AS clPostal,
\nclientDetails.clTel1 AS clTel1,
\nclientDetails.clTel2 AS clTel2,
\nclientDetails.clTel3 AS clTel3,
\njob_schedule.snooze AS snooze,
\njob_schedule.t0 AS t0,
\njob_schedule.t1 AS t1,
\njob_schedule.t2 AS t2,
\njob_schedule.t3 AS t3,
\njob_schedule.t4 AS t4,
\njob_schedule.t5 AS t5,
\njob_schedule.t6 AS t6,
\njob_schedule.t7 AS t7,
\njob_schedule.t8 AS t8,
\njob_schedule.t9 AS t9,
\njob_schedule.t10 AS t10,
\njob_schedule.t11 AS t11,
\njob_schedule.t12 AS t12,
\njob_schedule.t13 AS t13,
\njob_schedule.t14 AS t14,
\njob_schedule.t15 AS t15,
\njob_schedule.t16 AS t16,
\njob_schedule.t17 AS t17,
\njob_schedule.t18 AS t18,
\njob_schedule.t19 AS t19,
\njob_schedule.t20 AS t20,
\njob_schedule.t21 AS t21,
\njob_schedule.t22 AS t22,
\njob_schedule.t23 AS t23,
\njob_schedule.t24 AS t24,
\njob_schedule.t25 AS t25,
\njob_schedule.t26 AS t26,
\njob_schedule.t27 AS t27,
\njob_schedule.t28 AS t28,
\njob_schedule.t29 AS t29,
\njob_schedule.t30 AS t30,
\njob_schedule.t31 AS t31,
\njob_schedule.t32 AS t32,
\njob_schedule.t33 AS t33,
\njob_schedule.t34 AS t34,
\njob.userInCharge AS userInCharge,
\njob.fkInspection AS fkInspection,
\nsetup_scheduleType.ActionName AS ActionName,
\nsetup_scheduleType.pkaction AS pkaction,
\njob_schedule.jobCat AS jobCat,
\njob_type.pk_jtype AS pk_jtype,
\njob_type.tName AS tName,
\njob_type.tNameShort AS tNameShort,
\nsetup_scheduleType.ActionShort AS ActionShort,
\njob.jbRefVal AS jbRefVal,
\njob_schedule.plumberRank AS plumberRank,
\nsetup_plumber.fk_plumberType AS fk_plumberType,
\nsetup_plumber_type.typeName AS typeName,
\nsetup_plumber_type.pk_plumberType AS pk_plumberType,
\nsetup_plumber.rank AS rank,
\njob_schedule.specifictime AS specifictime,
\njob_schedule.excessInfo AS excessInfo,
\njob.limitVal AS limitVal,
\njob.salessms AS salessms,
\nsetup_user.userName,
\nsetup_user.pk_user
\nFROM
\n(((((((job
\nJOIN job_schedule ON ((job_schedule.fk_job = job.pk_job)))
\nJOIN clientDetails ON ((clientDetails.pk_client = job.fk_client)))
\nJOIN setup_plumber ON ((setup_plumber.pk_plumber = job_schedule.fk_plumber)))
\nJOIN setup_insurer ON ((setup_insurer.pk_insurer = job.fk_insurer)))
\nJOIN setup_scheduleType ON ((setup_scheduleType.pkaction = job_schedule.jobType)))
\nJOIN job_type ON ((job_type.pk_jtype = job_schedule.jobCat)))
\nJOIN setup_plumber_type ON ((setup_plumber_type.pk_plumberType = setup_plumber.fk_plumberType)))
\nINNER JOIN setup_user ON setup_user.pk_user = job_schedule.capUser