(select `vcimfg`.`mpsr`.`submitted` AS `timeSubmitted`, `vcimfg`.`mpsr`.`mil3` AS `mil`, 3 AS `shift` `vcimfg`.`mpsr`.`product3` AS `product`, `vcimfg`.`mpsr`.`grp` AS `productGroup`, `vcimfg`.`mpsr`.`meters3` AS `meters`, `vcimfg`.`mpsr`.`wasteProd3` AS `wasteProd`, `vcimfg`.`mpsr`.`eff3` AS `eff` from `vcimfg`.`mpsr`) union all(select `vcimfg`.`mpsr`.`submitted` AS `timeSubmitted`, `vcimfg`.`mpsr`.`mil1` AS `mil`, 1 AS `shift` `vcimfg`.`mpsr`.`product1` AS `product`, `vcimfg`.`mpsr`.`grp` AS `productGroup`, `vcimfg`.`mpsr`.`meters1` AS `meters`, `vcimfg`.`mpsr`.`wasteProd1` AS `wasteProd`, `vcimfg`.`mpsr`.`eff1` AS `eff` from `vcimfg`.`mpsr`) union all(select `vcimfg`.`mpsr`.`submitted` AS `timeSubmitted`, `vcimfg`.`mpsr`.`mil2` AS `mil`, 2 AS `shift` `vcimfg`.`mpsr`.`product2` AS `product`, `vcimfg`.`mpsr`.`grp` AS `productGroup`, `vcimfg`.`mpsr`.`meters2` AS `meters`, `vcimfg`.`mpsr`.`wasteProd2` AS `wasteProd`, `vcimfg`.`mpsr`.`eff2` AS `eff` from `vcimfg`.`mpsr`)