TYPE=VIEW
query=select `view_schedule_taken`.`pk_job` AS `pk_job`,`view_schedule_taken`.`snooze` AS `snooze`,`view_schedule_taken`.`jobDone` AS `jobDone`,if((`view_schedule_taken`.`t0` = 1),((`view_schedule_taken`.`t0` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t0`,if((`view_schedule_taken`.`t1` = 1),((`view_schedule_taken`.`t1` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t1`,if((`view_schedule_taken`.`t2` = 1),((`view_schedule_taken`.`t2` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t2`,if((`view_schedule_taken`.`t3` = 1),((`view_schedule_taken`.`t3` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t3`,if((`view_schedule_taken`.`t4` = 1),((`view_schedule_taken`.`t4` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t4`,if((`view_schedule_taken`.`t5` = 1),((`view_schedule_taken`.`t5` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t5`,if((`view_schedule_taken`.`t6` = 1),((`view_schedule_taken`.`t6` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t6`,if((`view_schedule_taken`.`t7` = 1),((`view_schedule_taken`.`t7` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t7`,if((`view_schedule_taken`.`t8` = 1),((`view_schedule_taken`.`t8` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t8`,if((`view_schedule_taken`.`t9` = 1),((`view_schedule_taken`.`t9` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t9`,if((`view_schedule_taken`.`t10` = 1),((`view_schedule_taken`.`t10` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t10`,if((`view_schedule_taken`.`t11` = 1),((`view_schedule_taken`.`t11` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t11`,if((`view_schedule_taken`.`t12` = 1),((`view_schedule_taken`.`t12` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t12`,if((`view_schedule_taken`.`t13` = 1),((`view_schedule_taken`.`t13` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t13`,if((`view_schedule_taken`.`t14` = 1),((`view_schedule_taken`.`t14` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t14`,if((`view_schedule_taken`.`t15` = 1),((`view_schedule_taken`.`t15` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t15`,if((`view_schedule_taken`.`t16` = 1),((`view_schedule_taken`.`t16` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t16`,if((`view_schedule_taken`.`t17` = 1),((`view_schedule_taken`.`t17` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t17`,if((`view_schedule_taken`.`t18` = 1),((`view_schedule_taken`.`t18` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t18`,if((`view_schedule_taken`.`t19` = 1),((`view_schedule_taken`.`t19` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t19`,if((`view_schedule_taken`.`t20` = 1),((`view_schedule_taken`.`t20` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t20`,if((`view_schedule_taken`.`t21` = 1),((`view_schedule_taken`.`t21` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t21`,if((`view_schedule_taken`.`t22` = 1),((`view_schedule_taken`.`t22` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t22`,if((`view_schedule_taken`.`t23` = 1),((`view_schedule_taken`.`t23` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t23`,if((`view_schedule_taken`.`t24` = 1),((`view_schedule_taken`.`t24` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t24`,if((`view_schedule_taken`.`t25` = 1),((`view_schedule_taken`.`t25` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t25`,if((`view_schedule_taken`.`t26` = 1),((`view_schedule_taken`.`t26` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t26`,if((`view_schedule_taken`.`t27` = 1),((`view_schedule_taken`.`t27` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t27`,if((`view_schedule_taken`.`t28` = 1),((`view_schedule_taken`.`t28` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t28`,if((`view_schedule_taken`.`t29` = 1),((`view_schedule_taken`.`t29` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t29`,if((`view_schedule_taken`.`t30` = 1),((`view_schedule_taken`.`t30` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t30`,if((`view_schedule_taken`.`t31` = 1),((`view_schedule_taken`.`t31` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t31`,if((`view_schedule_taken`.`t32` = 1),((`view_schedule_taken`.`t32` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t32`,if((`view_schedule_taken`.`t33` = 1),((`view_schedule_taken`.`t33` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t33`,if((`view_schedule_taken`.`t34` = 1),((`view_schedule_taken`.`t34` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action34`,`view_schedule_taken`.`pk_schedule` AS `pk_schedule`,`view_schedule_taken`.`cancelled` AS `cancelled`,`view_schedule_taken`.`jobType` AS `jobType`,`view_schedule_taken`.`timeStart` AS `timeStart`,`view_schedule_taken`.`pk_plumber` AS `pk_plumber`,`view_schedule_taken`.`ActionName` AS `ActionName`,`view_schedule_taken`.`sheduleDate` AS `sheduleDate`,`view_schedule_taken`.`pname` AS `pname`,`view_schedule_taken`.`plumberRank` AS `plumberRank`,`view_schedule_taken`.`fk_plumberType` AS `fk_plumberType`,`view_schedule_taken`.`typeName` AS `typeName`,`view_schedule_taken`.`rank` AS `rank` from `jjlourens2`.`view_schedule_taken` where ((`view_schedule_taken`.`jobType` <> 1) and (`view_schedule_taken`.`jobType` <> 4))
md5=f8eeb69bf993ddf3ddd273fbb18877d0
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2012-05-29 00:02:28
create-version=1
source=select `view_schedule_taken`.`pk_job` AS `pk_job`,`view_schedule_taken`.`snooze` AS `snooze`,`view_schedule_taken`.`jobDone` AS `jobDone`,if((`view_schedule_taken`.`t0` = 1),((`view_schedule_taken`.`t0` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t0`,if((`view_schedule_taken`.`t1` = 1),((`view_schedule_taken`.`t1` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t1`,if((`view_schedule_taken`.`t2` = 1),((`view_schedule_taken`.`t2` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t2`,if((`view_schedule_taken`.`t3` = 1),((`view_schedule_taken`.`t3` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t3`,if((`view_schedule_taken`.`t4` = 1),((`view_schedule_taken`.`t4` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t4`,if((`view_schedule_taken`.`t5` = 1),((`view_schedule_taken`.`t5` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t5`,if((`view_schedule_taken`.`t6` = 1),((`view_schedule_taken`.`t6` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t6`,if((`view_schedule_taken`.`t7` = 1),((`view_schedule_taken`.`t7` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t7`,if((`view_schedule_taken`.`t8` = 1),((`view_schedule_taken`.`t8` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t8`,if((`view_schedule_taken`.`t9` = 1),((`view_schedule_taken`.`t9` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t9`,if((`view_schedule_taken`.`t10` = 1),((`view_schedule_taken`.`t10` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t10`,if((`view_schedule_taken`.`t11` = 1),((`view_schedule_taken`.`t11` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t11`,if((`view_schedule_taken`.`t12` = 1),((`view_schedule_taken`.`t12` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t12`,if((`view_schedule_taken`.`t13` = 1),((`view_schedule_taken`.`t13` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t13`,if((`view_schedule_taken`.`t14` = 1),((`view_schedule_taken`.`t14` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t14`,if((`view_schedule_taken`.`t15` = 1),((`view_schedule_taken`.`t15` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t15`,if((`view_schedule_taken`.`t16` = 1),((`view_schedule_taken`.`t16` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t16`,if((`view_schedule_taken`.`t17` = 1),((`view_schedule_taken`.`t17` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t17`,if((`view_schedule_taken`.`t18` = 1),((`view_schedule_taken`.`t18` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t18`,if((`view_schedule_taken`.`t19` = 1),((`view_schedule_taken`.`t19` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t19`,if((`view_schedule_taken`.`t20` = 1),((`view_schedule_taken`.`t20` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t20`,if((`view_schedule_taken`.`t21` = 1),((`view_schedule_taken`.`t21` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t21`,if((`view_schedule_taken`.`t22` = 1),((`view_schedule_taken`.`t22` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t22`,if((`view_schedule_taken`.`t23` = 1),((`view_schedule_taken`.`t23` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t23`,if((`view_schedule_taken`.`t24` = 1),((`view_schedule_taken`.`t24` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t24`,if((`view_schedule_taken`.`t25` = 1),((`view_schedule_taken`.`t25` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t25`,if((`view_schedule_taken`.`t26` = 1),((`view_schedule_taken`.`t26` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t26`,if((`view_schedule_taken`.`t27` = 1),((`view_schedule_taken`.`t27` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t27`,if((`view_schedule_taken`.`t28` = 1),((`view_schedule_taken`.`t28` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t28`,if((`view_schedule_taken`.`t29` = 1),((`view_schedule_taken`.`t29` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t29`,if((`view_schedule_taken`.`t30` = 1),((`view_schedule_taken`.`t30` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t30`,if((`view_schedule_taken`.`t31` = 1),((`view_schedule_taken`.`t31` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t31`,if((`view_schedule_taken`.`t32` = 1),((`view_schedule_taken`.`t32` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t32`,if((`view_schedule_taken`.`t33` = 1),((`view_schedule_taken`.`t33` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t33`,if((`view_schedule_taken`.`t34` = 1),((`view_schedule_taken`.`t34` + `view_schedule_taken`.`jobDone`) + `view_schedule_taken`.`snooze`),0) AS `t34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`jbinfo`,NULL) AS `infot34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`pk_job`,NULL) AS `cl34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`timeStart`,NULL) AS `ti34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`jobCat`,NULL) AS `cat34`,if((`view_schedule_taken`.`t0` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action0`,if((`view_schedule_taken`.`t1` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action1`,if((`view_schedule_taken`.`t2` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action2`,if((`view_schedule_taken`.`t3` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action3`,if((`view_schedule_taken`.`t4` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action4`,if((`view_schedule_taken`.`t5` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action5`,if((`view_schedule_taken`.`t6` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action6`,if((`view_schedule_taken`.`t7` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action7`,if((`view_schedule_taken`.`t8` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action8`,if((`view_schedule_taken`.`t9` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action9`,if((`view_schedule_taken`.`t10` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action10`,if((`view_schedule_taken`.`t11` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action11`,if((`view_schedule_taken`.`t12` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action12`,if((`view_schedule_taken`.`t13` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action13`,if((`view_schedule_taken`.`t14` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action14`,if((`view_schedule_taken`.`t15` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action15`,if((`view_schedule_taken`.`t16` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action16`,if((`view_schedule_taken`.`t17` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action17`,if((`view_schedule_taken`.`t18` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action18`,if((`view_schedule_taken`.`t19` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action19`,if((`view_schedule_taken`.`t20` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action20`,if((`view_schedule_taken`.`t21` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action21`,if((`view_schedule_taken`.`t22` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action22`,if((`view_schedule_taken`.`t23` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action23`,if((`view_schedule_taken`.`t24` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action24`,if((`view_schedule_taken`.`t25` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action25`,if((`view_schedule_taken`.`t26` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action26`,if((`view_schedule_taken`.`t27` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action27`,if((`view_schedule_taken`.`t28` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action28`,if((`view_schedule_taken`.`t29` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action29`,if((`view_schedule_taken`.`t30` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action30`,if((`view_schedule_taken`.`t31` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action31`,if((`view_schedule_taken`.`t32` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action32`,if((`view_schedule_taken`.`t33` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action33`,if((`view_schedule_taken`.`t34` = 1),`view_schedule_taken`.`pkaction`,NULL) AS `action34`,`view_schedule_taken`.`pk_schedule` AS `pk_schedule`,`view_schedule_taken`.`cancelled` AS `cancelled`,`view_schedule_taken`.`jobType` AS `jobType`,`view_schedule_taken`.`timeStart` AS `timeStart`,`view_schedule_taken`.`pk_plumber` AS `pk_plumber`,`view_schedule_taken`.`ActionName` AS `ActionName`,`view_schedule_taken`.`sheduleDate` AS `sheduleDate`,`view_schedule_taken`.`pname` AS `pname`,`view_schedule_taken`.`plumberRank` AS `plumberRank`,`view_schedule_taken`.`fk_plumberType` AS `fk_plumberType`,`view_schedule_taken`.`typeName` AS `typeName`,`view_schedule_taken`.`rank` AS `rank` from `view_schedule_taken` where ((`view_schedule_taken`.`jobType` <> 1) and (`view_schedule_taken`.`jobType` <> 4))