/*
  QED BITCH
  
  (of all time, add where clause timeSubmitted BETWEEN $startDate AND $endDate for fixed amounts)
  
  top 10 line
     most meters - SELECT mil,SUM(meters) FROM allproducts GROUP BY mil order by SUM(meters) DESC LIMIT 0,10
    least meters - SELECT mil,SUM(meters) FROM allproducts GROUP BY mil order by SUM(meters) ASC LIMIT 0,10
     most waste  - SELECT mil,SUM(wasteProd) FROM allproducts GROUP BY mil order by SUM(wasteProd) DESC LIMIT 0,10
    least waste  - SELECT mil,SUM(wasteProd) FROM allproducts GROUP BY mil order by SUM(wasteProd) ASC LIMIT 0,10
  most efficient - SELECT mil,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY mil order by eff DESC LIMIT 0,10
 least efficient - SELECT mil,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY mil order by eff ASC LIMIT 0,10
  
  top 10 product 
     most meters - SELECT product,SUM(meters) FROM allproducts GROUP BY product order by SUM(meters) DESC LIMIT 0,10
    least meters - SELECT product,SUM(meters) FROM allproducts GROUP BY product order by SUM(meters) ASC LIMIT 0,10
     most waste  - SELECT product,SUM(wasteProd) FROM allproducts GROUP BY product order by SUM(wasteProd) DESC LIMIT 0,10
    least waste  - SELECT product,SUM(wasteProd) FROM allproducts GROUP BY product order by SUM(wasteProd) ASC LIMIT 0,10
  most efficient - SELECT product,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY product order by eff DESC LIMIT 0,10
 least efficient - SELECT product,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY product order by eff ASC LIMIT 0,10
 
  top 10 group
     most meters - SELECT productGroup,SUM(meters) FROM allproducts GROUP BY productGroup order by SUM(meters) DESC LIMIT 0,10
    least meters - SELECT productGroup,SUM(meters) FROM allproducts GROUP BY productGroup order by SUM(meters) ASC LIMIT 0,10
     most waste  - SELECT productGroup,SUM(wasteProd) FROM allproducts GROUP BY productGroup order by SUM(wasteProd) DESC LIMIT 0,10
    least waste  - SELECT productGroup,SUM(wasteProd) FROM allproducts GROUP BY productGroup order by SUM(wasteProd) ASC LIMIT 0,10
  most efficient - SELECT productGroup,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY productGroup order by eff DESC LIMIT 0,10
 least efficient - SELECT productGroup,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY productGroup order by eff ASC LIMIT 0,10
 
  top 10 shift
     most meters - SELECT shift,SUM(meters) FROM allproducts GROUP BY shift order by SUM(meters) DESC LIMIT 0,10
    least meters - SELECT shift,SUM(meters) FROM allproducts GROUP BY shift order by SUM(meters) ASC LIMIT 0,10
     most waste  - SELECT shift,SUM(wasteProd) FROM allproducts GROUP BY shift order by SUM(wasteProd) DESC LIMIT 0,10
    least waste  - SELECT shift,SUM(wasteProd) FROM allproducts GROUP BY shift order by SUM(wasteProd) ASC LIMIT 0,10
  most efficient - SELECT shift,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY shift order by eff DESC LIMIT 0,10
 least efficient - SELECT shift,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY shift order by eff ASC LIMIT 0,10           
            
 
  created alternate view 'allproducts' that is setup as:
  timeSubmitted  mil  shift  product  productGroup  meters  wasteProd  eff  
*/