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